Azure Postgres Single server version upgrade

Question

Azure Postgres Single server version is 11. Is it possible to upgrade it to 13+ version using dump and restore as mentioned here:

https://learn.microsoft.com/en-us/azure/postgresql/how-to-upgrade-using-dump-and-restore

It should still remain Single Server.

Answer 1

It is not possible. In the document, prerequisites states:

A source PostgreSQL database server running a lower version of the engine that you want to upgrade. A target PostgreSQL database server with the desired major version Azure Database for PostgreSQL server - Single Server or Azure Database for PostgreSQL - Flexible Server.

The question asks about upgrading target.

Answer 2

Yes, you can.

The document you shared is Microsoft's official and therefore there is no doubt that you can upgrade it to any higher version using dump and restore.

Just take care of the below mentioned points:

You can upgrade your PostgreSQL server deployed in Azure Database for PostgreSQL by migrating your databases to a higher major version server using following methods.

• Offline method using PostgreSQL pg_dump and pg_restore which incurs downtime for migrating the data.
• Online method using Database Migration Service (DMS). This method provides a reduced downtime migration and keeps the target database in-sync with the source and you can choose when to cut-over. However, there are few prerequisites and restrictions to be addressed for using DMS.

The following table provides some recommendations based on database sizes and scenarios.

Choose the right approach based on your database configuration and it should be done without any issue.

To upgrade using pg_dump and pg_restore, you can refer Migrate your PostgreSQL database by using dump and restore.