Επεξεργασία

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

Reset administrator password of an Azure Database for PostgreSQL flexible server

  • Άρθρο

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.

Reset server administrator password

Using the Azure portal:

  1. Select your Azure Database for PostgreSQL flexible server.

  2. In the resource menu, select Overview.

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

  4. Select the Reset password button.

    Screenshot showing how to reset password of the server administrator.

  5. In the Reset admin password panel, enter the new password in the Password and Confirm password text boxes, and select Save.

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

  6. 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.

  7. 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.

Related content