Thread: Blob error after backup and restore
I have postgresql data [7.4.3] which has the size of more than 5 Gb. and also contains blob for reporting. I use the command pg_restore -d test test.tar test.tar = 5.5 Gb. after I try to restore it in another server which has the same environment and use the command pg_restore -d test test.tar The database "test" after restoration has the same data but no blob found . What's wrong with my command? Amrit Thailand ---------------------------------------------------------------------------------- http://www.chaiyo.com ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...
"��ķ��� �ѧ���ԧ��" <amrit@chaiyo.com> writes: > The database "test" after restoration has the same data but no blob found . What's wrong with my command? Did you use -b in the original pg_dump command? regards, tom lane
Hi Folks! What are the tasks of the postmaster process in 8.x? Is it only responsible to make the connections? And what about concurrent access and transaction management? Thanks.
Yes , my command is pg_dump -Ft -b test > test.tar And the result is test.tar which is 5.5 Gb. . Sorry for my miss typing. What's wrong with my database? Thanks Amrit Thailand ---------------------------------------------------------------------------------- http://www.chaiyo.com ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...