Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Get the metada superuser pass installation qlik sense qmc

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.

1 Solution

Accepted Solutions
fernando_tonial
Partner - Specialist
Partner - Specialist

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.

Don't Worry, be Qlik.

View solution in original post

1 Reply
fernando_tonial
Partner - Specialist
Partner - Specialist

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.

Don't Worry, be Qlik.