How to restore postgreSQL dump file using pgAdmin?

Question

I have a .dmp file which I need to restore the database from it using the pgAdmin how can I able to do it?

Answer 1

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.

Answer 2

It is simple to recover a PostgreSQL database from a.dmp file with pgAdmin.

Restoring a PostgreSQL Database using pgAdmin:

 Steps:

Open pgAdmin

Open the pgAdmin application and connect to your PostgreSQL server using your master password.

Create a New Database

If you haven't done so already, make a new database to restore into by

Right-clicking in the browser panel on the node Databases.

Select Create > Database.

Enter a name for your new database and select Save.

Open the Restore Option:

Once the database is created, right click on the newly created database.

Select the Restore. option from the context menu.

Set Restore Options:

In the Restore dialog, you will be prompted to check several settings:

Format: Choose a format for your dump file. If your.dmp file was created by pg_dump, choose "Custom" or "Tar" depending on how it was created.

Filename: Click on the folder icon next to the Filename field and navigate to the location of your.dmp file. Select this file.

Start the restoration process

Once the settings have been configured, click on the Restore button to start restoring.

Recovery Activity Monitoring

You will get an output window where it is displaying how the restoration process is going. When the restoration is done, it displays a confirmation message showing restoration is successful.