Qlik Sense deployment with AWS RDS PostgreSQL

[rdave]

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

[Anonymous]

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

[niraj8241]

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.