Re: Synchronizing slots from primary to standby

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Amit Kapila <[email protected]>
To: Masahiko Sawada <[email protected]>
Cc: shveta malik <[email protected]>
Cc: Zhijie Hou (Fujitsu) <[email protected]>
Cc: Drouvot, Bertrand <[email protected]>
Cc: Peter Smith <[email protected]>
Cc: Nisha Moond <[email protected]>
Cc: Hayato Kuroda (Fujitsu) <[email protected]>
Cc: Bharath Rupireddy <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: Ashutosh Sharma <[email protected]>
Cc: Andres Freund <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: Ajin Cherian <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Subject: Re: Synchronizing slots from primary to standby
Date: Fri, 29 Dec 2023 10:25:20 +0530
Message-ID: <CAA4eK1+AFY4E0f9h0-JF-navrf-vRMTMrN6H7PDKiR=C6p84Nw@mail.gmail.com> (raw)
In-Reply-To: <CAD21AoCnwGGCSCmdWThJSLkD5Qbk1BJoBaD6BHh8HgkobZ2brg@mail.gmail.com>
References: <CAJpy0uC+2agRtF3H=n-hW5JkoPfaZkjPXJr==y3_PRE04dQvhw@mail.gmail.com>
	<CAA4eK1LxGd8GACR36KdtbVaQeKsV9B5-LuBf2o721x6OZ=_wWg@mail.gmail.com>
	<[email protected]>
	<CABdArM5zvpFcOF=_0W-E5bjqjrC2MK+EtFN0UfP43zvaFOc8QA@mail.gmail.com>
	<CAJpy0uCBHRX-GSKCeVza44kFEC=uTMD_6uzuXXnbUX32Vt-g8Q@mail.gmail.com>
	<[email protected]>
	<CAJpy0uDiffV66DofhxZr97Sw2U_-ZkdNCjdRt9tKhnf-CxW57Q@mail.gmail.com>
	<CAA4eK1+AumKenLjtVW2y4CpxBr_bo_AVZ67RWdDeJFt+Kgrj0A@mail.gmail.com>
	<[email protected]>
	<CAA4eK1+EeUUT+gnzoHKWm7GqosA2ehT8QyoKtu1jiyGE=wUErw@mail.gmail.com>
	<CAJpy0uCAzkua8KAQaLNnYKOJ56x3yJ9kRfDxL8Enp5Li8bzhdQ@mail.gmail.com>
	<[email protected]>
	<CAJpy0uDU-qaspyU7nNduoqLGjeUT1jVbRyvKMTUvQNp3eY+08Q@mail.gmail.com>
	<CAJpy0uBYJh+6vsX2VnecZvc=TUFMY93O9Pob07VzsQQV3cGBWQ@mail.gmail.com>
	<CAA4eK1+wN+K3vMOxtE=Lo98aimctiBdozMWaNPG55NUGWW3Gww@mail.gmail.com>
	<[email protected]>
	<CAJpy0uC-8mrn6jakcFjSVmbJiHZs-Okq8YKxGfrMLPD-2=wOqQ@mail.gmail.com>
	<CAA4eK1Ki1O65SyA6ijh-Mq4zpzeh644fCmkrZXMJcQXHNrAw0Q@mail.gmail.com>
	<CAJpy0uB3tJCxPCbPHJpf4yeBvnhUsHUEJWtmm8Ha6s6QCBm55w@mail.gmail.com>
	<CAJpy0uBgGRJvWYfJD=3XE8OZ0V=X1keOYXxXEkpJqYk00BAzZg@mail.gmail.com>
	<CAHut+Psvxs-=j3aCpPVs3e4w78HndCdO-F4bLPzAX70+dgWUuQ@mail.gmail.com>
	<CAA4eK1+w9yv+4UZXhiDHZpGDfbeRHYDBu23FwsniS8sYUZeu1w@mail.gmail.com>
	<CAJpy0uCv71ynK7zFkKWy3wa7ua+wGw=zoGKy9w=Xq2sq4PqAFQ@mail.gmail.com>
	<OS0PR01MB5716AFA48B8EAA926632D2BB9490A@OS0PR01MB5716.jpnprd01.prod.outlook.com>
	<CAHut+Pv86wBZiyOLHxycd8Yj9=k5kzVa1x7Gbp+=c1VGT9TG2w@mail.gmail.com>
	<CAJpy0uAhUeS7HK9ww=1q5+7o3Uph4YDo8hwBo-h3X81C4ewwNg@mail.gmail.com>
	<CAA4eK1K0KCDNtpDyUKucMRdyK-5KdrCRWakCpHEdHT9muAiEOw@mail.gmail.com>
	<CAJpy0uBK2uA=SiwSBNc9x4ME+G20J1fsPBzT7uRsEPbaVqp8Jg@mail.gmail.com>
	<CAA4eK1KwDjcmWL6Z=dP5j=buHEPPMAC1zd6yfYE-_7CvkxpkJw@mail.gmail.com>
	<OS0PR01MB5716DEF449E2627F4FDC27F59498A@OS0PR01MB5716.jpnprd01.prod.outlook.com>
	<CAJpy0uBhPx1MDHh903XpFAhpBH23KzVXyg_4VjH2zXk81oGi1w@mail.gmail.com>
	<CAD21AoD23jkCwvHkrGOyXRs5Ugh_SF0g0-aJpNTekCT0HHYcrg@mail.gmail.com>
	<CAJpy0uCrd6kO5ghkVqhBjtqmGO=7NN7LBDj37AncAWQrrtd=Fw@mail.gmail.com>
	<CAD21AoCnwGGCSCmdWThJSLkD5Qbk1BJoBaD6BHh8HgkobZ2brg@mail.gmail.com>

On Fri, Dec 29, 2023 at 7:18 AM Masahiko Sawada <[email protected]> wrote:
>
> On Wed, Dec 27, 2023 at 7:13 PM shveta malik <[email protected]> wrote:
> >
> > On Wed, Dec 27, 2023 at 11:36 AM Masahiko Sawada <[email protected]> wrote:
>
> >  I was not aware if there is any way to connect if we
> > want to run SQL queries. I initially tried using 'PQconnectdbParams'
> > but couldn't make it work. Perhaps it is to be used only by front-end
> > and extensions as the header files indicate as well:
> >  * libpq-fe.h :      This file contains definitions for structures and
> >  externs for functions used by frontend postgres applications.
> >  * libpq-be-fe-helpers.h:   Helper functions for using libpq in
> > extensions . Code built directly into the backend is not allowed to
> > link to libpq directly.
>
> Oh I didn't know that. Thank you for pointing it out.
>
> But I'm still concerned it could confuse users that
> pg_stat_replication keeps showing one entry that remains as "startup"
> state. It has the same application_name as the walreceiver uses. For
> example, when users want to check the particular replication
> connection, it's common to filter the entries by the application name.
> But it will end up having duplicate entries having different states.
>

Valid point. The main reason for using cluster_name is that if
multiple standby's connect to the same primary, all will have the same
application_name as 'slotsyncworker'. The other alternative could be
to use {cluster_name}_slotsyncworker, which will probably address your
concern and we can have to provision to differentiate among
slotsyncworkers from different standby's.

-- 
With Regards,
Amit Kapila.

view thread (28+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Synchronizing slots from primary to standby
  In-Reply-To: <CAA4eK1+AFY4E0f9h0-JF-navrf-vRMTMrN6H7PDKiR=C6p84Nw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox