Re: Log rotation - Mailing list pgsql-admin

From Andre Schubert
Subject Re: Log rotation
Date
Msg-id 3CA93986.C721718E@km3.de
Whole thread Raw
In response to Log rotation  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
Gaetano Mendola schrieb:
>
> Hi to all,
>
> I configured the log rotation of postgresql  started in this way:
>
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -D $PGDATA -p
> /usr/bin/postmaster start  > /var/log/postgresql.log 2>&1" < /dev/null
>
> with the log rotate file:
>
> /var/log/postgresql.log {
>     compress
>     rotate 5
>     size=10000k
>     create 0664 postgres postgres
>     daily
>     sharedscripts
>     copytruncate
> }
>
> the problem now is that the postgres server is really
> stressed and write continuosly on the log file
> and the file is not truncated!!!!!
>
> anyone have any idea??

You can use multilog on linux.

pgsql-admin by date:

Previous
From: Andre Schubert
Date:
Subject: Re: Last_Inserted Value
Next
From: Tom Lane
Date:
Subject: Re: Vacuum returns error