Re: Postgres logs w/ Logrotate

On Fri, 2003-03-28 at 14:35, Renê Salomão wrote:
> Hi list,
>
>  Is there any extra configuration to run postgresql 7.3.2 logs
> with logrotate?
>  I tried the following script at /etc/logrotate.d:
>
> /var/log/postgresql/postgresql.log {
>   daily
>   rotate 5
>   compress
>   create
> }
>
>  the problem is that after it does its first rotation (create a
> compressed copy of the log) and the new log file created, any new
> message originated from postgresql is not saved in log file...
>
>  I do start postgres with:
>
>   pg_ctl start -o -i -l /var/log/postgresql/postgresql.log
>
>
>  What am I doing wrong? Does Postgresql need to be restarted? How can I
> do it?

You probably need the copytruncate option in your logrotate script.  The
postmaster does not close its logfile, so it continues to write to the
file you have rotated out.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If we confess our sins, he is faithful and just to
      forgive us our sins, and to cleanse us from all
      unrighteousness."           I John 1:9