PostgreSQL password update [podman]

1. Change the password inside the database

Connect to the running database container using Podman:

podman exec -it clrt4-db psql -U postgres

Run the SQL command to update it:

ALTER USER postgres WITH PASSWORD 'your_new_password';

Type \q to exit.

2. Update the Quadlet files

Update /etc/containers/systemd/clrt4-backend.container with the new password:

• the standalone DBPASS backend environment variable:

  Environment=DBPASS=your_new_password
  

• the dbPassword value in EUROPA_CONF JSON configuration string

  Environment=EUROPA_CONF='{"env": "prod", "dbHost": "localhost", "dbName": "thebe", "dbUser": "postgres", "dbPassword": "your_new_password", "dbPort": 5432, "nConcurrentProcesses": 1, "nCores": 4, "niceness": 17}'
  

3. Apply the changes

Reload systemd and restart the backend service so it picks up the new credentials:

sudo systemctl daemon-reload
sudo systemctl clrt4-backend.service