Re: Log File Maintainance

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Log File Maintainance
Date: 2005-04-12 13:50:27
Message-ID: 1113313827.20921.111.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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& &'

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-04-12 13:51:56 Re: Log File Maintainance
Previous Message Alex Zendel 2005-04-12 13:47:27 question about wal and point in time recovery