Re: Postgres server output log

Hmm.. thank you for pointing out!.

i have marked a Cc to  Gaetano Mendola [ the original sinner ;-) ]

regds
mallah.

On Thursday 30 January 2003 06:10 pm, Oliver Elphick wrote:
> On Thu, 2003-01-30 at 05:22, Rajesh Kumar Mallah. wrote:
> > This is someones' elses' posting that i have preserved
> > shud be useful.
>
> ...
>
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
> >
> > Well,
> > the most correct way to do a logrotate is ( Redhat ):
>
> ...
>
> > 2)  Put on the directory /etc/logrotate.d a file called
> > 'postgres' with the following lines:
> >
> > /var/log/postgresql.log {
> >     compress
> >     rotate 2
> >     size=10000k
> >     errors mendola@bigfoot.com
> >     create 0664 postgres postgres
> >     daily
> >     postrotate
> >              /usr/bin/killall -HUP syslogd
> >     endscript
> > }
>
> ...
>

> This won't work as it stands with PostgreSQL, because the hangup signal
> does not make the postmaster reopen the log file.  Instead of that
> postrotate section, you need to use logrotate's copytruncate option,
> which will copy the logfile to another file before zeroing the logfile.
>
> Depending on what is being logged, you may want to change the
> permissions to 660; there may be stuff in the logs that you don't want
> to reveal to the world.  (With copytruncate, I think the create option
> applies to the copy files rather than to the original logfile.)

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)26152172 (221) (L) 9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.