Re: allow online change primary_conninfo

Поиск
Список
Период
Сортировка
Искать
От
Sergei Kornilov
Тема
Re: allow online change primary_conninfo
Дата
Msg-id
4926831544698308@iva3-294f9af87d55.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>
Hello

> Do we no longer need static version of conninfo/slotname in
> walreceiver.c? We can detect a change of the variables without
> them (as you did in the previous version.).

Depends on this discussion: https://www.postgresql.org/message-id/20181212053042.GK17695@paquier.xyz
If walreceiver will use GUC conninfo for startup - then yes, we can remove such static variables.
If walreceiver will still use conninfo from WalRcv - we have race condition between RequestXLogStreaming from startup, config reload, and walreceiver start. In this case i need save conninfo from WalRcv and compare new GUC value with them.

> I don't think it is acceptable that raw conninfo is exposed into
> log file.
>
>>   LOG: parameter "primary_conninfo" changed to "host=/tmp port=5432 password=hoge"

Hmm. We have infrastructure to hide such values?
I need implement something like flag GUC_HIDE_VALUE_FROM_LOG near GUC_SUPERUSER_ONLY in separate thread? Log message will be changed to "LOG: parameter "primary_conninfo" changed" with this flag.

I also think that this is not a big problem. We may already have secret data in the logs. For example, in query text from application.

>>  errmsg("closing replication connection because primary_conninfo was changed")));
>
> Maybe it is better being as follows according to similar messages:
>
>>  errmsg("terminating walreceiver process due to change of primary_conninfo")));
>
> And it *might* be good to have detail.
>
>>  errdetail("In a moment starts streaming WAL with new configuration.");

Agreed, will change.

regards, Sergei

В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
Сообщение: alternative to PG_CATCH
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: tab-completion debug print
FAQ