Re: allow online change primary_conninfo

Поиск
Список
Период
Сортировка
Искать
От
Sergei Kornilov
Тема
Re: allow online change primary_conninfo
Дата
Msg-id
3033811550437565@myt1-e20b74e6250c.qloud-c.yandex.net
Ответ на
Список
Дерево обсуждения
allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo "andres@anarazel.de" <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo "andres@anarazel.de" <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: Re: allow online change primary_conninfo David Steele <david@pgmasters.net>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Andres Freund <andres@anarazel.de>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Alvaro Herrera <alvherre@2ndquadrant.com>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: allow online change primary_conninfo Maxim Orlov <m.orlov@postgrespro.ru>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Fujii Masao <masao.fujii@gmail.com>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Thomas Munro <thomas.munro@gmail.com>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Re: allow online change primary_conninfo Sergei Kornilov <sk@zsrv.org>
Re: allow online change primary_conninfo Michael Paquier <michael@paquier.xyz>
Hi

> For one, it's not ok to just let the startup process think that the
> walreceiver failed - that'll make it change source of WAL to the next
> available method. Something we definitely do not want, as
> restore_command is very commonly slower.

Ok. This was not mentioned before Michael response yesterday. restore_command is much faster compared to database restart, also switch to a different method was proposed few years ago by Simon Riggs in original change recovery.conf proposal ( https://www.postgresql.org/message-id/flat/CANP8+jLO5fmfudbB1b1iw3pTdOK1HBM=xMTaRfOa5zpDVcqzew@mail.gmail.com/ ). I assumed we can start with this. Sorry for your wasted time.

> That'd still switch to a different method, something we do not want...

Ok, do not want means we do not want. Will try change behavior.

regards, Sergei

В списке pgsql-hackers по дате отправления
От: Justin Pryzby
Дата:
От: Thomas Munro
Дата:
FAQ