Postgres Pro
Downloads
Home   >   mailing lists

Thread: Log File Maintainance

Log File Maintainance

From
Inpreet Singh
Date:
Hello,
 
I am working on live server where we have installed postgres database as our back end. But now the problem is due to continues work on postgres, size of log files has become problem for us. And the partition where our postgres exists is full. Postmaster is not working now. I tried to rotate log file by adding lines in postgresql.conf
****************************************************
syslog = 2                      # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
********************************
But it doesn't working. Is there anything else I had to due in this respect. I think I am missing some point.
 
Also I had written rotate script and save it at location :/etc/logrotate.d
******************************************************
/usr/local/pgsql/data/serverlog
{
        weekly
        notifempty
        rotate 2
        create
        /bin/kill -HUP `cat /usr/local/pgsql/data/postmaster.pid 2> /dev/null` 2> /dev/null || true
        endscript
}
***************************************************
But when I am executing following command it is flagging error
**************************************************
[root@iemstesting logrotate.d]# logrotate -f -v postgres
reading config file postgres
reading config info for /usr/local/pgsql/data/logfile
 
error: postgres:6 unexpected log filename
*************************************************
 
Please guide me thru...............
Inpreet Singh
 

Re: Log File Maintainance

From
Scott Marlowe
Date:
On Mon, 2005-04-11 at 00:20, Inpreet Singh wrote:
> Hello,
>
> I am working on live server where we have installed postgres database
> as our back end. But now the problem is due to continues work on
> postgres, size of log files has become problem for us. And the
> partition where our postgres exists is full.

I use apache's log rotator and start the server in rc.local:

su - postgres -c 'pg_ctl start | /usr/sbin/rotatelogs $PGDATA/logs/pgsql
86400 2>1& &'

Re: Log File Maintainance

From
Scott Marlowe
Date:
A followup, there was a type in my last post, shoulda been:

su - postgres -c 'pg_ctl start | /usr/sbin/rotatelogs $PGDATA/logs/pgsql
86400 2>&1 &'

Note that change in the 2>&1...