topic Re: Does Qlik support dedicated postgresql installed on Linux? in Management & Governance

Does Qlik support dedicated postgresql installed on Linux?

Huiying — Mon, 19 Aug 2019 09:08:46 GMT

We currently have QlikSense Enterprise 2019 June version installed in a 6-node cluster. PostgreSQL is installed to dedicated server. Can the PostgreSQL server be Linux? Is it bad idea?

Re: Does Qlik support dedicated postgresql installed on Linux?

Giuseppe_Novello — Mon, 19 Aug 2019 13:07:26 GMT

Can you clarify " Can the PostgreSQL server be Linux", is is a physical/virtual box that has linux install and there you have postgresql? or is you are referring like Amazon RDS( or similar)?

Gio

Re: Does Qlik support dedicated postgresql installed on Linux?

Anonymous — Mon, 30 Jan 2023 09:35:16 GMT

If Qlik Sense uses a PostgreSQL database on a dedicated infrastructure, then it can use PostgreSQL version 9.6. You can run the instance of PostgreSQL on platforms including Windows, Linux or cloud-hosted services, such as Amazon RDS. However, Qlik will only offer configuration support when PostgreSQL is running on Windows. If you use Linux or Amazon RDS, it is your own responsibility to install and configure a running instance of PostgreSQL for Qlik Sense to use.

ref: link to requirements in Configure Qlik Sense Enterprise on Windows to use a dedicated PostgreSQL server

EDL

Re: Does Qlik support dedicated postgresql installed on Linux?

elyMalki — Fri, 30 Oct 2020 15:24:21 GMT

Hi,

I have seen that PostgreSQL on linux or on specific cloud service, is now supported. ( LINK ).

Has someone encountered some issue using PostgreSQL behind PGPool ?

BR,

Ely

Re: Does Qlik support dedicated postgresql installed on Linux?

arturbrandys — Thu, 31 Dec 2020 09:03:17 GMT

We have some issue using pgpool, QlikSense Logging Service is creating many connections that hangs and they exceeded the limit of pgpool connections. When this happens all the QlikSense enviroment is not accessible. Many of that connections are connected with COPY message.

How anyone has this problem?

Re: Does Qlik support dedicated postgresql installed on Linux?

elyMalki — Thu, 07 Jan 2021 09:40:16 GMT

Hi @arturbrandys

You can try to reconfigure max_pool limit to redefine connections limits.

I have spoken with Qlik Global Enterprise Architect , that he have confirmed me that third party configuration, as pgpool, is not supported by Qlik.

Re: Does Qlik support dedicated postgresql installed on Linux?

arturbrandys — Thu, 07 Jan 2021 09:55:04 GMT

We try to increase the max_pool limit a few times but connections exceeded this limits too.

We want to use pgpool in QlikSense environment to have High Avaliability database solution and in the end HA QlikSense environment (with cluster of Load Balancers for user access and disk array for files repository).

Re: Does Qlik support dedicated postgresql installed on Linux?

elyMalki — Thu, 07 Jan 2021 10:25:18 GMT

Qlik use Devart provider to communicate with PostegreSQL istance, you can modify connection parameter to limit a Max Pool Size, the default value is 90. You can use QlikSenseUtil to modify connection string.

P.S.: Pay attention that not all Qlik connections to postgreSQL instance is managed by Qlik Sense Repostiry Service.

Re: Does Qlik support dedicated postgresql installed on Linux?

arturbrandys — Thu, 07 Jan 2021 10:30:51 GMT

We saw that this huge amount of connections was created by QlikSense Logging Service.

Re: Does Qlik support dedicated postgresql installed on Linux?

elyMalki — Thu, 07 Jan 2021 17:51:05 GMT

In my Qlik experiences I not used to enable Centralized Logging mode, on database.

This is possible workaround to have a stable environment, using pgpool without connections issue.

How To Enable/Disable Centralized Logging Mode - Qlik Community - 1715388

You have to be sure that you have configured correctly pgool, about these parameters

max_pool
num_init_children

Re: Does Qlik support dedicated postgresql installed on Linux?

arturbrandys — Fri, 15 Jan 2021 12:28:30 GMT

We disable centralized logging mode (only file logging is working now) and now everything works fine using pgpool (HA for database) in our QlikSense environment.

Maybe later we can add some standalone PostgreSQL server and write logs to this one.