QlikSense forgot postgres password

Bacckgroud

How can we do if we forgot the qlik pgsql password.

• Reset the forgotten password
• Add a new superuser

Connection information for reference:

Solution

• goto machine , win menu -> run notepad as admin (or other tool depends on your machine)

• Goto pgsql/repository config folder C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6\ and edit pg_hba.conf file
  

• Set host all all 127.0.0.1/32 md5, md5 to trust (so that can connect to pgsql without password)

• Goto pgsql program folder on D:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin , shift+right click then run cmd here
  

• input “pgsql -h 127.0.0.1 -p 4432 -U postgres” (if not set the md5 to trust , it will show the error and let u input the password. If u have password that can ignore this step)

Add New Superuser:

• input “CREATE USER qlikcheck WITH PASSWORD 'xxxx'” (create new user)
• input “grant postgres to qlikcheck” (copy the postgres role to qlikcheck, postgres as superuser, so our new account also has superuser role)

Reset Password:

• input “ALTER USER postgres WITH PASSWORD 'new_password';” to reset the postgrespassword
  

• Set back the trust to md5 (for security)
  

• Goto Hub and create a new connection to verify it