From: Ronan Dunklau <ronan.dunklau@aiven.io>
To: Masahiko Sawada <sawada.mshk@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Cc: Gerard H. Pille <ghpille@hotmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Michael Paquier <michael@paquier.xyz>
Subject: Re: pg_basebackup behavior on non-existent slot
Date: Thu, 26 Aug 2021 07:31:31 +0200
Message-ID: <1795827.0SXAIGXuGy@aivenronan> (raw)
In-Reply-To: <YSNKEJFmA+amz515@paquier.xyz>
References: <PA4PR04MB78886C76F521F031FDEB216CBCC29@PA4PR04MB7888.eurprd04.prod.outlook.com>
<CAD21AoA=D1ssWr-GOPz-NMr4jDsZb2VGetdRVvXeQXtdiLoBUA@mail.gmail.com>
<YSNKEJFmA+amz515@paquier.xyz>
Le lundi 23 août 2021, 09:11:12 CEST Michael Paquier a écrit :
Some ideas here
> may be to extend the result of IDENTIFY_SYSTEM to return the slots
> available in a text array, invent a new command called SLOT, use SHOW
> or perhaps do an extra CREATE_REPLICATION_SLOT TEMPORARY from the main
> thread.
This new command (albeit named differently, READ_REPLICATION_SLOT) has been
proposed here: https://www.postgresql.org/message-id/
1642037.dBafQRxpgh@aivenronan for a different purpose, although it would be
useful to have that in that case too.
I guess I can add a patch to use that in pg_basebackup itself in the same
patchset.
--
Ronan Dunklau
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: ronan.dunklau@aiven.io, sawada.mshk@gmail.com, pgsql-bugs@lists.postgresql.org, ghpille@hotmail.com, michael@paquier.xyz
Subject: Re: pg_basebackup behavior on non-existent slot
In-Reply-To: <1795827.0SXAIGXuGy@aivenronan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox