Spyke

Syndicated from the fediverse. Read and engage on the original instance.

How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service

GDS is leading the digital transformation of the UK government.

https://gds.blog.gov.uk/2024/01/17/how-we-migrated-our-postgresql-database-with-11-seconds-downtime/Open link View original on programming.dev

Comments2

2 replies

blackfire

lemmy.world

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

madwifi reply

lemmy.world

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.