"Andy Shellam" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> writes:
> What I want PostgreSQL to do is put a log file "postgresql.log" in
> "/var/log/pgsql" - I have an application that handles log rotations, so
> would prefer to do it with that, rather than have PostgreSQL do the
You don't really have any choice about the matter --- Postgres will not
use a single fixed filename because that would be guaranteed to lose log
entries across a rotation.
> I would have thought my config shown below would have made this happen, but
> it doesn't appear so. Instead PostgreSQL creates a file called "
> postgresql.log.1200003749" in /var/log/pgsql.
> Best of it is, I cannot work out what those numbers mean.
Per the documentation, Postgres appends the Unix epoch of the file's
creation time if the given pattern hasn't got any %-escapes.
Looks like that corresponds to Thu Jan 10 2008, 17:22:29 EST.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Joshua D. Drake||Date: 2008-01-11 00:22:58|
|Subject: Re: 8.3 RC1 - Logging and filenames|
|Previous:||From: Kevin Kempter||Date: 2008-01-10 23:08:48|
|Subject: Re: PITR warm-standby with 8.2 setup questions|