1 Reply Latest reply: Dec 15, 2015 1:58 PM by Fernando Tonial RSS

    Get the metada superuser pass installation qlik sense qmc

    Fernando Keuroglian

      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.

        • Re: Get the metada superuser pass installation qlik sense qmc
          Fernando Tonial

          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.