Re: How to query "primary_slot_name" in slave server?

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to query "primary_slot_name" in slave server?
Date: 2020-03-25 14:42:33
Message-ID: 7860D9E0-4842-4BE7-8B39-92A3A65902FF@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Edson,

query the following on the replica:

pg_stat_wal_receiver

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-03-25 14:50:28 Re: PostgreSQL 13: native JavaScript Procedural Language support ?
Previous Message Mike Rylander 2020-03-25 14:36:44 Re: Replacing Apache Solr with Postgre Full Text Search?