Database Reference
In-Depth Information
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 access to the database system, which is what we call
the platform on which the database runs.
How to do it...
The server log can be in a few different places, so first let's list all of those, so that
we can locate the log, or decide where we want it to be placed:
F
Server log may be in a directory beneath the data directory
F
Server log may be in a directory elsewhere on the file system
F
Server log may be redirected to syslog
F
There may be no server log at all - time to add one soon
If not redirected to syslog, the server log consists of one or more files. You can change
the name of these files, so it may not always be the same on every system.
On Debian or Ubuntu systems the default server log location is as follows:
F
/var/log/postgresql
The current server log file is named
postgresql-N.n-main.log
, where
N.n
is the major
and minor release number of the server, for example 9.0. Older log files are numbered as
postgresql-8.3-main.log.1
, the higher the number, the older the file.
On Red Hat, RHEL, CentOS, or Fedora the default server log location is a subdirectory
of the data directory as follows:
F
/var/lib/pgsql/data/pg_log
On Windows systems the messages are sent to the Windows Eventlog by default.
