From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: A single escape required for log_filename |
Date: | 2009-01-13 22:36:08 |
Message-ID: | 496D1758.5080703@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Stephen Frost wrote:
> Joshua,
>
> * Joshua D. Drake (jd(at)commandprompt(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-01-13 23:26:42 | reloptions with a "namespace" |
Previous Message | Peter Eisentraut | 2009-01-13 22:29:39 | So, what locale should the regression tests run in? |