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

Поиск
Список
Период
Сортировка
От Paul Förster
Тема Re: How to query "primary_slot_name" in slave server?
Дата
Msg-id 7860D9E0-4842-4BE7-8B39-92A3A65902FF@gmail.com
обсуждение исходный текст
Ответ на How to query "primary_slot_name" in slave server?  (Edson Richter <edsonrichter@hotmail.com>)
Ответы RE: How to query "primary_slot_name" in slave server?  (Edson Richter <edsonrichter@hotmail.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Mike Rylander
Дата:
Сообщение: Re: Replacing Apache Solr with Postgre Full Text Search?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 13: native JavaScript Procedural Language support ?