Re: pg_basebackup behavior on non-existent slot

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, "Gerard H(dot) Pille" <ghpille(at)hotmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: pg_basebackup behavior on non-existent slot
Date: 2021-08-26 07:26:41
Message-ID: CAD21AoDYmv0yJMQnWtCx_kZGwVZnkQSTQ1re2JNSgM0k37afYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Aug 26, 2021 at 2:31 PM Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io> wrote:
>
> 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(dot)dBafQRxpgh(at)aivenronan for a different purpose, although it would be
> useful to have that in that case too.

Cool! I was considering other use cases of those new command ideas
proposed on this thread.

> I guess I can add a patch to use that in pg_basebackup itself in the same
> patchset.

+1

I'll look at the patches.

Regards,

--
Masahiko Sawada
EDB: https://www.enterprisedb.com/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message constzl 2021-08-26 07:38:12 Is Backgroundworker.bgw_restart_time is defined in seconds?
Previous Message Masahiko Sawada 2021-08-26 07:21:51 Re: BUG #17157: authorizaiton of dict_int and bloom extention