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.

  • 1
    Why are you using an unsupported an deprecated version? The easiest way to manage replicas is to use repmgr – a_horse_with_no_name Apr 4 '18 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. – Python Apr 4 '18 at 17:04
  • That is stupid. 9.2 is not even maintained any more – a_horse_with_no_name Apr 4 '18 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 – Python Apr 4 '18 at 17:45
  • 1
    I already suggested repmgr – a_horse_with_no_name Apr 4 '18 at 18:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.