Dear Chris ,
pg_restore: [custom archiver] could not read data block -- expected 4096, got 3870
pg_restore: *** aborted because of error
It appears some of the data itself is not readable, which is fine, but I'd like it to skip past this table and move onto the next one. Has anyone got any ideas as to where I should look for that?
Make a plain text file out of your archive and then edit apropriately for desired results
I dont remember the way it could be done but something live
pg_restore -U <BOGUS> >> my_database.sql cat my_database.sql
Drawbacks : 1. Large database would be headache 2. Blobs would not be restored
-- Regards, Vishal Kashyap Director / Lead Software Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Yahoo IM: mailforvishal[ a t ]yahoo.com
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
