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