Technical questionAccepted answer
How to restore a PostgreSQL database from dump file in dbeaver?
Mary Smith
Jul 17
0 views1
In our company we have a dump of PostgreSQL database - file db.sql. It weighs 8 Gigabyte. How to restore this database in DBeaver? And we don't have another databases in DBeaver 7.0.5.
I have digged all Internet and haven't found anything how to do this without another database/
dbeaver
postgresql1 answer
Accepted answer · original discussion
jjanes
PermalinkJul 17
When you right click on the database you want to restore into, under "Tools" you will find "execute script". This is how you restore a plain-format dump file, which is what db.sql probably is.
This will require you to have psql, but dbeaver will offer to download and install its own copy of it for you.
0 question comments
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.