The following bug has been logged online: Bug reference: 5736 Logged by: Henry Email address: he...@cityweb.co.za PostgreSQL version: 9.0.1 Operating system: Linux Description: 9.0.1 segmentation fault (sig11) during long-lived update Details:
Hi, I'm using PostgreSQL 9.0.1 on centos 5.4. I'm running the following update (which takes a few days to run before I get the error - twice now): update tab1 set col1 = hashtext(col0) where col1 isnull; I'm running this update as part of an exercise to purge duplicates, before creating a UNIQUE index. Error from PG: server process (PID 19328) was terminated by signal 11: Segmentation fault terminating any other active server processes ... 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? Thanks -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
