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

2020-08-05 Thread Mariya Rampurawala
, 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? Regards, Mariya From: "Ahmed, Nawaz (Fuji Xerox Australia)" Date: Wednesday, 5 August 2020 at 11:41 PM To: Mariya Rampurawala , &

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

Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails

2020-05-13 Thread Mariya Rampurawala
Thank you Kyotaro and Laurenz for your quick responses. This helped me get my setup working. Regards, Mariya On 13/05/20, 6:51 AM, "Kyotaro Horiguchi" wrote: At Tue, 12 May 2020 17:29:50 +0200, Laurenz Albe wrote in > On Tue, 2020-05-12 at 09:40 +, Mariya Ramp

Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails

2020-05-12 Thread Mariya Rampurawala
p root@10.209.56.88:/pg_backup/%f %p' === Regards, Mariya On 12/05/20, 2:15 PM, "Kyotaro Horiguchi" wrote: Hello. At Tue, 12 May 2020 06:32:30 +, Mariya Rampurawala wrote in > I am working on providing HA for replication, using automation scr

Re: PostgreSQL-12 replication failover, pg_rewind fails

2020-05-12 Thread Mariya Rampurawala
Hello, Can someone please help me with the below query? Regards, Mariya From: Mariya Rampurawala Date: Sunday, 10 May 2020 at 2:55 PM To: "pgsql-general@lists.postgresql.org" , "pgsql-gene...@postgresql.org" Subject: PostgreSQL-12 replication failover, pg_rewind fails

PostgreSQL-12 replication failover, pg_rewind fails

2020-05-10 Thread Mariya Rampurawala
Hi, I am working on providing HA for replication, using automation scripts. My set up consists on two nodes, Master and Slave. When master fails, The slave is promoted to master. But when I try to re-register the old master as slave, the pg_rewind command fails. Details below. Non-default entri

Wal receiver process listens to physical IP

2020-03-20 Thread Mariya Rampurawala
Hi, I have been working on a project where I need to virtualize the postgresql standby server. The wal receiver process listens to the Physical IP and a random port. How can I configure it to listen to a VIP that the wal sender process can connect to? Also, Is there a way I can configure the por