PgAdmin III not responding when trying to restore a database

Question

I'm trying to restore a database (via a backup file), I'm on PgAdmin III (Postgresql 9.1). After choosing the backup file, a window indicating that pg_restore.exe is running then PgAdmin is not responding ,it has been few hours (It is not a RAM shortage issue)

It might be due the backup file size (500 MB), but i have already restored a database with a 300 MB backup file few days ago, and it was done smoothly. By the way the format of the backup file ( created via pg_dump)is the "tar" format.

Please let me know if anything comes to mind or if you need any more information. I appreciate any help or pointers anyone has. Thanks in advance.

Answer 1

I have the same problem and I solved looking this web site tutorial

File has been generated in my backup with the size of 78 MB, I have generated it again using

• Format:Custom
• Ratio:
• Enconding: UTF8
• Rolename:postgres

I try to restore again and then works fine.