HA setup Postgres SQL

manish_2991 — Wed, 17 Aug 2022 09:33:07 GMT

We are configuring the multinode setup for Qliksense, in that we are installing Postgres SQL on another server with HA setup on Postgres SQL.

I followed the article 'https://help.qlik.com/en-US/sense-admin/November2020/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/server-security-database-security.htm#anchor-4'.

Completed all steps but after the completion data is not getting replicated to the Standby node or RIM Node.

I have installed version 12 of Postgres SQL, so in the version 12 recovery.conf file is not there instead of that the details of recovery.conf file to be entered into postgresql.conf file only and a new file named standby.signal.conf.

'https://www.2ndquadrant.com/en/blog/replication-configuration-changes-in-postgresql-12/'

Please let me know what can be the solution for this??

Re: HA setup Postgres SQL

Eugene_Sleator — Tue, 25 Oct 2022 12:32:53 GMT

Hi @manish_2991 the article you are using is for the configuration of Postgres 9.6.
See the "Configure the standby database server (PostgreSQL 12.x)" section of this article.

Hope this helps.

topic Re: HA setup Postgres SQL in Management & Governance

HA setup Postgres SQL

Re: HA setup Postgres SQL