I have a PostgreSQL v9.6 cluster installed on a Linux server (Scientific Linux release 6.9), with repmgr to handle failovers. I have a master & two standby servers that all have PostgreSQL v9.6 and repmgr installed. (I also will try to implement pgbouncer on a separate server to handle the connections if/when a failover occurs).

My PostgreSQL data directory is /var/lib/pgsql/9.6/data/. I have PostgreSQL running & am using streaming replication to the two standbys & have been able to successfully test a failover situation to the standbys & then back to the original primary.

I had the repmgr.conf file located in /etc/repmgr.conf, but would like to move it to the /var/lib/pgsql/9.6/repmgr/ directory. I have also made some changes to the repmgr.conf file.

My questions are:

  1. How do I get repmgr to recognize the changes that I made to the conf file? Is there some way to reload it?
  2. How do I tell repmgr to use the repmgr.conf file located in the new directory instead of /etc/? Do I have to unregister the servers & then re-register them? Do I need to shut down the PostgreSQL cluster to do that?
  3. When I implement pgbouncer, do I need to have a postgres user on the pgbouncer server in order to configure passwordless ssh between my PostgreSQL & pgbouncer servers?

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.