Обсуждение: 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 ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...