469,596 Members | 2,288 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,596 developers. It's quick & easy.

Error restoring bytea from dump

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
0 2854

Post your reply

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

Similar topics

7 posts views Thread by Adam Smith | last post: by
48 posts views Thread by Edwin Quijada | last post: by
1 post views Thread by Rory Campbell-Lange | last post: by
5 posts views Thread by Mike Nolan | last post: by
6 posts views Thread by Egyd Csaba | last post: by
4 posts views Thread by Egyd Csaba | last post: by
5 posts views Thread by Troels Arvin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.