Re: Log File Maintainance - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Log File Maintainance
Date
Msg-id 1113313827.20921.111.camel@state.g2switchworks.com
Whole thread Raw
In response to Log File Maintainance  (Inpreet Singh <Singh.Inpreet@netsity.com>)
List 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& &'

pgsql-admin by date:

Previous
From: "Lic. Guillermo González"
Date:
Subject: upper() with LATIN1 problem
Next
From: Scott Marlowe
Date:
Subject: Re: Log File Maintainance