topic Re: Use Postgres rds as database in AWS for qliksense in Management & Governance

Use Postgres rds as database in AWS for qliksense

Anonymous — Tue, 13 Feb 2018 17:53:07 GMT

Did anybody tried the Qliksense installation using a Postgres rds from AWS

Re: Use Postgres rds as database in AWS for qliksense

Levi_Turner — Tue, 13 Feb 2018 23:34:53 GMT

Yes, customers have used RDS as a source for the Qlik Sense Repository Database. Is there a specific question about it?

Re: Use Postgres rds as database in AWS for qliksense

Anonymous — Wed, 14 Feb 2018 07:45:16 GMT

we r trying to automate our env setup in aws cloud.

If I have to give the database information in spc.cfg file what needs to specify in the tag <dbhost>.

<?xml version="1.0"?> <SharedPersistenceConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <DbUserName>username</DbUserName> <DbUserPassword>password</DbUserPassword> <DbHost>ip/hostname</DbHost> <DbPort>4432</DbPort> <RootDir>\\server\share</RootDir> <StaticContentRootDir>\\server\share\StaticContent</StaticContentRootDir> <CustomDataRootDir>\\server\share\CustomData</CustomDataRootDir> <ArchivedLogsDir>\\server\share\ArchivedLogs</ArchivedLogsDir> <AppsDir>\\server\share\Apps</AppsDir> <CreateCluster>true</CreateCluster> <InstallLocalDb>false</InstallLocalDb> <ConfigureDbListener>true</ConfigureDbListener> <ListenAddresses>*</ListenAddresses> <IpRange>0.0.0.0/0</IpRange>  <ConfigureLogging>true</ConfigureLogging> <SetupLocalLoggingDb>true</SetupLocalLoggingDb> <QLogsWriterPassword>writerpw</QLogsWriterPassword> <QLogsReaderPassword>readerpw</QLogsReaderPassword> <QLogsHostname>ip/hostname</QLogsHostname> <QLogsPort>4432</QLogsPort> </SharedPersistenceConfiguration>

Re: Use Postgres rds as database in AWS for qliksense

Levi_Turner — Wed, 14 Feb 2018 11:22:54 GMT

The hostname (or IP) of the PostgreSQL Database: https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Installing-Si…

Re: Use Postgres rds as database in AWS for qliksense

barry_stevens — Thu, 15 Feb 2018 21:38:30 GMT

You will need to put the RDS endpoint there, you wont be able to specify an IP address as since RDS is a managed service this may change.

However I am surprised this works as I thought during install you need to supply the postgreSQL super user password which you wont have as this isn't disclosed by AWS if I recall correctly

Re: Use Postgres rds as database in AWS for qliksense

Anonymous — Thu, 15 Feb 2018 22:04:49 GMT

Berry,

Thank you so much.

I'll try that and also port 4432 we use I assume

Re: Use Postgres rds as database in AWS for qliksense

barry_stevens — Thu, 15 Feb 2018 22:08:22 GMT

Us the port that is defined in your RDS configuration

Re: Use Postgres rds as database in AWS for qliksense

Anonymous — Tue, 13 Mar 2018 15:15:30 GMT

Yes i have recently completed Qliksense November installation on AWS RDS

Whats the issue you are facing?

Re: Use Postgres rds as database in AWS for qliksense

Anonymous — Tue, 13 Mar 2018 15:19:07 GMT

Make sure this port is also part of AWS Security Group of RDS is using.

Use following points.

1-RDS End point

2-DB name(QRS is default that qliksense accepts while installation)

3-User Name

Re: Use Postgres rds as database in AWS for qliksense

Anonymous — Tue, 13 Mar 2018 17:33:08 GMT

Hi Muhammad,

Thankyou verymuch for the responding.

I tried to create the DB using the CFTemplate for rds with port 4432 and qliksenserepository as a user but I got the below error

Re: Use Postgres rds as database in AWS for qliksense

Anonymous — Wed, 14 Mar 2018 11:10:26 GMT

How you imported the db to the rds

Re: Use Postgres rds as database in AWS for qliksense

Anonymous — Tue, 03 Apr 2018 15:20:41 GMT

Hi Muhammad,

I'm trying to join the rim node to cluster in aws using rds.

the error I'm getting is error as Node not communicated.

Are there any checkpoints after installation of qliksense multinode shared persistence

Re: Use Postgres rds as database in AWS for qliksense

niraj8241 — Sun, 28 Apr 2019 05:25:42 GMT

I am really not sure if it works or not. But i am to restore my existing local postgres install to migrate it to AWS RDS. But i am unable to do so. The restore never works. Were you able to get it to work by any means.? If you have a tip to backup my existing db and restore it in RDS. It would be really helpful.