For security reasons we have to change the dbuser password in the database. So I connected to the Jira server and login into the psql console. I tried changing the password using both commands:
- alter user dbuser with password 'new password'
- \password dbuser
Then I edited the dbconfig.xml file as well with the new password. Restarted both postgresql and Jira servers and login into Jira.
Apparently this worked. But if I set a different password in the dbconfig.xml file, it also works.
I wonder what am I doing wrong. Is this how you should change the db user password or is there another procedure?
