pg2(at)onet(dot)eu writes:
> 2010-01-27 10:34:01 CET [3931]: [9-1] host=,user=,db= LOG: server process (PID 24454) was terminated by signal 11: Segmentation fault
> I have 8.4.0 version.
The *first* thing to do is update to 8.4.2 to see if the problem was
already fixed.
If not, you need to try to gather some data. What query was running in
the crashed backend would be useful to know, and a stack trace would be
even better.
> Do you have any idea where problem could be? Is it hardware or rather PostgreSQL configuration problem?
It could be a hardware problem or a software bug. How reproducible is
it?
regards, tom lane