CODEWITHSUNDEEP
sqlpostgresqlpgadmin
fatCop
fatCop

Reputation: 2586

How restore postgreSQL dump file using pgAdmin?

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

Upvotes: 23

Views: 85517

Answers (1)

user1322772
user1322772

Reputation:

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.

Upvotes: 36

Related Questions