Search code examples
sqlpostgresqlpgadmin

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?

Solution

  • 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.