Re: BUG #16701: PostGreSQL Error : could not open relation with OID 2610 - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #16701: PostGreSQL Error : could not open relation with OID 2610
Date
Msg-id CABUevExxe6kzzBds58j7ni8jCS2-JuvHt=N2Ft1ue-uWNSRP+A@mail.gmail.com
Whole thread Raw
In response to BUG #16701: PostGreSQL Error : could not open relation with OID 2610  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Thu, Nov 5, 2020 at 9:36 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      16701
> Logged by:          Jason
> Email address:      shunqiangxu04@gmail.com
> PostgreSQL version: Unsupported/Unknown
> Operating system:   Windows Server 2012 R2  X64
> Description:
>
> Database server's version is 9.4.1  ,  After i connect to the database
> server successfully  , it appears this error   "could not open relation with
> OID 2610 "  when i connect a database named "VionCount"  , but it works well
> when i connect other database


PostgreSQL 9.4 is not a supported version, and 9.4.1 is missing over 5
years worth of bugfixes that happened while it *was* supported.

oid 2610 means pg_index. Being unable to open that means your database
is corrupt on disk. I would suggest you look into restoring the latest
backup.

You may be able to do partial recovery if you try a startup without
system indexes and immediately dump the database and reload it into a
new cluster, but going to your backups will most likely be the safer
and better choice.

-- 
 Magnus Hagander
 Me: https://www.hagander.net/
 Work: https://www.redpill-linpro.com/



pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #16702: inline code and function : when use dynamic name for rowtype, there is some bug!
Next
From: PG Bug reporting form
Date:
Subject: BUG #16703: pg-dump fails to process recursive view definition