How to manage passwords¶

In Charmed PostgreSQL 14, user credentials are managed with Juju’s get-password and set-password actions.

Get password¶

To retrieve the operator’s password:

juju run postgresql-k8s/leader get-password

To change the operator’s password to a new, randomized password:

juju run postgresql-k8s/leader set-password

To set a manual password for the operator/admin user:

juju run postgresql-k8s/leader set-password password=<password>

To set a manual password for another user:

juju run postgresql-k8s/leader set-password username=<username> password=<password>