Hello Depesz,
Thanks for your quick response, let me give some overview of our cluster
setups. Actually we have a Patroni cluster running with one replica
(Replica 1) in the same data center with no data lag. whereas we have
configured one more replica(Replica 2) in a different data center
throu
On Mon, Oct 11, 2021 at 05:58:03PM +0530, Pawan Sharma wrote:
> Is there a way to monitor the replication lag, where replica nodes are
> configured through aws s3.
You can check it on replica, by issuing:
select now() - pg_last_xact_replay_timestamp();
and it will show you, more or less, what is
On Thu, Aug 6, 2020 at 7:02 AM Sreejith P wrote:
> IN SYNC mode of replication what would be the impact on Master DB server in
> terms of over all performance ?
The pg_stat_replication columns write_lag, flush_lag and replay_lag
are designed tell you how long to expect commits to take for
synch
