After selecting the backup file, a window indicates that pg_restore.exe is running, and then PgAdmin is not responding, it has been a few hours (this is not a RAM shortage issue)
This may be due to the backup file size (500 MB), but I have used 300 MB for backup a few days ago The file restored the database and completed successfully.
By the way, the format of the backup file (created by pg_dump) is “tar” format.
If you have any ideas or need more information, please Tell me. I appreciate anyone’s help or advice. Thanks in advance.
The file has been generated in my backup, the size is 78 MB, I have used it to generate it again
> format: Custom
>ratio:
> Enconding: UTF8
> Rolename: postgres
I tried to restore again and it worked fine.
I am trying to restore the database (via a backup file), and I am using PgAdmin III (Postgresql 9.1).
After selecting the backup file, a window indicates that pg_restore.exe is running, and then PgAdmin is not responding. It’s been hours (this is not a RAM shortage issue)
This may be due to the backup file size (500 MB), but I have used the 300 MB backup file to restore the database a few days ago and it completed successfully .
By the way, the format of the backup file (created by pg_dump) is “tar” format.
If you have any ideas or need more information, please let me know. I appreciate anyone’s Help or pointers. Thanks in advance.
I have the same problem, I solved this web site tutorial
The file is already Generated in my backup, the size is 78 MB, I have used it to generate it again
>Format: Custom
>Ratio:
> Enconding: UTF8
> Rolename : postgres
I tried to restore again and it worked fine.