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

ashimdash — Fri, 16 Feb 2024 17:08:12 GMT

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.

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

SimonMinifie — Mon, 19 Feb 2024 11:46:47 GMT

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

topic Re: Take back up of AWS RDS Postgres, restore it on local. in Management & Governance

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

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