Milen Evtimov <milen@xxxxxxxxxx> writes: > After upgrading one of our database servers from 8.1.11 on SLES9 to > 8.2.6 on CentOS 5.1, it crashed several times with following errors: > LOG: server process (PID ) was terminated by signal 29 That's pretty odd. Would you confirm what signal 29 is on your machine? (On my Fedora 8 box, the numbers are defined in /usr/include/bits/signum.h --- it's probably the same on yours.) Fedora 8 says that 29 is SIGIO a/k/a SIGPOLL, but that doesn't make any sense to me --- we don't use any calls that would trigger that. Is this a locally built copy of Postgres, or an RPM installation? If the latter, which RPM exactly? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match