0

We want to set up a highly available PostgreSQL cluster in our production environment. As of now, We have set up streaming replication. But we have to manually promote the slave as the master in case of failover and also change connection strings of the client applications.

Is there any tool exists for automating this? So that we don't have to promote the slave as master and also no connection string change requires in client applications.

We are using PostgreSQL-9.2.

Improve this question
7
  • 1
    Why are you using an unsupported an deprecated version? The easiest way to manage replicas is to use repmgr Commented Apr 4, 2018 at 16:22
  • We installed PostgreSQL on RHEL 7 using its repositories. and it installs PostgreSQL 9.2 by default. Also, the client wanted us to install PostgreSQL form RHEL repositories only. Commented Apr 4, 2018 at 17:04
  • That is stupid. 9.2 is not even maintained any more Commented Apr 4, 2018 at 17:21
  • I know its stupid, we tried to convince client but all in vain. Could you please suggest something for PostgreSQL 9.2 Commented Apr 4, 2018 at 17:45
  • 1
    I already suggested repmgr Commented Apr 4, 2018 at 18:30

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.