"otisg" <otisg@iVillage.com> writes:
> Unfortunately, I cannot get PostgreSQL to dump core despite setting
> ulimit -c to:
> [root@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