MIME-Version: 1.0
References: <CAB8KJ=hdKdg+UeXhReeHpHA6N6v3e0qFF+ZsPFHk9_ThWKf=2A@mail.gmail.com>
 <TYCPR01MB120773419F8EDA8C123D6D1BAF5502@TYCPR01MB12077.jpnprd01.prod.outlook.com>
 <CA+TgmoYfagyp5AvKMfGpRUgXNJZ0ymuqiWTzOc2tV_ZMM0UkCA@mail.gmail.com> <TYCPR01MB1207777150173002564A753B8F5502@TYCPR01MB12077.jpnprd01.prod.outlook.com>
In-Reply-To: <TYCPR01MB1207777150173002564A753B8F5502@TYCPR01MB12077.jpnprd01.prod.outlook.com>
From: Robert Haas <robertmhaas@gmail.com>
Date: Tue, 20 Feb 2024 19:56:10 +0530
Message-ID: <CA+TgmoaLRCcCeY3_n7h0rw-r-UfJt_GiFZiJQ1pFZ-iQNUozug@mail.gmail.com>
Subject: Re: Have pg_basebackup write "dbname" in "primary_conninfo"?
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: Ian Lawrence Barwick <barwick@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BTgmoaLRCcCeY3_n7h0rw-r-UfJt_GiFZiJQ1pFZ-iQNUozug%40mail.gmail.com>
Precedence: bulk

On Tue, Feb 20, 2024 at 5:58=E2=80=AFPM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:
> > Seems weird to me. You don't use dbname=3Dreplication to ask for a
> > replication connection, so why would we ever end up with that
> > anywhere? And especially in only one of two such closely related
> > cases?
>
> Just FYI - here is an extreme case. And note that I have applied proposed=
 patch.
>
> When `pg_basebackup -D data_N2 -R` is used:
> ```
> primary_conninfo =3D 'user=3Dhayato ... dbname=3Dhayato ...
> ```
>
> But when `pg_basebackup -d "" -D data_N2 -R` is used:
> ```
> primary_conninfo =3D 'user=3Dhayato ... dbname=3Dreplication
> ```

It seems like maybe somebody should look into why this is happening,
and perhaps fix it.

--=20
Robert Haas
EDB: http://www.enterprisedb.com