Blob error after backup and restore
Blob error after backup and restore
От:
"ÍÁÄ·¸Ôì ÍÑ§ÈØÊÔ§Ëì" <amrit@chaiyo.com>
Дата:
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 ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...
Re: Blob error after backup and restore
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"��ķ��� �ѧ���ԧ��" 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
Postmaster
От:
Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>
Дата:
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.
Re: Blob error after backup and restore
От:
"Amrit Angsusingh" <amrit@chaiyo.com>
Дата:
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 ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...