alvaro@audifarma.com.co writes:
> I'm having some strange problem with a server postgresql 7.4.3, some times
> the server crashes and restarts inmediatly, heres is the error message
> catch from the log file
> ERROR: cache lookup failed for namespace 105183855
> LOG: server process (PID 3942) exited with exit code 1
I have a suspicion that this has something to do with trying to delete
temp tables during backend exit, but it's not going to be possible to
find it without a lot more detail. You might try turning on query
logging so you can see exactly what the failed process did before
crashing.
regards, tom lane