unable to resgiter witnes node in repmgr

2024-01-03 Thread Vijaykumar Patil
Happy new year to everyone !! Can any one help me on this below issue as we are not able to register witness node in repmgr , getting below error. postgres@adsoazdbaodb04[TEST]-/home/postgres: repmgr -f /u01/app/admin/Data/repmgr.conf witness register -h scrbtrheldbaas001 INFO: connecting to w

PAF with Pacemaker

2023-11-30 Thread Vijaykumar Patil
Hi Team , I have two postgres server one is primary and other one replica, I have setup replication and configured pacemaker and corosync. But still I'm facing issue while creating resource. It is showing invalid parameters. [root@scrbtrheldbaas001 heartbeat]# pcs status Cluster name: pg_clust

RE: General support on postgres replication

2023-11-23 Thread Vijaykumar Patil
) [sender] Thanks Vijay Classification: Internal -Original Message- From: Laurenz Albe Sent: 23 November 2023 14:14 To: Vijaykumar Patil ; pgsql-general@lists.postgresql.org Subject: Re: General support on postgres replication This message was sent from outside of your organization

General support on postgres replication

2023-11-22 Thread Vijaykumar Patil
Hi Team, Need some support for below issue . I have created streaming replication with two nodes . One is primary and 2nd one is standby but after doing any DML or DDL operation on primary Walreceiver process is terminated on standby and standby database is opening in read write mode. Below a