Postgres Pro
Downloads
Home   >   mailing lists

RE: How to query "primary_slot_name" in slave server? - Mailing list pgsql-general

From Edson Richter
Subject RE: How to query "primary_slot_name" in slave server?
Date
Msg-id MN2PR01MB5327CBEA5A9DD16D69BA8111CFCE0@MN2PR01MB5327.prod.exchangelabs.com
Whole thread Raw
In response to Re: How to query "primary_slot_name" in slave server?  (Paul Förster <paul.foerster@gmail.com>)
List pgsql-general
Tree view
De: Paul Förster <paul.foerster@gmail.com>
Enviado: quarta-feira, 25 de março de 2020 11:42
Para: Edson Richter <edsonrichter@hotmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Assunto: Re: How to query "primary_slot_name" in slave server?
 
Hi Edson,

query the following on the replica:

pg_stat_wal_receiver


Perfect, thanks!

Edson



Cheers,
Paul

> On 25. Mar, 2020, at 13:59, Edson Richter <edsonrichter@hotmail.com> wrote:
>
> Hi!
>
> I've been searching over the net, but cannot find a reference.
> I know that in server I can execute "select * from pg_replication_slots" and get all created slots.
> But how can I query slave to know wich primay slot it is connecting to?
>
> Thanks in advance,
>
> Edson

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 13: native JavaScript Procedural Language support ?
Next
From: Justin King
Date:
Subject: Re: PG12 autovac issues