Qlik Sense on a server with existing PostgreSQL database

[Christiann]

Hi,

I' ve some issues installing Qlik Sense on a server where another program already has a PostgreSQL database installed and used.

In particular, there are problems with the used ports.

Is this a configuration that is not allowed? Can I find documents about this? Or documents, how I can solve the problem?

Christian

[Eugene_Sleator · Accepted solution]

hI @Christiann  in answer to your question. 

Firstly Qlik Sense should ideally be installed on a dedicated server. 

Do-Qlik-Sense-and-QlikView-require-dedicated-servers 

But if this is not possible, the presence of another Postgres instance should not conflict with the Qlik Sense's Postgres instance regarding the ports. By default Postgres uses port 5432. The Qlik Sense Postgres instance uses 4432.  So during the installation process if you customized the port for the QSR DB to use 5432 then you would have a conflict. Otherwise, if left at the default values there should be no conflict. 

Another thing to consider is the version of Postgres installed. Depending on the version of Qlik Sense, it will either be version 9.6 or 12.5.  As of Qlik Sense May 2021 the bundled version is 12.5. Not sure what the version of the other application's Postgres instance is. But if not 9.6 or 12.5 then there could be issues. 

Qlik-Sense-May-2021-Upgrade-bundled-PostgreSQL-to-12-5-version  

Another option is not to install the QSR DB locally. But use a dedicated server to host the QSR DB. 

How-to-configure-Qlik-Sense-to-use-a-dedicated-PostgreSQL 

Hope this helps.. 

[Christiann]

Hi Eugene,

many thanks for your answer, it provides more clarity for me.

Best regards

Christian