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: 200301301052.36984.mallah@trade-india.com (view raw or flat)
Thread:
Lists: pgsql-admin


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.



In response to

Responses

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-2014 The PostgreSQL Global Development Group