Re: How to test replication without doing a failover - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: How to test replication without doing a failover
Date
Msg-id 1FC5167C-BCEA-49E1-B014-011AD375D836@crazybean.net
Whole thread Raw
In response to Re: How to test replication without doing a failover  (Edwin UY <edwin.uy@gmail.com>)
List 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 by date:

Previous
From: Ron
Date:
Subject: Re: Persistent changes in rolled-back transactions
Next
From: Kenny Bachman
Date:
Subject: Sequence last value is different among primary and secondary