How restore postgreSQL dump file using pgAdmin?

Question

I've a .dmp file. Want to restore the database from it. Using pgAdmin how can I do it?

stackoverflow.com/questions/10761073/…

Sami Kuhmonen
– Sami Kuhmonen

2015-05-31 08:08:29 +00:00
Commented May 31, 2015 at 8:08 — Sami Kuhmonen
– Sami Kuhmonen, Commented May 31, 2015 at 8:08

score 37 · Accepted Answer · 2019-06-20 08:07:39Z

37

Within PgAdmin3...

Create a new database within the server you are using.
Right click this database and choose 'Restore'.
Use the 'Browser' button to select your '.dmp' file.
Select 'Restore' to start restoring the database.

edited Jun 20, 2019 at 8:07

answered May 31, 2015 at 10:22

user1322772

Sign up to request clarification or add additional context in comments.

4 Comments

fatCop Over a year ago

doesn't support '.dmp' file. I cant restore '.backup' files, but not '.dmp'

user1322772 Over a year ago

How did you create the .dmp file?

user1322772 Over a year ago

I'd just give it a try through PgAdmin - you'll probably find they're created a compressed backup (.backup file) but just named it as a .dmp file instead.

Luis Manrique Over a year ago

@fatCop to upload .dump files select all files in select list at right buttom

Collectives™ on Stack Overflow

How restore postgreSQL dump file using pgAdmin?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related