Menu
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/
391
Restore a database from a SQL export Make a new database: right-click on an existing one and click Create New Database. Right-click the database and click Tools > Execute script. Select the SQL file and click Start. You may need to restart DBeaver to see the schemas and tables.
PostgreSQL Dump Import process can be carried out using psql command. You can use the psql utility to recover the SQL script file created by pg_dump, pg_dumpall, or any other tool that creates compatible backup files. You can run the complete script in the dump file with the psql tool.
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.
68
Create a new DB and right click on the db, click on tools and restore. Choose your dump and import it.
2
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
