Обсуждение: Rotation of security logs in Postgres 7.4.11

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
afterthe 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

John Zubac
Operations / DBA
Internetsecure Inc.
+1.905.469.6522 X252
jzubac@internetsecure.com
Gpg Fingerprint: A178 EC10 07D4 B242 8500 F817 D396 F05F D978 3D92

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
postmasterafter 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073