log rotate and open connections

Поиск
Список
Период
Сортировка
От Bob Gobeille
Тема log rotate and open connections
Дата
Msg-id 1929084F-F116-4A47-AF62-94AE50407C1C@hp.com
обсуждение исходный текст
Список 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)



В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Relational database design book
Следующее
От: Karsten Hilbert
Дата:
Сообщение: how to find foreign key details (column, that is)