Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Huiying
Partner - Creator III
Partner - Creator III

Does Qlik support dedicated postgresql installed on Linux?

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

10 Replies
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

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
Anonymous
Not applicable

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
Partner - Contributor II
Partner - Contributor II

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
Contributor II
Contributor II

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
Partner - Contributor II
Partner - Contributor II

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
Contributor II
Contributor II

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
Partner - Contributor II
Partner - Contributor II

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
Contributor II
Contributor II

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

elyMalki
Partner - Contributor II
Partner - Contributor II

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