Get the metada superuser pass installation qlik sense qmc

[fkeuroglian]

Hi expert

I have to upgrade the qmc in sense and first of all i have to re write the superuser password again, but i do not have it

is there any way to get or obtain this?

thank you a lot

Fernando K.

[fernando_tonial · Accepted solution]

How to reset forgotten postgreSQL password

Introduction

The installation of Qlik Sense allows for the the postgres USER in the postgreSQL database to be assigned a password.  This document outlines the steps to reset the password.

Process

1	Stop the Qlik Sense Repository Service (note: this will stop all Qlik Sense Services)
2	Open Notepad as an administrator (right click on Notepad and select Run as Administrator
3	From Notepad click File > Open Browse to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3
4	Click on All Files (*.*)
5	Take a backup of the files pg_hba.conf and postgresql.conf
6	Open the file pg_hba.conf
7	We need to change the METHOD from MD5 to TRUST in the first entry # TYPE  DATABASE USER ADDRESS METHOD Original # IPv4 local connections: host all all             127.0.0.1/32 md5 Amended # IPv4 local connections: host all all 127.0.0.1/32 TRUST
8	Save the file
9	Open the file postgresql.conf Search for the #listen_addresses key words Remove the # from listen_addresses = 'localhost' Original #listen_addresses = 'localhost' Amended listen_addresses = 'localhost'
10	Save the file
11	Start the Qlik Sense Repository Database Service
12	Launch Command Prompt and set the working directory as C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin>
13	Enter the following command psql -h 127.0.0.1 -p 4432 -U postgres The following should be displayed
14	From the postgres=# prompt enter the following SQL alter user postgres with encrypted password 'ENTERYOURNEWPASSWORD'; The following should be displayed
15	Stop the Qlik Sense Repository Database Service
16	Replace the files pga_hba.conf and postgresql.conf files with the backups created in step 5
17	Start the Qlik Sense Repository Database Service

Don't Worry, be Qlik.

Tonial.