Re: Postgres server output log
От | Bruce Momjian |
---|---|
Тема | Re: Postgres server output log |
Дата | |
Msg-id | 200302020954.h129sRe17404@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Postgres server output log ("Rajesh Kumar Mallah." <mallah@trade-india.com>) |
Ответы |
Re: Postgres server output log
|
Список | 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
В списке pgsql-admin по дате отправления: