question

SHABOUMalek-9351 avatar image
0 Votes"
SHABOUMalek-9351 asked SHABOUMalek-9351 edited

Upgrade Azure Database for PostgreSQL from version 9.6 to 11

Hello,

we are planning to upgrade our Azure Database for Postgres (single server) from the version 9.6 to 11.

we wish to use DMS, but in the DMS documentation: https://docs.microsoft.com/fr-fr/azure/dms/tutorial-azure-postgresql-to-azure-postgresql-online-portal

it is said that the Migration from Azure Database for PostgreSQL is supported for PostgreSQL version 10 and later

" Important

Migration from Azure Database for PostgreSQL is supported for PostgreSQL version 10 and later. You can also use this tutorial to migrate from one Azure Database for PostgreSQL instance to another Azure Database for PostgreSQL instance or Hyperscale (Citus) instance."


do DMS compatble with Azure postgresql 9.6 as source ?

Best regards.

azure-database-postgresqlazure-database-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

Hi @SHABOUMalek-9351, welcome to Microsoft QnA forum.

You can upgrade the azure PostgreSQL from version 9.6 using dump and restore process as mentioned in below article:
Upgrade your PostgreSQL database using dump and restore

Coming back to DMS for upgradation, as per the same document:

"The migration activity window appears, and the Status of the activity should update to show as Backup in Progress. You may encounter the following error when upgrading from Azure DB for PostgreSQL 9.5 or 9.6:
A scenario reported an unknown error. 28000: no pg_hba.conf entry for replication connection from host "40.121.141.121", user "sr""

I have not tried it myself but it looks with certain changes it is doable as well.

Please let us know if this helps.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SHABOUMalek-9351 avatar image
1 Vote"
SHABOUMalek-9351 answered mallikon commented

Hi,

The database is about 1-2TB, dump and restore scenario is not usable for us.

we will try the DMS replication on our pre-production.

Best regards,

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SHABOUMalek-9351, can you kindly let me know if you managed to upgrade the Azure postgres from 9.6 to 11 using DMS?

I have a similar situation, and am checking what is the best way that works with minimum downtime.

1 Vote 1 ·

@SHABOUMalek-9351
Looking for for the helpful info here. I also have to perform version upgrade from 10 to 11. Can this be done using same PostgreSQL server?

0 Votes 0 ·
SHABOUMalek-9351 avatar image
0 Votes"
SHABOUMalek-9351 answered SHABOUMalek-9351 edited

the best way is to use Azure Database Migration Service (DMS), the limit is that all tables must have a primary key.
the downtime is very short.

  • it take only the time to activate all the foreign constraint (you can do it in parallel)

  • update the sequences.

i use this method to migrate a 3TB database from 9.6 single server to 13 flexible server.


Malek,






5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.