> On Nov 12, 2022, at 1:24 AM, Edwin UY <edwin(dot)uy(at)gmail(dot)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.