Upgrade a 1TB PostgreSQL DB in under 10m

#1

Post by fhackenberger » Fri, Oct 14, 2022, 8:51 AM UTC

Upgrade a 1TB PostgreSQL DB in under 10m
hackenberger.at

Re: Upgrade a 1TB PostgreSQL DB in under 10m

#2

Post by fhackenberger » Fri, Oct 14, 2022, 8:51 AM UTC

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.

Re: Upgrade a 1TB PostgreSQL DB in under 10m

#3

Post by wharfjumper » Fri, Oct 14, 2022, 9:28 AM UTC

fhackenberger wrote: post #2

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?

Re: Upgrade a 1TB PostgreSQL DB in under 10m

#4

Post by tianzhou » Fri, Oct 14, 2022, 9:45 AM UTC

wharfjumper wrote: post #3

fhackenberger wrote: post #2

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.