Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- cluster=main
- node=3
- node_name=witness
- conninfo='host=[WITNESS IP] dbname=witness user=witness password=witness port=5499'
- master_response_timeout=60
- reconnect_attempts=6
- reconnect_interval=10
- failover=automatic
- promote_command='promote_command.sh'
- follow_command='/usr/lib/postgresql/9.1/bin/repmgr standby follow -f /etc/repmgr/repmgr.conf'
- cluster=main
- node=2
- node_name=node2
- conninfo='host=[STANDBY IP] dbname=[DB NAME] user=[DB USER NAME] password=[PASSWORD]'
- master_response_timeout=60
- reconnect_attempts=6
- reconnect_interval=10
- failover=automatic
- promote_command='promote_command.sh'
- follow_command='/usr/lib/postgresql/9.1/bin/repmgr standby follow -f /etc/repmgr/repmgr.conf'
- cluster=main
- node=1
- node_name=node1
- conninfo='host=[MASTER IP] dbname=[MASTER DB] user=[MASTER DB USER] password=[PASSWORD]'
- master_response_timeout=60
- reconnect_attempts=6
- reconnect_interval=10
- failover=automatic
- promote_command='promote_command.sh'
- follow_command='/usr/lib/postgresql/9.1/bin/repmgr standby follow -f /etc/repmgr/repmgr.conf'
- host all repmgr 192.168.1.1/32 md5
- host replication all 192.168.1.1/32 md5
- /usr/lib/postgresql/9.1/bin/pg_ctl reload -D /var/lib/postgresql/9.1/main
- createuser --login --superuser -P repmgr -W
- createdb -O repmgr repmgr
- su - postgres
- cat > .pgpass << EOF
- *:*:*:repmgr:secret_passw0rd
- EOF
- chmod 0600 .pgpass
- host all repmgr 192.168.1.1/32 trust
- host replication all 192.168.1.1/32 trust
- psql -h master.hostname -U repmgr
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement