I have postgresql data [7.4.3] on fedora 3  which has the size of more than 5 
Gb. and also contains blob for reporting. I use the command
pg_dump -Ft -b homc > homc.tar


test.tar > 5.5 Gb.
after I try to restore it in another server which has the same environment [via 
nfs] 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 ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to