Does Qlik support dedicated postgresql installed on Linux?

[Huiying]

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?

[Giuseppe_Novello]

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)? 

BR

Gio

[Anonymous · Accepted solution]

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

[elyMalki]

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

[arturbrandys]

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?

[elyMalki]

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.

[arturbrandys]

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

[elyMalki]

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.

[arturbrandys]

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

[elyMalki]

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