HNGlance

Top Best New Show

Upgrade a 1TB PostgreSQL DB in under 10m

https://www.hackenberger.at/blog/2022/07/12/how-to-postgresql-upgrades-on-large-dbs/

by fhackenberger • 4 years ago

2 3 4 years ago

HA

hackenberger.at

Related Stories

Loading related stories...

Comments

3

fhackenberger• 4 years ago

We used pglogical to upgrade between from version 9.5 to 13 with minimal downtime (< 10 minutes) running a large DB installation of 1TB in size and multiple extensions.

wharfjumper• 4 years ago

Interesting. Learned about liquibase which I hadn't heard of and looks like just what we need to handle schema changes over time across environments. Anyone used it or alternatives specifically for Postgres?

tianzhou• 4 years ago

You can check out https://github.com/bytebase/bytebase. It provides a GUI for managing schema and data changes for Postgres, MySQL, Snowflake, ClickHouse, TiDB.

Disclaimer: I am one of the authors.

Source preview

hackenberger.at

HNGlance

© 2024-2026 HN Glance. Story content belongs to its original sources.

Privacy
Terms