Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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 ) with 2 new Postgres releases since, although there does seem some sporadic work on a new beta.



That 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...




Consider applying for YC's Summer 2026 batch! Applications are open till May 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: