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 ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...
FAQ