I'm on 8.1 and having a client hang on log rotates.
To make the problem easier to duplicate, log rotates were set to two
minutes:
redirect_stderr = on # Enable capturing of stderr
into log
log_directory = 'pg_log' # enabled for 2 minute
rotation test
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # enabled for 2 minute
rotation test
log_rotation_age = 2 # changing to every 2 minutes to try
and hang scheduler.
We have a daemon (written in C using libpq) that keeps a persistent
open db connection.
When the log rotates, daemon queries hang instead of returning an
error about the lost connection.
Suggestions?
Thanks,
Bob Gobeille
Hewlett Packard
Open Source Program Office
(and http://fossology.org)