It did print the query right after the PANIC message, so I do have the table name. I just completed the reindex.
Thanks
---------- Original Message -----------
From: Tom Lane <tgl@sss.pgh.pa.us>
To: jim@contactbda.com
Cc: "pgsql-hackers" <pgsql-hackers@postgresql.org>
Sent: Wed, 12 Jan 2005 16:45:11 -0500
Subject: Re: [HACKERS] PANIC: right sibling's left-link doesn't match
> "Jim Buttafuoco" <jim@contactbda.com> writes:
> > Postgres on one of my big database servers just crashed with the following message
> > PANIC: right sibling's left-link doesn't match
>
> > Does any one have any idea's what might cause this.
>
> Corrupted btree index. REINDEX should help, though I'm afraid the error
> message isn't very helpful about identifying which index is busted.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
------- End of Original Message -------