Question

Managed databases: major version upgrades

Posted May 5, 2020 618 views
Databases

Are major version upgrades *(e.g. PG v11 -> PG v12) *handled automatically by DigitalOcean?

Otherwise, do you manually have to export the dump and import it in a new updated cluster?

I can’t find any information in the documentation.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hi @collimarco

You can upgrade earlier versions of PostgreSQL clusters or nodes to newer versions without any downtime using the DigitalOcean Control Panel. You will be able to upgrade to the next major version without the manual work of forking and redirecting your traffic. To upgrade a cluster to a newer version of PostgreSQL, open the Databases page and then click on the cluster you want to upgrade.

On the cluster’s Overview page, scroll down to the CURRENT VERSION section and then click Upgrade Now.

Select the version of PostgreSQL you want to use.

The control panel will run an upgrade compatibility check to ensure the new version is safe to install. If the check returns Cluster Check found no issues - Safe to install, click Upgrade Now. The cluster is upgraded to the selected version. I am including the document link on how to upgrade the postgresql version:

https://docs.digitalocean.com/products/databases/postgresql/how-to/upgrade-version/

Regards,
Priyanka