article Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows in Official Support Articles

Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows

Sonja_Bauernfeind — Wed, 01 Nov 2023 10:12:11 GMT

Before you begin: Information in this article is provided as is. Planning, configuring, and implementing of a PostgreSQL Failover and Redundancy setup is not covered by the Qlik Maintenance Policy. For assistance, contact our Professional Services or engage in our active Deployment and Management forum.

The resources below can be used to begin the planning and implementation of a Failover setup:

Data Replication between multiple PostgreSQL servers:

To fail over to a standby node in case the central database or node is lost, one or more standby databases can be configured for streaming replication from the database on the primary node.

For instructions, see Database replication and failover

Active/passive PostgreSQL servers with automatic failover capability:

Automatic failover are outside of the scope of Support and should be covered with Qlik Consulting Services.

Re: Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows

aniruddha_sinha — Wed, 25 Oct 2023 14:57:50 GMT

https://help.qlik.com/en-US/sense-admin/August2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/server-security-database-security.htm#anchor-5 steps are not working

issues faced:

1) wal_keep_segments parameter not found in any of the conf files under C:\Program Files\PostgreSQL\14\data

2) evenif i make one entry "wal_keep_segments = 8" in postgresql.conf it doesn't work

3) while running

"C:\Program Files\PostgreSQL\<version>\bin\psql.exe" -h <machinename> -p 4432 -W -c "CREATE USER replicator REPLICATION LOGIN ENCRYPTED PASSWORD 'secretpassword';"

<version> replaced with 14 (as i have standalone postgresql version 14 installed in my central node)

<machinename> replaced with centralnodename with domain (e.g. hostcentral.ad.abcd.com) -- should it local host name i.e. the central node name where i have postgresql db installed ?

secretpassword : can't I use password or do i need to encrypt it in MD5 and use ?

I am getting error like login failed, user not found etc.

Any suggestions/help please.

Re: Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows

Sonja_Bauernfeind — Wed, 01 Nov 2023 10:09:30 GMT

Hello @aniruddha_sinha

Qlik cannot assist directly in setting up a PostgreSQL failover setup, as it is not included in Qlik's maintenance agreement. If you require help on this, I recommend either posting it directly in our Qlik Sense Management and Deployment forum or contacting our Professional services for hands-on assistance.

All the best,
Sonja

Re: Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows

aniruddha_sinha — Thu, 02 Nov 2023 09:06:44 GMT

Thank you Sonja.

I raised one support case, and got help with some postgresql dba page links from where I studied and implemented the automated replication.

I have further queries on the same to understand how to point qliksense to the failover postgresql database in case my primary node goes down.

I have explained the problem statement in https://community.qlik.com/t5/Deployment-Management/How-to-switch-qlik-sense-to-failover-database-continuing-Case/td-p/2134009

Thanks again!