log rotate and open connections

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)

Browse pgsql-general by date

  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