this post was submitted on 19 Jan 2024
19 points (100.0% liked)

PostgreSQL

678 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
Ategon
starman
jnovinger
19
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
submitted 11 months ago* (last edited 11 months ago) by starman to c/postgresql
2 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 3 points 11 months ago (1 children)

Thats really kewl they are publishing this but its basically an ad for aws DMS.

[โ€“] [email protected] 4 points 11 months ago

read till the end please.

We chose to use DMS because it was well supported by the GOV.UK PaaS and we could also get support from AWS. If we were doing a PostgreSQL to PostgreSQL database migration in the future, we would invest more time in trying alternative tools such as pglogical. DMS potentially added more complexity, and an unfamiliar replication process than what we may have found with other tools. This backs up what AWS say themselves on PostgreSQL to PostgreSQL migrations.

it doesn't come across as an ad to anything.