How restore postgreSQL dump file using pgAdmin?

Question

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

http://stackoverflow.com/questions/10761073/how-to-restore-postgresql-dump-file-into-postgres-databases — Sami Kuhmonen, May 31 '15 at 08:08

Gareth Flowers · Accepted Answer · 2019-06-20T08:07:39.060

36

Within PgAdmin3...

edited Jun 20 '19 at 08:07

answered May 31 '15 at 10:22

Gareth Flowers

3

doesn't support '.dmp' file. I cant restore '.backup' files, but not '.dmp' – fatCop May 31 '15 at 10:48
How did you create the .dmp file? – Gareth Flowers May 31 '15 at 10:51
1

I'd just give it a try through PgAdmin - you'll probably find they're created a compressed backup (.backup file) but just named it as a .dmp file instead. – Gareth Flowers Jun 01 '15 at 20:38
1

@fatCop to upload .dump files select all files in select list at right buttom – Luis Manrique Jan 10 '20 at 12:00

1 Answers1