Re: Warn about using single user + standby_mode

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Warn about using single user + standby_mode
Дата
Msg-id CAA4eK1L5mGnyrV8r0KytorpsjeiREbdhQo=9Se3kXoeCQXjSEg@mail.gmail.com
обсуждение исходный текст
Ответ на Warn about using single user + standby_mode  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Fri, Jun 5, 2015 at 9:59 PM, Andres Freund <andres@anarazel.de> wrote:
>
> Hi,
>
> When primary_conninfo is configured and standby_mode is enabled single
> user mode starts up, but at some point will just wait in a latch for WAL
> to show up. Which will obviously never happen as walreceiver isn't up.
>

So this essentially means as it stands single user mode can't work
for standby.

> Should we just error out in that case, or at least display a log message
> about that fact?
>

I think error is better in this case as there seems no chance for
user to proceed in this case.  It is even better if we can detect
this early and error out before even reaching the stage where it
starts waiting out for WAL to show up.


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: could not truncate directory "pg_subtrans": apparent wraparound
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [CORE] Restore-reliability mode