Stephen Frost wrote:
Joshua,
* Joshua D. Drake (j...@commandprompt.com) wrote:
When I set it up, it automatically appended the time so I got:
postgresql.log.1231878270
That seems a bit, well wrong. If I say I want postgresql.log I should
get postgresql.log.
Or am I completely cranked?
No. I agree with you completely. I'm also well versed in the
requirements of log handling and log rotation. Debian handles this by
passing a '-l' to pg_ctl (usually
/var/log/postgresql/postgresql-X.Y-CLUSTER.log), rotation is handled
by logrotate.
Then Debian is (surprise!) not doing the smartest thing. Not using the
logging collector means you miss several possible advantages, including
CSV logs and protection against multiplexed log lines.
Surely a good log rotator allows a custom rotation action (in this case,
connecting to postgres and calling 'select pg_rotate_logfile()' )
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
