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
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
I have also made some changes to the repmgr.conf file.
My questions are:
- How do I get repmgr to recognize the changes that I made to the conf file? Is there some way to reload it?
- How do I tell repmgr to use the
repmgr.conffile 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?
- 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?