7 ms·

Upgrade a 1TB PostgreSQL DB in under 10m

• fhackenberger 4y 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 4y 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 4y ago
      You can check out https://github.com/bytebase/bytebase 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.