Re: How to test replication without doing a failover

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: How to test replication without doing a failover
Дата
Msg-id 1FC5167C-BCEA-49E1-B014-011AD375D836@crazybean.net
обсуждение исходный текст
Ответ на Re: How to test replication without doing a failover  (Edwin UY <edwin.uy@gmail.com>)
Список pgsql-admin


On Nov 12, 2022, at 1:24 AM, Edwin UY <edwin.uy@gmail.com> wrote:

If using log shipping, the SQL below will return nothing, is that correct?
select * from pg_stat_replication ;

Correct, as you would have the replica consuming WAL files rather than connecting directly to an upstream/master server and consuming the WAL online.  That will only show the active connections currently replicating from the given server.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Persistent changes in rolled-back transactions
Следующее
От: Kenny Bachman
Дата:
Сообщение: Sequence last value is different among primary and secondary