Re: pg_ctl promote wait

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_ctl promote wait
Дата
Msg-id 20160219191649.ql2o6xxws4r3dluj@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: pg_ctl promote wait  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On 2016-02-20 00:06:09 +0900, Fujii Masao wrote:
> One concern is that there can be a "time" after the pg_control's state
> is changed to DB_IN_PRODUCTION and before the server is able to
> start accepting normal (not read-only) connections. So if users try to
> start write transaction just after pg_ctl promote -w ends, they might
> get an error because the server is still in recovery, i.e., the startup
> process is running.

It might make sense to have one more state type, which is used when
ending recovery, but before full access is allowed.

- Andres



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: pg_ctl promote wait
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: FDW: should GetFdwRoutine be called when drop table?