Обсуждение: 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