topic Re: Qlik Sense deployment with AWS RDS PostgreSQL in Management & Governance

Qlik Sense deployment with AWS RDS PostgreSQL

rdave — Fri, 02 Apr 2021 07:33:38 GMT

Hello All,

We have been evaluating option to use AWS RDS PostgreSQL (Currently 9.6) as dedicated database for Qlik Sense.

As of now our architecture is already on AWS EC2 instances, however postgreSQL is installed with Central Node itself, So Our Central node is becoming a Single Point of Failure which we want to avoid as we move for Highly Available Environment for Qlik Sense.

Even though Qlik provides Failover for Central nodes, there is dependency on Repo DB i.e. Repo DB has to be available for Failover to happen on another Failover candidate server.

I hope if some of you who have already implemented QlikSense on AWS can help with their experience.

Few Questions:

Your recommendations if any for QlikSense environment setup with PostgreSQL on Amazon RDS?
What are System Requirements for installing PostgreSQL on dedicated nodes or Amazon RDS? How version upgrades should be handled when PostgreSQL is on dedicated nodes/Amazon RDS?
What users (sa_) are required if any, to be created for communication between QlikSense and PostgreSQL DB installed on dedicated nodes/Amazon RDS?

Will QlikSense work with AWS RDS Aurora PostgreSQL (, which is PostgreSQL Compatible enterprise class Database) instead AWS RDS postgreSQL itself?

Appreciate your kind response.

Regards

Ravi

Re: Qlik Sense deployment with AWS RDS PostgreSQL

Anonymous — Sun, 01 Jul 2018 15:32:39 GMT

Few Questions:

Your recommendations if any for QlikSense environment setup with PostgreSQL on Amazon RDS?

-- Yes , you can use Amazon postgres rds .

What are System Requirements for installing PostgreSQL on dedicated nodes or Amazon RDS? How version upgrades should be handled when PostgreSQL is on dedicated nodes/Amazon RDS?

---- version upgrade I choose is just minor upgrade and Instance type M4.2xlarge

What users (sa_) are required if any, to be created for communication between QlikSense and PostgreSQL DB installed on dedicated nodes/Amazon RDS?

--- dont have to create any new, we used the service account user for local as well as dedicated amazon RDS

Will QlikSense work with AWS RDS Aurora PostgreSQL (, which is PostgreSQL Compatible enterprise class Database) instead of AWS RDS postgreSQL itself?

---- you can try with aurora too as has more advantages. I tried with the cluster as the endpoint

Re: Qlik Sense deployment with AWS RDS PostgreSQL

niraj8241 — Sun, 28 Apr 2019 03:37:14 GMT

Were you ever got this working? I am trying to create a dump of my existing local Postgres install and restore in AWS RDS. But seems like I am unable to do so. The restore just fails with some permissions issue or other Postgres errors.