Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ashimdash
Contributor II
Contributor II

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.

Labels (1)
2 Replies
Mike_Dickson
Support
Support

Hello @ashimdash 

Can you please try the following:

To reset the master user password for an Amazon RDS DB instance, you can: 
 
  1. Open the Amazon RDS console.
  2. Select Databases.
  3. Select the RDS DB instance, and then choose Modify.
  4. Enter the password that you want to use in the New Master Password field.
  5. Choose Continue, and then choose Modify DB Instance.
You can also change the superuser password in PostgreSQL by: 
 
  1. Logging in to psql using the postgres database login role.
  2. Issuing the \password command.
  3. 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/

Sr. Technical Support Engineer with Qlik Support
Don't forget to mark a solution that worked for you!
ashimdash
Contributor II
Contributor II
Author

I apologize for the late reply. I'll try and update this thread. Thank you for your time.