Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Configuring PostgreSQL Failover and Redundancy for Qlik Sense Enterprise on Windows

Last Update:

Nov 1, 2023 6:12:11 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 16, 2020 7:05:42 AM

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. 

Labels (1)
Comments
aniruddha_sinha
Contributor II
Contributor II

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
Digital Support
Digital Support

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

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!

Contributors
Version history
Last update:
‎2023-11-01 06:12 AM
Updated by: