Thread: BUG #16701: PostGreSQL Error : could not open relation with OID 2610
BUG #16701: PostGreSQL Error : could not open relation with OID 2610
From
PG Bug reporting form
Date:
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
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/