
Contributor II
2024-02-16
12:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Take back up of AWS RDS Postgres, restore it on local.
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.
395 Views
1 Reply

Partner - Contributor III
2024-02-19
06:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
351 Views
