On Wed, Aug 05, 2020 at 06:36:15PM +, Mariya Rampurawala wrote:
> What I want to understand is that, in case of replication link
> failure, there will still be inserts happening at the master
> node. In that case, how will the slave know if it is up-to-date?
It cannot do that by itself, which
quot;pgsql-gene...@postgresql.org"
Subject: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag
Hi,
You could achieve that with a combination of those functions and querying the
pg_stat_replication on either side of your setup.
Regards,
[Fuji Xerox Australia]
Nawaz Ahmed
Da
2020 1:23 AM
To: pgsql-gene...@postgresql.org
Subject: PostgreSQL-12 replication. Check replication lag
Hi,
I am working on providing HA for replication, using automation scripts.
My set up consists of two nodes, Master and Slave. When master fails, The slave
is promoted to master.
In case of sync rep
Hi,
I am working on providing HA for replication, using automation scripts.
My set up consists of two nodes, Master and Slave. When master fails, The slave
is promoted to master.
In case of sync replication, we do not check if the data is up-to-date on slave.
But in case of async replication, ho