"ERROR: role "MyUser" does not exist" when changing password for PostgreSQL owner
Issue
- We have a template based RH-SSO + PostgreSQL setup and are trying to change the PostgreSQL DB owner user password, but we get the following error:
psql -U MyUser -d root
ALTER USER MyUser WITH PASSWORD '<newpassword>';
ERROR: role "myuser" does not exist
Environment
- Red Hat Single Sign-On (RH-SSO)
- 7.5.3
- PostgreSQL
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
