Nathan Robertson <nathan(dot)robertson(at)gmail(dot)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