O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Locate the database server message log

The database server log is the record of all messages recorded by the database server. This is the first place to look if you have server problems, and a good place to check regularly.

It will have messages in it that look something like the following:

2010-01-19 21:23:52 GMT LOG: database system was not properly shut down; automatic recovery in progress
2010-01-19 21:23:52 GMT LOG: record with zero length at 0/49AF90
2010-01-19 21:23:52 GMT LOG: redo is not required
2010-01-19 21:23:52 GMT LOG: autovacuum launcher started
2010-01-19 21:23:52 GMT LOG: database system is ready to accept connections

We'll explain some more about it once we've located the files.

Getting ready

You'll need to get operating system ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required