Am 11.05.2017 um 15:58 schrieb Martin Goodson:
Hello. First time poster, so please be gentle :)
I have a PostgreSQL 9.6 database cluster running on a standalone
Redhat 7.2 (Maipo) server.
This may seem like a silly question. It probably *is* a silly
question, so apologies in advance.
PostgreSQL was installed using the "EDB Postgres Standard" installer
from EnterpriseDB -
https://www.enterprisedb.com/software-downloads-postgres - and
installed to a specific location - /db_<dbname>. No repositories,
nothing in a 'standard' place.
I have now been tasked with putting repmgr onto this box and
converting it from a standalone to a multiple node setup (I have two
additional servers lurking in the background ready for use :) ).
Numerous articles on repmgr all seem to suggest it should be a
relatively simply operation once the software is in place. Register
the master. Clone standbys. Ought to be *relatively* straight-forward.
Unfortunately, I'm having problems at the first hurdle - putting the
software in place. We initially tried installing from the postgres
repository rpm - which insisted, of course, on installing PostgreSQL
as well as repmgr in /usr/pgsql-9.6. Obviously not the right place for
it given we're running our binaries from
/db_dbname/app/postgres/9.6.2-3/bin
Is there a simple way to use repmgr from the package, perhaps by
copying/linking files from that location to ours? (e.g.
copying/linking some files from lib, bin, contrib, etc).
I think, repmgr *should* work with EDB-Version of PostgreSQL. You can
set pg_bindir in repmgr.conf. I would also suggest create symlinks in
/etc to the repmgr.conf.
Btw.: you also set
|service_start_command service_stop_command service_restart_command
service_reload_command service_promote_command|
Keep me informed if that works, thx.
Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
