How to manage related applications

New postgresql_client interface:

Relations to new applications are supported via the “postgresql_client” interface. To create a relation:

juju relate postgresql application

To remove a relation:

juju remove-relation postgresql application

Legacy pgsql interface:

We have also added support for the database legacy relation from the original version of the charm via the pgsql interface. Please note that these interface is deprecated.

juju relate postgresql:db mailman3-core

Also extended permissions can be requested using db-admin edpoint:

juju relate postgresql:db-admin mailman3-core

Rotate applications password

To rotate the passwords of users created for related applications, the relation should be removed and related again. That process will generate a new user and password for the application.

juju remove-relation application postgresql
juju add-relation application postgresql

Internal operator user

The operator user is used internally by the Charmed PostgreSQL Operator, the set-password action can be used to rotate its password.

• To set a specific password for the operator user

juju run-action postgresql/leader set-password password=<password> --wait

• To randomly generate a password for the operator user

juju run-action postgresql/leader set-password --wait