By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Error restoring bytea from dump

P: 10
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,
Apr 8 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.