Re: cache lookup failed for index

Nathan Robertson <nathan.robertson@gmail.com> writes:
> OK, as postgres user:
> -bash-3.2$ postgres -O  -P -D /tmp/database webapp
> FATAL:  cache lookup failed for index 2662

Even with -P?  Wow, that's bad.  This DB may be just toast I'm afraid.
But try it like this:

postgres -O  -P -D /tmp/database -c log_error_verbosity=verbose webapp

This should give you the exact location of the error, which will give us
a bit better clue what's failing.

            regards, tom lane