Re: pending patch: Re: HS/SR and smart shutdown

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: pending patch: Re: HS/SR and smart shutdown
Дата
Msg-id x2i3f0b79eb1004130716rc1c6719aj7c19366d605e1733@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pending patch: Re: HS/SR and smart shutdown  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Tue, Apr 13, 2010 at 10:27 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Can you explain how to recreate the problem that this patch fixes?

1. Configure and start the primary server.
2. Configure the standby server.
3. Remove all of the WAL files in pg_xlog of the standby.
4. Start the standby.
5. Request smart shutdown against the standby before walreceiver receives any
   WAL records. You would need to emulate the time-consuming authentication
   which usually requires the setting of authentication_timeout. I used the
   attached patch for the emulation. New GUC parameter "wal_sender_sleep" which
   the patch provides for the test specifies the sleep time during walsender's
   handshake processing. If you set it to 10s, walsender sleeps 10 secs before
   it sends the WAL records.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pending patch: Re: HS/SR and smart shutdown
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Hot Standby: Startup at shutdown checkpoint