How restore postgreSQL dump file using pgAdmin?

sql postgresql pgadmin
fatCop picture fatCop · May 31, 2015 · Viewed 49.1k times · Source

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

Answer

Gareth Flowers picture Gareth Flowers · May 31, 2015

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.

Related questions

How to visualize database tables in postgresql using pgAdmin?

I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a query visualizer tool available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to …

Read More
Create an ER diagram in pgAdmin

What would be the step by step walk-through for building a basic Entity-Relationship Diagram from pgAdmin? Would there be some plugins for doing that in pgAdmin? Note: I searched in the web but other than stumbling upon an exhausting list …

Read More
how to get column size and type through my database in PostgreSQL

I've changed column length manually in my previous database. But after creating new database via HQL it's creating varchar(255) and I need to make it longer. I need to find which table's column should I change? I can find it …

Read More