Skip site navigation (1) Skip section navigation (2)

Re: Postgres server output log

From: Mintoo Lall <tlqmail(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres server output log
Date: 2003-01-31 19:24:51
Message-ID: 20030131192451.82139.qmail@web14809.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks guys for the replies.I am using redhat linux 8.0 and postgres 7.2.3. Istarted my postgresql server with the followingcommand after making the changes pg_ctl start -D /usr/local/pgsql/data   -o "-i"If I understood correctly the syslog should havecreated a log file at /var/log/postgresql.log but itdidnt do it. I am not sure what is the correct way ofstarting the postgres after making the changes so asto use the syslog and the log rotation script. Anyhelp is appreciated.Thanks,Tarun--- "Rajesh Kumar Mallah." <mallah(at)trade-india(dot)com>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 followin
 g 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 th
 e> > 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.> > __________________________________________________Do you Yahoo!?Yahoo! Mail Plus - Powerful. Affordable. Sign up now.http://mailplus.yahoo.com---------------------------(end of broadcast)---------------------------TIP 4: Don't 'kill -9' the postmaster



---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

pgsql-admin by date

Next:From: Mintoo LallDate: 2003-01-31 19:24:54
Subject: Re: Postgres server output log
Previous:From: Sill-II, StephenDate: 2003-01-31 16:56:48
Subject: Re: Making connections to postgres under FreeBSD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group