RE: Have pg_basebackup write "dbname" in "primary_conninfo"?
От
Hayato Kuroda (Fujitsu)
Тема
RE: Have pg_basebackup write "dbname" in "primary_conninfo"?
Дата
Msg-id
TYCPR01MB12077B81FCAFDFE104DEEE7BAF5592@TYCPR01MB12077.jpnprd01.prod.outlook.com
Ответ на
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? (Hayato Kuroda (Fujitsu))
Список
Дерево обсуждения
Have pg_basebackup write "dbname" in "primary_conninfo"? Ian Lawrence Barwick <barwick@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Jelte Fennema-Nio <postgres@jeltef.nl>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Robert Haas <robertmhaas@gmail.com>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Robert Haas <robertmhaas@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? vignesh C <vignesh21@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? vignesh C <vignesh21@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Ajin Cherian <itsajin@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Ajin Cherian <itsajin@gmail.com>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Ajin Cherian <itsajin@gmail.com>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Masahiko Sawada <sawada.mshk@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Masahiko Sawada <sawada.mshk@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? vignesh C <vignesh21@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Masahiko Sawada <sawada.mshk@gmail.com>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Amit Kapila <amit.kapila16@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? vignesh C <vignesh21@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Masahiko Sawada <sawada.mshk@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? vignesh C <vignesh21@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? Masahiko Sawada <sawada.mshk@gmail.com>
Re: Have pg_basebackup write "dbname" in "primary_conninfo"? shveta malik <shveta.malik@gmail.com>
RE: Have pg_basebackup write "dbname" in "primary_conninfo"? "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
> PSA the patch for implementing it. It is basically same as Ian's one.
> However, this patch still cannot satisfy the condition 3).
>
> `pg_basebackup -D data_N2 -d "user=postgres" -R`
> -> dbname would not be appeared in primary_conninfo.
>
> This is because `if (connection_string)` case in GetConnection() explicy override
> a dbname to "replication". I've tried to add a dummy entry {"dbname", NULL} pair
> before the overriding, but it is no-op. Because The replacement of the dbname in
> pqConnectOptions2() would be done only for the valid (=lastly specified)
> connection options.
Oh, this patch missed the straightforward case:
pg_basebackup -D data_N2 -d "user=postgres dbname=replication" -R
-> dbname would not be appeared in primary_conninfo.
So I think it cannot be applied as-is. Sorry for sharing the bad item.
Best Regards,
Hayato Kuroda
FUJITSU LIMITED
https://www.fujitsu.com/
В списке pgsql-hackers по дате отправления
От: Hayato Kuroda (Fujitsu)
Дата: