Hello every one,
I have a problem to restore my postgresql dumpfile. I have a postgresql database 7.3.2 in a linux environment and i want to restore the dumpfile that i make from linux environment to the postgresql 8.1.11 in a window environment. I make my backup in a postgresql 7.3.2 in linux environment with the following command :
pg_dump -b -v -Fc -Z9 -U _postgresql -f istpdb-2007-08-09.psqldump istpdb
and i try to restore it in postgresql 8.1.11 in window environment with the following command : pg_restore -U _postgresql -v -d istpdb istpdb-2007-08-08.psqldump.
when i restore it there is some error appear on window console, but the restoration is still running until finish. The problem is when i try to make a query to my table with bytea data type it crash and hang, the computer is not responding.
I hope some one can help me to solve this problem, if it is possible please reply this question as soon as possible. Thank you very much in advance.
Best regards,
Bogie
I have a problem to restore my postgresql dumpfile. I have a postgresql database 7.3.2 in a linux environment and i want to restore the dumpfile that i make from linux environment to the postgresql 8.1.11 in a window environment. I make my backup in a postgresql 7.3.2 in linux environment with the following command :
pg_dump -b -v -Fc -Z9 -U _postgresql -f istpdb-2007-08-09.psqldump istpdb
and i try to restore it in postgresql 8.1.11 in window environment with the following command : pg_restore -U _postgresql -v -d istpdb istpdb-2007-08-08.psqldump.
when i restore it there is some error appear on window console, but the restoration is still running until finish. The problem is when i try to make a query to my table with bytea data type it crash and hang, the computer is not responding.
I hope some one can help me to solve this problem, if it is possible please reply this question as soon as possible. Thank you very much in advance.
Best regards,
Bogie