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:

PropertyValue
Connection NamePostgreSQL_localhost
Host Namelocalhost
Port4432
Database NameQSR
Database Userqlikcheck
Database Passxxxx

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
    在这里插入图片描述

已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: 博客之星2020 设计师:CY__ 返回首页