CODEWITHSUNDEEP
postgresqldumpdbeaver
Mary Smith
Mary Smith

Reputation: 451

How to restore a PostgreSQL database from dump file in dbeaver?

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/

Upvotes: 27

Views: 71946

Answers (2)

Lenny
Lenny

Reputation: 69

Create a new DB and right click on the db, click on tools and restore. Choose your dump and import it.

Upvotes: 5

jjanes
jjanes

Reputation: 44305

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.

Upvotes: 32

Related Questions