Rotation of security logs in Postgres 7.4.11

From: "John Zubac" <jzubac(at)internetsecure(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Rotation of security logs in Postgres 7.4.11
Date: 2006-01-30 22:13:45
Message-ID: 19BA112CA339EB47B0E90EBAE50D132D01865BF5@exch1.internal.priv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-01-30 22:19:23 Re: Logging statements and parameter values
Previous Message Tom Lane 2006-01-30 22:05:19 Re: pg 8.1.2 ERROR: direct correlated subquery unsupported as initplan