| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| 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 23:50:03 |
| Message-ID: | 1057967403.24304.2052.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 2003-07-11 at 01:58, 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).
>
uh oh, sounds like you might have some flakey hardware.
try vacuumdb template1 and if that gets you in you might want to do a
pg_dump and then do some hardware testing.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | T.J. Hoo | 2003-07-12 02:15:43 | PostgreSQL 7.3.3 on Windows 2000 |
| Previous Message | scott.marlowe | 2003-07-11 21:16:00 | Re: corrupt data |