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

Re: Postgres server output log

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: Mintoo Lall <tlqmail(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres server output log
Date: 2003-01-30 05:22:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

This is someones' elses' posting that i have preserved
shud be useful.



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 {
    rotate 2
    errors mendola(at)bigfoot(dot)com
    create 0664 postgres postgres
             /usr/bin/killall -HUP syslogd

change the email address of course :-)

3) Put the following line on your /etc/syslog.conf

# Save postgresql logs



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 ,
India's Leading B2B eMarketplace.

In response to


pgsql-admin by date

Next:From: Oliver ElphickDate: 2003-01-30 12:32:03
Subject: Re: Database Management Setup
Previous:From: Mintoo LallDate: 2003-01-30 04:51:05
Subject: Postgres server output log

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