topic Re: Superuser password on RDS in Management & Governance

Superuser password on RDS

ashimdash — Sat, 14 Oct 2023 12:00:31 GMT

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?

Has anyone done this or is there any document I can refer to?

Thank you.

Mike_Dickson — Mon, 16 Oct 2023 19:42:18 GMT

Can you please try the following:

To reset the master user password for an Amazon RDS DB instance, you can:

You can also change the superuser password in PostgreSQL by:

You can also change an ordinary user to a superuser in Postgres by using the ALTER USER command with the SUPERUSER attribute:

ashimdash — Thu, 19 Oct 2023 18:27:48 GMT

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