Re: Dying PostgreSQL backend

"otisg" <otisg(at)iVillage(dot)com> writes:
> Unfortunately, I cannot get PostgreSQL to dump core despite setting
> ulimit -c to:
> [root(at)linux2 otis]# ulimit -a
> core file size (blocks) unlimited

> And starting PostgreSQL this way:
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
> /usr/bin/postmaster start"

Most likely, the su is picking up your system default of ulimit -c 0
again :-(. I'd suggest modifying the pg_ctl script to explicitly set
ulimit -c before it starts the postmaster.

> I am really running only 2 very similar UPDATE statements.

Well, I'd like to look into it; it's not supposed to be that easy to
make PG dump core ;-). But I need information.

regards, tom lane