Re: How to test replication without doing a failover

[Rui DeSousa <rui@xxxxxxxxxxxxx>]

On Nov 12, 2022, at 1:24 AM, Edwin UY <edwin.uy@xxxxxxxxx> 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.