How do I change a password for a DB user? (On-Prem only)
- Log in to the database via SSH as a postgres user.
- Enter the following command:
ALTER USER <UserName> WITH PASSWORD <'Password'>
- Access your server via SSH.
- Navigate to this path: /home/siemplifyadmin
- Open this file by entering the command:
.bash_profile
- Change the password by entering this command:
DB_PASSWORD= <password>
- Navigate to this file: /etc/systemd/system.conf
- Change the password as follows:
@sudo systemctl set-environment DB_PASSWORD=

- Restart PostgreSQL service.