Re: Recycle error logs

On Sat, 2006-07-15 at 02:37, adey wrote:
> Please advise if there is a way to start a fresh Postgresql error /
> output log at regular intervals?
> We are tuning a "new toproduction" system, so I have all the SQL
> logged, but the file gets too big and cumbersome, so I'd like to start
> a new one each morning without restarting Postgres.

As mentioned previously, it's built into 8.0 and up.  If you're stuck on
a version before that, you can use apache's log rotator to do the job.

Something like this:

pg_ctl start | /usr/sbin/rotatelogs /logs/pgsql 86400