[ADMIN] Shutdown Order with Primary/Standby?

Поиск
Список
Период
Сортировка
От Don Seiler
Тема [ADMIN] Shutdown Order with Primary/Standby?
Дата
Msg-id CAHJZqBDaKv4Lc7Cws3UB-WnYENvQW2ZD7BoEOTnSZVHgHFo21w@mail.gmail.com
обсуждение исходный текст
Ответы Re: [ADMIN] Shutdown Order with Primary/Standby?
Re: [ADMIN] Shutdown Order with Primary/Standby?
Список pgsql-admin
Afternoon,

Just wondering if there's a best practice in regards to shutdown of primary and standbys, as I approach my first planned maintenance task as a newbie PostgreSQL DBA. I found one older post that suggested doing a fast-mode shutdown on primary first so that all transaction info can be cleanly pushed to standby, then shutdown the standby. Our big app group runs on 9.2.18 and is being upgraded to 9.2.22.

Extending that scenario, if you had a cascading standby, would you go primary -> upstream standby -> downstream standby?

Curious what folks think.

Don.

--
Don Seiler
www.seiler.us

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

Предыдущее
От: Sathesh S
Дата:
Сообщение: [ADMIN] Performance impact for enabling Log_disconnections
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: [ADMIN] Performance impact for enabling Log_disconnections