Re: Dying PostgreSQL backend - Mailing list pgsql-admin

From Tom Lane
Subject Re: Dying PostgreSQL backend
Date
Msg-id 23024.1020778697@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dying PostgreSQL backend  ("otisg" <otisg@iVillage.com>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: Delete function
Next
From: Stephan Szabo
Date:
Subject: Re: pg_dump failed