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 =3D 5.5 Gb.
after I try to restore it in another server which has the same environmen=
t 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 äªâÂàÁÅì - ¿ÃÕÍÕàÁÅ=
ìÃٻẺãËÁ=E8 Ê´ãÊ¡ÇèÒà´ÔÁ...

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if you=
r
joining column's datatypes do not match

Re: Blob error after backup and restore

"ÍÁÄ·¸Ôì ÍѧÈØÊÔ§Ëì" 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Postmaster

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Blob error after backup and restore

Yes , my command is=20

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?=20
Thanks
Amrit
Thailand



------------------------------------------------------------ -------------=
---------
http://www.chaiyo.com äªâÂàÁÅì - ¿ÃÕÍÕàÁÅ=
ìÃٻẺãËÁ=E8 Ê´ãÊ¡ÇèÒà´ÔÁ...

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if you=
r
joining column's datatypes do not match