topic Re: Does Qlik Sense Enterprise support Postgres16 as a source database? in Connectivity & Data Prep

Does Qlik Sense Enterprise support Postgres16 as a source database?

Farshad_Razor — Fri, 25 Oct 2024 08:32:29 GMT

Hi Qlik Community,

I’m aware that Postgres 16 isn’t yet supported as the repository database for Qlik Sense Enterprise on Windows, with version 14 being the latest officially supported.

I previously posted about this on the forum, but I’m now trying to understand Qlik Sense Enterprise’s compatibility with Postgres 16 as a source database for pulling data into applications.

I haven’t found any clear guidance on this topic, and given that Postgres 16 has been available for some time, it’s a bit frustrating that we, as Qlik professionals, don’t have a definitive answer on its compatibility.

For context, we’re currently running the November 2023 Patch 9 release, and I haven’t seen any notes in the February or May updates about this compatibility. Additionally, there doesn’t seem to be any technical preview for the upcoming November 2024 release that addresses it either.

Does anyone in the community have more details on this?

Best regards,
Farshad

Re: Does Qlik Sense Enterprise support Postgres16 as a source database?

Alan_Slaughter — Fri, 25 Oct 2024 19:32:24 GMT

Hi FarshadNour, maybe this will be helpful to you:

https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/Common/system-requirements.htm

PostgreSQL:

16.x (not included in the installer)
15.x (not included in the installer)

Information noteTo use PostgreSQL versions 15 and 16, you must grant all permissions on the public schema to the qliksenserepository user for proper functionality in Qlik Sense databases. For more information, see Granting permissions for PostgreSQL versions 15 and 16.

Re: Does Qlik Sense Enterprise support Postgres16 as a source database?

Farshad_Razor — Wed, 20 Nov 2024 08:31:05 GMT

Hi Alan,

Thank you for the clarification!

I’d like to add a bit more information.
We recently upgraded some of our databases (where some data is stored) to PostgreSQL 16, and we've been able to connect and extract data seamlessly without any issues.

For anyone looking for answers related to this setup or higher
(using Qlik Sense on Windows Nov 23 / Patch 9):

Qlik Sense Repository Database (hosted on your server): ✅ Compatible with PostgreSQL 16
Source Databases (where your data resides): ✅ Compatible with PostgreSQL 16

Hope this helps!

Best regards,
Farshad