Bhushan Verma wrote: >>> postmaster -D /var/lib/pgsql/data > I am using the same command as you said.
I'm afraid I'm out of ideas on how to get the core dump then. You could also try attaching gdb to the backend process before it crashes, and get the backtrace from there. Something along the lines of: postmaster -D /var/lib/pgsql/data psql postgres ... ps ax | grep postgres # check the PID of the backend process psql is connected to. gdb gdb> attach <pid of backend> gdb> cont <run the query in psql that crashes> gdb> bt You still haven't posted the offending query, BTW. Is it a particular one, or does it crash at random? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
