> [EMAIL PROTECTED] writes: > > I have set "ulimit -c unlimited" as you sugested, > > i then copied postmaster to /home/postgres > > and ran it as postgres from there... > > but still no core files. Where should they appear? > > In $PGDATA/base/yourdbnumber/core (under some OSes the file name might > be "core" plus a number). > > regards, tom lane
I have one core file (yes just one despite many duplications of the problem) and i can't get another one to appear. This one came from $PGDATA/db_ num as you said, and had .number on the end. I think the core file is from an instance of run postmaster from within gdb as it has the signal 5 rather than 11. Below is the gdb output. Thank you for your help! Core was generated by `postgres: mat test [local] SELECT ' ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
