this post was submitted on 23 Jun 2023
1 points (100.0% liked)

PostgreSQL

126 readers
1 users here now

founded 1 year ago
MODERATORS
JWBananas
agilob
1
Zero downtime migration options with AWS RDS (self.postgresql)
submitted 1 year ago* (last edited 1 year ago) by badcommandorfilename to c/postgresql
0 comments fedilink hide all child comments
 

Usual story - joined a startup and their production database is a single instance RDS running 11.3.

We can't upgrade or scale or even change configuration without taking the database offline. We want to move everything to an Aurora Postgres compatible cluster that can scale horizontally.

What options do we have? I've used Bucardo in the past to do one-way sync, but how is it at multi-master replication? What would you use for this task?

no comments (yet)
sorted by: hot top controversial new old
there doesn't seem to be anything here