Skip site navigation (1) Skip section navigation (2)

Re: BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Henry" <henka(at)cityweb(dot)co(dot)za>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update
Date: 2010-10-30 20:43:01
Message-ID: 23040.1288471381@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Henry" <henka(at)cityweb(dot)co(dot)za> writes:
> Before I run this again, what's the best way to proceed to get a core dump
> so I can run a gdb backtrace to provide more info?  Simply 'ulimit -c
> 5242880' as user postgres and restart PG?

I'd use "ulimit -c unlimited", myself, rather than making arbitrary
assumptions about how big the corefile might be.

Also, make sure the ulimit command is effective in the shell that will
actually launch the postmaster.  This can be tricky if your PG launch
script uses "su".  If you're using the RH or PGDG RPMs' initscript,
I'd suggest putting the ulimit command in ~postgres/.bash_profile.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Arturas MazeikaDate: 2010-10-31 01:30:13
Subject: Re: BUG #5735: pg_upgrade thinks that it did not start the old server
Previous:From: Greg StarkDate: 2010-10-30 19:19:31
Subject: Re: BUG #5732: parsing of: "WHERE mycol=123AND ..."

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group