Stephen Frost wrote:
> Joshua,
>
> * Joshua D. Drake (jd@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