Home > mailing lists

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

From	Edson Richter
Subject	How to query "primary_slot_name" in slave server?
Date	March 25, 2020 15:59:09
Msg-id	MN2PR01MB53273A1D0AED4F8E1AA06491CFCE0@MN2PR01MB5327.prod.exchangelabs.com Whole thread Raw
Responses	Re: How to query "primary_slot_name" in slave server? (Paul Förster <paul.foerster@gmail.com>)
List	pgsql-general

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: "David G. Johnston"
Date: 25 March 2020, 15:54:45
Subject: Re: How to plpgsql scripting

From: "David G. Johnston"
Date: 25 March 2020, 16:01:45
Subject: Re: PLPGSQL: DECLARE more variable with same type at once