Blob error after backup and restore
am 13.06.2005 13:01:34 von amrit
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
am 13.06.2005 16:35:47 von Tom Lane
"ÍÁÄ·¸Ôì ÍѧÈØÊÔ§Ëì" 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)
Re: Blob error after backup and restore
am 13.06.2005 17:27:33 von amrit
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