Re: Rotation of security logs in Postgres 7.4.11

John Zubac wrote:
> Hi Everyone
>
> What is the best way to go about rotating the postgres security log file on postgresql 7.4.11 under openbsd 3.7?
>
> I got it to work logging to a file but as soon as the file rotates the new log is dead. Would reloading the postmaster after the log rotation resolve this?
>
> I also was not able to get it to log to syslog. Maybe I missed something here. Any help would be kindly appreciated

Have you read our documenation on this issue?

http://www.postgresql.org/docs/8.1/static/logfile-maintenance.html

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073