Re: ERROR: XX000: cache lookup failed for index 2399344195

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Artem Tomyuk <admin(at)leboutique(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ERROR: XX000: cache lookup failed for index 2399344195
Date: 2017-03-28 18:21:20
Message-ID: 18075.1490725280@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Artem Tomyuk <admin(at)leboutique(dot)com> writes:
> After server crash i am getting the error ERROR: XX000: cache lookup
> failed for index 2399344195

> Is there a way to get name of this index by 2399344195???

contrib/oid2name might help you, or read

https://www.postgresql.org/docs/current/static/storage-file-layout.html

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message czezz 2017-03-29 12:34:45 Odp: Re: Re: [ADMIN] [ADMIN] Replication mode Master-Slave - maintenance question.
Previous Message Tom Lane 2017-03-28 16:27:36 Re: User defined table is not present in postgresql.