Re: Postgres server output log

Is all this stuff in our docs?

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

Rajesh Kumar Mallah. wrote:
>
>
>
> 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(at)bigfoot(dot)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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073