"Henry" <he...@cityweb.co.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs