[GENERAL] Unable to open DB: 2 Errors (unexpected zero page + could not open relation with OID)

2009-01-26 Thread dave sale
Postgres 8.3.3 on 2.6.21 Some sort of corruption happened overnight and borked things on a server. Normally I'd just restore and go, but the DB was moved about 6 weeks ago and it looks like the backup task was not, shame on me. I really just need 2 very small tables out of this and then I can

Re: [GENERAL] Unable to open DB: 2 Errors (unexpected zero page + could not open relation with OID)

2009-01-26 Thread dave sale
various other databases did nothing to help. I'm in-process of the pg_internal.init method, but the first pass resulted in the same error. I'm not giving up yet... thanks dave Tom Lane wrote: > dave sale writes: >> psql: FATAL: could not open relation with OID 3606 > >&