**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.
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
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