Horton

Re: AW: Replication Testing- How to introduce a Lag

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>, "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Date: 2026-03-20T13:38:31Z
Lists: pgsql-novice 
On Fri, 2026-03-20 at 10:47 +0000, Subramanian,Ramachandran wrote:
> how can the last replayed be more than the last received?

It shouldn't be - but I don't understand your script, in particular
which query is issused on which server.

Look at "pg_stat_replication" on the primary server.

Yours,
Laurenz Albe