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
