topic Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik in Management & Governance

Did anyone move postgres to its own standalone server? Is this solution supported by qlik

Karthik3 — Thu, 07 Sep 2023 17:46:22 GMT

Hi,

We have moved postgresdb to its own standalone server. Its on Windows OS. Is own postgresdb supported by Qlik? Can someone who deployed this solution answer?

Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik

Chip_Matejowsky — Thu, 07 Sep 2023 18:06:30 GMT

Hi @Karthik3,

Yes, running the PostgreSQL database on a dedicated/stand alone server is supported. Refer to the following documentation for more details.

How to configure Qlik Sense to use a dedicated PostgreSQL database

Installing and configuring PostgreSQL

Best Regards

Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik

Karthik3 — Thu, 07 Sep 2023 18:08:49 GMT

Thanks Chip,

Even I thought the same and seen those articles and implemented the solution but qlik is saying now that its not supported. So confused. Looking for someone who actually done this.

Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik

RafaelBarrios — Thu, 07 Sep 2023 18:19:50 GMT

Hi @Karthik3

i have an installation with 3 qlik senses node and a separeted one for postgres repository and fileserver for qvds, excels, csv, etc.

what is not supporte is old 9.6 version

https://help.qlik.com/en-US/sense-admin/August2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/upgrade_qlikSense/upgrade_QSEoW_planning.htm

in the end you can see the option of installing in a dedicated infraestruture

Hope this helps.

help users find answers! Don't forget to mark a solutions that worked for you & to smash the like button!

Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik

Karthik3 — Thu, 07 Sep 2023 18:35:41 GMT

Thanks rafeal. I have seen this article too but thanks for pasting it again here. Will send this as proof. I will enquire who in qlik is saying its not supported.

I changed db encryption from Md5 to scram and also moved postgres to its own server but the connection is not working unless in the pg_hba file md5 is mentioned. If we keep scram in pg_hba the connection to central and postgres does not work. This seems to be a bug in qlik and when contacted support they said its not supported.

Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik

RafaelBarrios — Thu, 07 Sep 2023 18:46:39 GMT

you can be sure it is fully supported with the correct version, and it is always my recommended installation.

as far as i know, it has to be md5 (but can't be 100% sure)

Best,

help users find answers! Don't forget to mark a solutions that worked for you & to smash the like button!

Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik

Karthik3 — Fri, 08 Sep 2023 09:57:37 GMT

Rafaeal,

For postgres do you have a VM or a physical server?

Re: Did anyone move postgres to its own standalone server? Is this solution supported by qlik

RafaelBarrios — Fri, 08 Sep 2023 12:45:52 GMT

Hi @Karthik3

my best example:

3 VM: Qlik Sense node in AWS m5.8xlarge

1 VM: Postgres Repository & Shared Folder in AWS m5.xlarge

Hope this helps.

👉 help users find answers! Don't forget to mark a solutions that worked for you & to smash the like button!