| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | "Zeno R(dot)R(dot) Davatz" <zdavatz(at)ywesee(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: corrupt data |
| Date: | 2003-07-11 21:16:00 |
| Message-ID: | Pine.LNX.4.33.0307111514210.13144-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 11 Jul 2003, Zeno R.R. Davatz wrote:
> Hi List
>
> Out of some reason our data of our postgresql database has been corrupted. When we try to connect to the database we get:
>
> psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index:
> No such file or directory
>
> REINDEX does not work. We get the same error.
>
> pgfsck gives us: wrong blockseize.
>
> We are using postgresql 7.3.3-1 (debian).
>
> Thanks for any hints and feedback.
Sounds like a bad block on the hard drive maybe?
Maybe bad ram.
You should probably test the drive and memory for errors.
Can you backup parts of the database? I.e. recover most in place and then
restore the parts you can't from backups...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2003-07-11 23:50:03 | Re: corrupt data |
| Previous Message | Rajesh Kumar Mallah | 2003-07-11 17:51:21 | Re: Error message using pg_dump with tar format |