pg_ctl inappropriately timing out?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема pg_ctl inappropriately timing out?
Дата
Msg-id 200506071616.49757.josh@agliodbs.com
обсуждение исходный текст
Ответы Re: pg_ctl inappropriately timing out?  (Alvaro Herrera <alvherre@surnet.cl>)
Список pgsql-bugs
Folks:

Issue: pg_ctl seems to be prematurely timing out.
Version: 8.0.3
Severity: Annoying
Description:
1. Do an immense load on a database, like 2.5gb.
2. Right after the COPY finishes, send a pg_ctl -m fast stop to the server.
3. You will get:
    pg_ctl: postmaster does not shut down

What Seems To Be Happening:
When you call pg_ctl --stop, the WAL is still writing out to the database
and postmaster won't shut down until it's done, which can take a couple
minutes.  In the meantime, pg_ctl is timing out and prematurely reporting
failure.

Resolution:
Not sure, really.  Is there some way for pg_ctl to intelligently detect
this situation?  To set a timeout value for pg_ctl via a command-line
option?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Frank van Vugt
Дата:
Сообщение: Re: BUG in temp tables involving a temp table not properly
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_ctl inappropriately timing out?