Skip to content

Change a PostgreSQL password

The smartagt role serves the smartagt and smartagt_vector databases, the smartagt_bff role serves the smartagt_bff database. The services read the password at startup only.

Procedure

1. Change the role password

sudo -u postgres psql -c '\password smartagt'

Open psql with the postgres account, then enter:

\password smartagt

For the Frontend, replace smartagt with smartagt_bff.

Expected result: psql confirms without error.

2. Set the new password

Update SMARTAGT_CORE_DATABASE_PASSWORD where the installation placed it: /etc/smartagt/backend.env or /etc/smartagt/bff.env on Linux, the service environment on Windows. In a cluster, on each node concerned.

3. Restart the services

Restart all services of the component: Operations. For the Backend: Platform, the three workers and AI Gateway. Platform also restarts the built-in storage with the new password.

Expected result: the services restart without a PostgreSQL connection error.

Special cases

Dedicated vector database

If the vector database is declared on a separate server in the console, its password is stored there, encrypted. Change it in PostgreSQL, then in the console.