The progress update prior to this can be found in the previous post made here
My post mid-term tasks mainly involved researching on PostgreSQL upgrade strategies for the managed CloudSQL PostgreSQL instances used in Galoy's infrastructure. The further post outlines my findings for performing seamless upgrades
Google Cloud Platform (GCP) offers two primary methods for upgrading PostgreSQL instances on CloudSQL:
- Using the in-place
pg_upgrade
tool provided by GCP - Utilizing the Database Migration Service (DMS) to perform upgrades