From: | Bob Gobeille <bob(dot)gobeille(at)hp(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | log rotate and open connections |
Date: | 2008-12-14 16:28:11 |
Message-ID: | 1929084F-F116-4A47-AF62-94AE50407C1C@hp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2008-12-14 18:41:24 | how to find foreign key details (column, that is) |
Previous Message | Rich Shepard | 2008-12-14 15:49:45 | Re: Relational database design book |