Επεξεργασία

Κοινή χρήση μέσω


Reset administrator password

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article provides step-by-step instructions to reset the administrator password of an Azure Database for PostgreSQL flexible server.

Steps to reset administrator password

Using the Azure portal:

  1. Select your Azure Database for PostgreSQL flexible server.

  2. In the resource menu, select Overview.

    Screenshot showing the Overview page of an Azure Database for PostgreSQL flexible server.

  3. The status of the server must be Available for the Reset password button to be enabled on the toolbar.

    Screenshot showing the status of the server set to Available.

  4. In the resource menu, under the Security section, select Authentication.

    Screenshot showing the Authentication page of an Azure Database for PostgreSQL flexible server.

  5. Assign access to must be either PostgreSQL authentication only or PostgreSQL and Microsoft Entra authentication for the Reset password button to be enabled on the toolbar. When set to Microsoft Entra authentication only, the Reset password button is disabled.

    Screenshot showing that server's authentication is configured with Microsoft Entra authentication only.

  6. If Reset password button is disabled, you can hover the mouse over it, and a tooltip describes the reason why the button is disabled.

    Screenshot showing Reset password button disabled.

  7. Select the Reset password button.

    Screenshot showing how to reset password of the server administrator.

  8. In the Reset admin password panel, enter the new password in the Password text box.

    Screenshot showing how to enter new password for the server administrator.

  9. In the Reset admin password panel, enter the new password in the Confirm password text box.

    Screenshot showing how to confirm new password for the server administrator.

  10. Select Save.

    Screenshot showing how to save the new password provided for the server administrator.

  11. A notification informs you that the password of the server administrator is being reset.

    Screenshot showing a server whose administrator's password is being reset.

  12. When the process completes, a notification informs you that the password was successfully reset.

    Screenshot showing a server whose administrator's password reset completed successfully.

Note

Resetting the password of the server administrator in read replicas isn't supported. You can reset the password of the server administrator in the primary server. That password change operation, which is recorded in the Write-Ahead Log of the primary server, is sent asynchronously to all read replicas. When a read replica receives and applies that change locally, any attempt to connect to those replicas with the server administrator user name, must be made using the new password.