Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows

[Sonja_Bauernfeind]

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. 

[aniruddha_sinha]

Hi

https://help.qlik.com/en-US/sense-admin/August2023/Subsystems/DeployAdministerQSE/Content/Sense_Depl... 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.

[Sonja_Bauernfeind]

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 

[aniruddha_sinha]

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

Thanks again!