Reset Azure PostgreSQL Server User Password through CLI

Question

How to change/reset the password for the User in Azure Postgresql Server through CLI. I know there's a way how to reset password through Portal but am looking for resetting through Azure CLI .

I tried ALTER USER {user} WITH PASSWORD '{password}'; but it needs superuser access. As far as I know, azure_superuser access is not granted so is there any way how to reset through CLI?

Alberto Morillo · Accepted Answer · 2021-01-03 17:23:09Z

5

Answer recommended by Microsoft Azure Collective

On a single Postgresql server, you can change the administrator role's password with the following CLI command:

az postgres server update --resource-group myresourcegroup --name mydemoserver --admin-password <new-password>

On a flexible Postgresql server, You can change the administrator role's password with this CLI command

az postgres flexible-server update --resource-group myresourcegroup --name mydemoserver --admin-password <new-password>

Choose a password that has a minimum of 8 characters and a maximum of 128 characters. The password must contain characters from three of the following categories:

English uppercase letters
English lowercase letters
Numbers
Non-alphanumeric characters

answered Jan 3, 2021 at 17:23

Alberto Morillo

15.8k3 gold badges29 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mitya Over a year ago

Can this be done via Azure Portal, do you know?

Alberto Morillo Over a year ago

@Mitya. Sure you can. Please read here. learn.microsoft.com/en-us/azure/postgresql/single-server/…

Collectives™ on Stack Overflow

Reset Azure PostgreSQL Server User Password through CLI

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related