23

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

asked May 31, 2015 at 7:54
1

1 Answer 1

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.
answered May 31, 2015 at 10:22
Sign up to request clarification or add additional context in comments.

4 Comments

doesn't support '.dmp' file. I cant restore '.backup' files, but not '.dmp'
How did you create the .dmp file?
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.
@fatCop to upload .dump files select all files in select list at right buttom

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.