First - apologies for the stuff about "i don't understand why there's only one core file", i now have a post-it note now saying "ulimit gets reset at reboot" (i assume thats what happened).
So please find below a potentially more useful core file gdb output: Core was generated by `postgres: mat test [local] SELECT '. Program terminated with signal 11, Segmentation fault. Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /usr/lib/libreadline.so.4...done. Loaded symbols for /usr/lib/libreadline.so.4 Reading symbols from /lib/libtermcap.so.2...done. Loaded symbols for /lib/libtermcap.so.2 Reading symbols from /lib/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib/libresolv.so.2...done. Loaded symbols for /lib/libresolv.so.2 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/libdl.so.2...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/tls/libm.so.6.1...done. Loaded symbols for /lib/tls/libm.so.6.1 Reading symbols from /lib/tls/libc.so.6.1...done. Loaded symbols for /lib/tls/libc.so.6.1 Reading symbols from /lib/ld-linux-ia64.so.2...done. Loaded symbols for /lib/ld-linux-ia64.so.2 Reading symbols from /usr/local/pgsql/lib/tsearch2.so...done. Loaded symbols for /usr/local/pgsql/lib/tsearch2.so #0 SN_create_env (S_size=0, I_size=2, B_size=1) at api.c:6 6 z->p = create_s(); -- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
