Thread: How to query "primary_slot_name" in slave server?
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
Hi Edson, query the following on the replica: pg_stat_wal_receiver 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
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
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