Qlik Sense on a server with existing PostgreSQL database

Christiann — Tue, 28 Jun 2022 08:40:53 GMT

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

Re: Qlik Sense on a server with existing PostgreSQL database

Eugene_Sleator — Tue, 28 Jun 2022 13:51:35 GMT

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..

Re: Qlik Sense on a server with existing PostgreSQL database

Christiann — Mon, 04 Jul 2022 08:53:58 GMT

Hi Eugene,

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

Best regards

Christian

topic Re: Qlik Sense on a server with existing PostgreSQL database in Management & Governance

Qlik Sense on a server with existing PostgreSQL database

Re: Qlik Sense on a server with existing PostgreSQL database

Re: Qlik Sense on a server with existing PostgreSQL database