Re: ERROR: could not open relation with OID 2836

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not open relation with OID 2836
Date: 2008-06-26 02:32:45
Message-ID: 3306.1214447565@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rodrigo Gonzalez <rjgonzale(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2008-06-26 02:47:43 Re: IF ROW( NEW ) <> ROW( OLD )
Previous Message Craig Ringer 2008-06-26 02:21:42 Re: Serialized Access