Hacker News new | ask | show | jobs
Upgrade a 1TB PostgreSQL DB in under 10m (hackenberger.at)
2 points by fhackenberger 1338 days ago
1 comments

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.
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?
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.