Re: Postgres server output log - Mailing list pgsql-admin

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@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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

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