Intellipaat Back

Explore Courses Blog Tutorials Interview Questions

How to restore postgreSQL dump file using pgAdmin?

0 votes
2 views
in SQL by (6.1k points)
I have a .dmp file which I need to restore the database from it using the pgAdmin how can I able to do it?

1 Answer

0 votes
by (12.7k points)
edited by

Let's see within the PgAdmin3:

  • First, create a new database within the server you are using currently.
  • Right-click on this database and select 'Restore'.
  • Then use the 'Browser' button to choose your '.dmp' file.
  • Select 'Restore' to start restoring the database.

Learn SQL by joining the Microsoft SQL Server certification course and get certified.

Related questions

0 votes
1 answer
Restore a remote dump to RDS
asked Jul 24, 2019 in AWS by yuvraj (19.1k points)
0 votes
1 answer
psql invalid command \N while restore sql
asked Jul 23, 2019 in SQL by Tech4ever (20.3k points)

Browse Categories

© COPYRIGHT 2011-2024 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...