shayonj/pg_easy_replicate
View on GitHub ↗ ★ 1,040 Ruby
Easily setup logical replication and switchover to new database with minimal downtime
6 mentions on Hacker News by 1 person: 1 story, 5 comments · first 2023-06-20 · latest 2024-01-19
20082026
-
…some requests were slower. DNS Groups w/ retries is a nifty mechanism for these things. Tool used: https://github.com/shayonj/pg_easy_replicate
comment by shayonj · 2024-01-19 · in We migrated our PostgreSQL database with 11 seconds downtime -
…or would like to extend it with your feedback/ideas, I'd love to have them! Thanks for sharing https://github.com/shayonj/pg_easy_replicate
comment by shayonj · 2023-12-13 · in Zero downtime Postgres upgrades -
…DB it cut down down the total time by 90%. Re: bi-directional replication, you read my mind :). https://github.com/shayonj/pg_easy_replicate/blob/8df94aa93f... These two features are top of my list to support in pg_easy_replicate
comment by shayonj · 2023-06-20 · in Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate -
…It is updated the as soon as the switchover is complete. UPDATE: Some more reading material here: https://github.com/shayonj/pg_easy_replicate#switchover-stra...
comment by shayonj · 2023-06-20 · in Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate -
…the readme to mention this - but the lib takes care of updating sequence with the data catchup: https://github.com/shayonj/pg_easy_replicate/blob/13ad6af51f...
comment by shayonj · 2023-06-20 · in Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate