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