PostgreSQL

652 readers

1 users here now

The world's most advanced open source relational database

Project

About (history)
Docs
Donate to PostgreSQL
Wiki
Planet PostgreSQL
IRC
Mailing lists:
- pgsql-announce
- pgsql-hackers (developers)
- pgsql-general
- pgsql-jobs
User Groups

Events

SEAPUG Summer BBQ, 6 July in Seattle
SFBA PostgreSQL Meetup, 12 July
Chicago PostgreSQL Meetup, 19 July
PGDay UK 2023, 12 September in London
PGConf 2023, 3-5 October in New York City
PGDay Israel 2023, 19 October
PGConf.EU 2023, 12-15 December in Prague

Podcasts

postgres.fm (feed)

Related Fediverse communities

c/SQL on programming.dev
#sql on Mastodon
#postgresql on Mastodon

founded 1 year ago

MODERATORS

[email protected]

How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)

submitted 10 months ago* (last edited 10 months ago) by [email protected] to c/[email protected]

2 comments fedilink hide all child comments

GDS is leading the digital transformation of the UK government.

you are viewing a single comment's thread
view the rest of the comments

[–] blackfire 3 points 10 months ago (1 children)

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

[–] madwifi 4 points 10 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.