Restore a Dump File Using pgAdmin

In this post, I will show you how to restore a dump file using pgAdmin 4.

Right-click the server where you want your database to live.

Choose "Create" > "Database".

Name your database and choose its owner.

Click "Save".

Right-click the database you created.

Choose "PSQL Tool".

A tab will open on the right side. Restore the dump file using this command:

\i <path_to_your_dump_file>

Press "Enter" and wait for the database to be restored.