Re: Postgres server output log

This is someones' elses' posting that i have preserved
shud be useful.

regds
mallah.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`

Well,
the most correct way to do a logrotate is ( Redhat ):

1) Put on your postgresql.conf the following lines:

syslog = 2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

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
}

change the email address of course :-)

3) Put the following line on your /etc/syslog.conf

# Save postgresql logs
LOCAL0.*
/var/log/postgresql.log


Ciao
Gaetano

-------------------------------------------------------


On Thursday 30 January 2003 10:21 am, Mintoo Lall wrote:
> Hi Everybody,
>
> I am new to postgresql. I started my postgres using the command
>
> postmaster -D /usr/local/pgsql/data > logfile 2>&1 &
>
> Now after running it for some time I noticed that the size of this logfile
> has become very large. Is this logfile used to store any important
> information used by the database for recovery in case of crash? If no,is
> there any way I can specify a different log file withouting stopping the
> server ?
>
> Any help is appreciated.
>
> Thanks,
>
> Tarun
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now

--


--------------------------------------------
                                Regds Mallah
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.