Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag

2020-08-05 Thread Michael Paquier
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

Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag

2020-08-05 Thread Mariya Rampurawala
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

RE: PostgreSQL-12 replication. Check replication lag

2020-08-05 Thread Ahmed, Nawaz (Fuji Xerox Australia)
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

PostgreSQL-12 replication. Check replication lag

2020-08-04 Thread Mariya Rampurawala
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