Re: [GENERAL] log sql?

On Tue, 30 Jul 2002, Andrew Sullivan wrote:

> On Tue, Jul 30, 2002 at 09:53:23AM -0700, Laurette Cisneros wrote:
> > Yes indeed...the size has reach 9.6M in 15 minutes...it is spewing a lot of
> > info.  Hmmm....
> 
> You really need some mechanism for rotating your logs if you are
> going to use them.  Otherwise, they become too unwieldy.

If one has apache installed, one has the mechanism installed.  Apache has 
a nice little log rotation utility called rotatelogs that can used for 
this purpose, just put it into the path of the postgres user and start the 
database like so:

pg_ctl start | rotatelogs "$PGDATA/logs/pgsql" 86400 &

where $PGDATA/logs is a directory you made and pgsql will be the name all 
your log files start with.