How to update postgres 11 to postgres17?

Hello Cordellia Yokum,

Thanks for your question on Microsoft Q&A portal!

To upgrade your Azure PostgreSQL flexible server from version 11 to 17. The error message you mentioned indicates that upgrading with password authentication enabled isn't allowed directly from version 11.

To address this issue, you'll need to enable SCRAM authentication and reset the passwords for your users before proceeding with the upgrade.

Here’s a step-by-step guide to help you with the process:

• Enable SCRAM Authentication:
  • You can set the authentication method to SCRAM in your Azure PostgreSQL settings.
• Reset User Passwords:
  • After enabling SCRAM, you will need to reset the passwords for all users. You can do this with the following SQL command: ALTER USER your username WITH PASSWORD 'new_secure_password';
  • Ensure that each user has their password reset.
• Retry the Upgrade:
  • Once you've enabled SCRAM and reset the passwords, you should be able to retry the upgrade.

 Please refer these Microsoft documents for more clarity on upgrades:

• Connectivity using SCRAM - Azure Database for PostgreSQL | Microsoft Learn
• Major version upgrades in Azure Database for PostgreSQL flexible server - Azure Database for PostgreSQL | Microsoft Learn 
• Major version upgrade - Azure Database for PostgreSQL | Microsoft Learn

hope this helps. Let me know if you have any further questions or need additional assistance.

Also, if these answers your query, do click the "Upvote" and click "Accept the answer" of which might be beneficial to other community members reading this thread.

Thanks,

Kalyani