Skip site navigation (1) Skip section navigation (2)

Re: ERROR: could not open relation with OID 2836

From: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not open relation with OID 2836
Date: 2008-06-27 14:05:21
Message-ID: 4864F3A1.6010208@gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Tom Lane wrote:
> Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com> writes:
>> Tom Lane wrote:
>>> No, it's clear that things are already broken before pg_dump started.
>>> You need to show us how to get to this state from a fresh database.
> 
>> Interesting....a new problem maybe, or maybe the same one....
>> ...
>> ERROR:  relation "pg_toast_1255" does not exist
> 
> Looks like almost the same problem: pg_proc's TOAST table is missing.
> But this behavior implies that the pg_class row for it is missing,
> whereas the other error suggested that the system catalog entries were
> fine but the on-disk file was missing.  Odd.
> 
> When you say "restored from backup", are you talking about a pg_dump
> backup, or what?
> 
> 			regards, tom lane

yes, a pg_dump backup.

In response to

Responses

pgsql-general by date

Next:From: Rodrigo GonzalezDate: 2008-06-27 14:28:43
Subject: Re: ERROR: could not open relation with OID 2836
Previous:From: Csaba NagyDate: 2008-06-27 14:03:30
Subject: Re: Unreferenced temp tables disables vacuum to update xid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group