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.