Re: Postgres server output log

Bruce Momjian writes:

> Is all this stuff in our docs?

At least I didn't find it, while I was searching for "how to logrotate the
postmaster logfile properly" last week (IIRC only the "pipe postmasters
output into a logrotate script" possibility is discussed, not the way like 2)
below). Finally I had a look how SuSE does it and it's very similar to 2)
shown below (but they have the "copytruncate" option).

Best regards,

Tilo

>
> ---------------------------------------------------------------------------
>
> 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