How can I connect to the Sense Repository PostgreSQL Database?

[syukyo_zhu]

Hi,

I want to connect to the Sense Resository PostgreSQL Database by PGAdmin in the server Qlik sense.

Has anyone in the community already done this?

[Uday_Pasupuleti]

Try this

• Run pgAdmin3.exe from C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin
• Click the power plug button on the top manual bar and enter information
• Name - QSR
• Server - localhost
• Port - 4432 (not the default of 5432)
• User Name - postgres
• Password - the password that you provided on installation.

[cheenu_janakira]

Hi Xia,

A bit late and don't know if it helps, but here is a post that also mimics Uday's post. You can connect directly into QSR/PostgreSQL with QlikSense server and use the app attached in post to look at the tables and fields in there. You don't need to go via PGAdmin.

Hope it helps.

Kr,

Cheenu

https://community.qlik.com/docs/DOC-18983

[alsahly2017]

Thank you very much ,

That was helpful.

In my case , I couldn't find "pgAdminIII"  into the provided path ,so I downloaded it from https://www.pgadmin.org/.

and I installed it into the server and it's connected.