From: | Shital A <brightuser2019(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fwd: Postgres HA - pacemaker RA do not support auto failback |
Date: | 2019-08-12 12:57:19 |
Message-ID: | CAMp7vw9zshi6T2QNgy+GtXVVY3ag9RrZB7onsNTw0hcKrdG+ww@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
Postgres version : 9.6
OS:Rhel 7.6
We are working on HA setup for postgres cluster of two nodes in
active-passive mode.
Installed:
Pacemaker 1.1.19
Corosync 2.4.3
The pacemaker agent with this installation doesn't support automatic
failback. What I mean by that is explained below:
1. Cluster is setup like A - B with A as master.
2. Kill services on A, node B will come up as master.
3. node A is ready to join the cluster, we have to delete the lock file it
creates on any one of the node and execute the cleanup command to get the
node back as standby
Step 3 is manual so HA is not achieved in real sense.
Please help to check:
1. Is there any version of the resouce agent which supports automatic
failback? To avoid generation of lock file and deleting it.
2. If there is no such support, what checks should be added in pgsql RA to
achieve
Please suggest.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrien Nayrat | 2019-08-12 13:24:13 | Re: Fwd: Postgres HA - pacemaker RA do not support auto failback |
Previous Message | Laurenz Albe | 2019-08-12 12:24:00 | Re: How to gracefully keep my specific index in memory ? |