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)
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 Database Administrator Fuji Xerox Australia Pty. Limited 8 Khartoum Rd, Macquarie Park NSW 2113 Australia | P: 02 9856