I already setup Primary(master) and Secondery(standby) Servers. Now, I need to do switchover. that means standby should be master and master should be standby.
how to perform switchover in Postgres 9?
|
feedback
|
migrated from stackoverflow.com Jun 21 '11 at 9:43
This question came from our site for professional and enthusiast programmers.
|
check your recovery.conf file. you should show a trigger file. recovery.confstandby_mode = 'on' primary_conninfo = 'host=127.0.0.1 port=5850 user=postgres' trigger_file = '/home/pgdba/data2/finish.replication' -> this file should exist. no need to write anything to it. This is just a trigger for switchover. The existence of file is enough. | |||
|
feedback
|
