Postgres Pro
Downloads
Home   >   mailing lists

Rotation of security logs in Postgres 7.4.11 - Mailing list pgsql-general

From John Zubac
Subject Rotation of security logs in Postgres 7.4.11
Date
Msg-id 19BA112CA339EB47B0E90EBAE50D132D01865BF5@exch1.internal.priv
Whole thread Raw
Responses Re: Rotation of security logs in Postgres 7.4.11  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Transaction safety and large objects. Possible?
Next
From: Ted Powell
Date:
Subject: Re: Logging statements and parameter values