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