From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: How to query "primary_slot_name" in slave server? |
Date: | 2020-03-25 15:05:44 |
Message-ID: | MN2PR01MB5327CBEA5A9DD16D69BA8111CFCE0@MN2PR01MB5327.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
De: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
Enviado: quarta-feira, 25 de março de 2020 11:42
Para: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)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(at)hotmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Justin King | 2020-03-25 15:39:17 | Re: PG12 autovac issues |
Previous Message | Tom Lane | 2020-03-25 14:50:28 | Re: PostgreSQL 13: native JavaScript Procedural Language support ? |