5 ms·
I agree - one of the areas it would be great to have some development work done around is making replication administration simpler and easier. One feature whi
by sheff 13y ago
I agree - one of the areas it would be great to have some development work done around is making replication administration simpler and easier.
One feature which would be really nice to have is the ability to do a manual switchover, ie making the existing master into a replica and an existing replica into the new master.
Another poster mentioned repmgr which looks good but hasn't had a release in sometime ( https://github.com/2ndQuadrant/repmgr/blob/master/HISTORY https://github.com/2ndQuadrant/repmgr/blob/master/HISTORY ) with 2 new Postgres releases since, although there does seem some sporadic work on a new beta.
- X-Istence 13y agoThat is something that is listed for 9.3. You can have a M1 with R1, R2, R3. Now you change R1 to master, and take M1 "offline", afterwards turn M1 back on, and have it become a slave to R1. See http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.3#Replication_Improvements http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.3...