Take back up of AWS RDS Postgres, restore it on local.

[ashimdash]

Hi,

currently the POSTGRES for Qlik on AWS RDS.

I am trying to take back up of the POSTGRES  RDS, then install QLik with database bundle locally on the server and restore the database from back up. Then restore Qlik. 

I am getting errors when I run the pg_dump.exe command stating there is no QSR database available. - pg_dump: [archiver (db)] connection to database "qsr?" failed: fatal: database "qsr?" does not exist

I double-checked to see if the Host name, password, and users were correct. 

If anybody has attempted this, any help will be highly appreciated. 

[SimonMinifie]

Hi,

I would suggest looking at the error that you're using lowercase when specifying the data base. switch it from qsr to QSR.

Thanks,

Simon