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.