
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Superuser password on RDS
Hi Gurus,
In our environment, postgres for Qlik sense is an AWS RDS instance. Unfortunately, we have lost the password. How can I reset the password?
I tried the traditional method- https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-i... but of course, as Postgres is not Qlik sense server, commands fail.
Has anyone done this or is there any document I can refer to?
Thank you.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @ashimdash
Can you please try the following:
- Open the Amazon RDS console.
- Select Databases.
- Select the RDS DB instance, and then choose Modify.
- Enter the password that you want to use in the New Master Password field.
- Choose Continue, and then choose Modify DB Instance.
- Logging in to psql using the postgres database login role.
- Issuing the \password command.
- Typing a new password when prompted.
You can also change an ordinary user to a superuser in Postgres by using the ALTER USER command with the SUPERUSER attribute:
https://www.commandprompt.com/education/how-to-change-a-user-to-superuser-in-postgresql/
Don't forget to mark a solution that worked for you!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I apologize for the late reply. I'll try and update this thread. Thank you for your time.
