Mike Blackwell wrote:
> The following are the relevant log entries from a recent crash of v9.1.1 running on an older RHEL
> Linux box. This is the first crash we've experienced in a lot of years of running Pg. Any assistance
> in how to determine what might have caused this is welcome.
>
> 2012-02-10 13:55:59 CST [15949]: [37-1] @ LOG: 00000: server process (PID 32670) was terminated by
> signal 11: Segmentation fault
[...]
It is difficult to find out anything after the crash if the problem
cannot be reproduced.
If you happen to have changed the core file ulimit setting away from the
default zero, you should have a core file in the data directory which
can be used to create a backtrace which shows you where the server
crashed. And even that only really helps with a debug build.
Other than that, you could make sure that hard disk and memory have
no problem (you write that it is an older box). You can try to find
out what the server was doing at the time and if you can reproduce it.
Crashes are also often caused by nonstandard C funxtions that have
been loaded into the database.
Yours,
Laurenz Albe