Blob error after backup and restore [database > 5.5 Gb.] - Mailing list pgsql-admin

From Amrit Angsusingh
Subject Blob error after backup and restore [database > 5.5 Gb.]
Date
Msg-id 20050615030013.2346.qmail@chaiyo.com
Whole thread Raw
Responses Re: Blob error after backup and restore [database > 5.5 Gb.]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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.
Iuse 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 ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...

pgsql-admin by date:

Previous
From: David
Date:
Subject: Connecting via localhost pg-8.0.3
Next
From: "Ricardo Durao"
Date:
Subject: DEADLOCK INSERT