Upgrage from postgresql version 10 to version 11

Question

Azure Database for PostgreSQL will be retiring PostgreSQL version 10 on 10 Nov 2022. I need to upgrade postgresql to version 11.
How can i upgrade Azure Database for PostgreSQL

Answer 1

Hi @Ömer ŞAHİN , welcome to Microsoft Q&A forum.

As I understand you want to upgrade your PostgreSQL server to higher version.

This can be achieved through 2 ways:

1). Offline Migration: This is done using pg_dump and pg_restore which incurs downtime for migrating the data. This document addresses this method of upgrade/migration. Please read through the below article for more details on this:

Prerequisites for using dump and restore with Azure Database for PostgreSQL

2). Online Migration: This is done using Database Migration Service. This is explained step by step in below article:

Tutorial: Migrate/Upgrade Azure DB for PostgreSQL - Single Server to Azure DB for PostgreSQL - Single Server online using DMS via the Azure portal

Please also refer to below table to choose which method can best suit your requirements:

Please note that we need to create a new Azure PostgreSQL server with higher version (version we want to migrate to) in both the methods and then use any of these methods to migrate

Referenced Article: Upgrade your PostgreSQL database using dump and restore

Please let us know if this helps or else we can discuss further on the same.

----------

If answer is helpful please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!

Answer 2

there are 3 methods to upgrade PostgreSQL major version:

1. Upgrade PostgreSQL database using pg_dump and pg_restore.
2. Upgrade PostgreSQL database using pg_upgrade.
3. Upgrade PostgreSQL database using logical replication.