Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: could not open relation with OID 2836 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: could not open relation with OID 2836
Date
Msg-id 3306.1214447565@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: could not open relation with OID 2836  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Responses Re: ERROR: could not open relation with OID 2836  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
List pgsql-general
Tree view 
Rodrigo Gonzalez <rjgonzale@gmail.com> writes:
> PgSQL is returning that error when I open pgdmin and when I run some
> queries related to pg_buffercache. Also pg_dump cannot dump the DB.
> PgSQL version is 8.3.3 and happened one day after loading the DB there.

That raises a lot of questions about the trustworthiness of the platform
you're using (hardware, kernel, etc).  In 8.3, 2836 is pg_proc's TOAST
table and should certainly never get deleted.  I think you have
filesystem or hardware issues.

            regards, tom lane

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Serialized Access
Next
From: "Richard Broersma"
Date:
Subject: Re: IF ROW( NEW ) <> ROW( OLD )