I have a database dump in thisdb_2022.dump binary file that I'm trying to import to dbeaver, but I haven't found a way to import the database so I can see it.
I found the below in the dbeaver forum but when I try to follow the instructions and create a new connection I don't see any option I can select that will open this document.
https://dbeaver.io/forum/viewtopic.php?f=2&t=895
Edit: The database and version is PostgreSQL 12. I'm not trying todump it to an existing db rather I want to create a new one with thisdump.the dump command looks like this: pg_dump -h blah.amazonaws.com -Fc -v --dbname="blah2" -f "/tmp/dump/20220203.dump".And it will be the same version PostgreSQL 12
Best Answer
The easiest way to not use DBeaver at all.
Do:
UPDATED with correct command.
--In psqlCREATE DATABASE new_db;--Exit psql--At command linepg_restore -d new_db -h <the_host> -p <the_port> -U postgres /tmp/dump/20220203.dumpTo work in Dbeaver directly see Backup/Restore.