Change the Login Password

To change the login password for a user in your PostgreSQL cluster, send a PATCH request to the user endpoint.

Endpoint

Use the following endpoint to change the login password for a specific user in your PostgreSQL cluster:

https://api.ionos.com/databases/postgresql/clusters/{clusterId}/users/{username}

Note: The sample UUID is 498ae72f-411f-11eb-9d07-046c59cc737e.

Request

curl --request PATCH \
    --user "[e-mail]:Mb2.r5oHf-0t" \
    --header "Content-Type: application/json" \
    --data-binary '{
        "properties":{
            "password": "newMin10CharPw"
        }
    }' \

Response

The updated user is returned. The password is never returned, though.

{
  "id": "b35402eb-bd7b-512d-92c9-9726db47c101",
  "properties": {
    "system": false,
    "username": "someuser"
  },
  "type": "user"
}