Re: Postgres server output log - Mailing list pgsql-admin
From | Tilo Schwarz |
---|---|
Subject | Re: Postgres server output log |
Date | |
Msg-id | 200302021547.30797.mail@tilo-schwarz.de Whole thread Raw |
In response to | Re: Postgres server output log (Bruce Momjian <pgman@candle.pha.pa.us>) |
List | pgsql-admin |
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@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
pgsql-admin by date: