[root@bludgeon ~]# ps auwwx | grep -i postgres | grep local pgsql 15861 12.0 3.9 178184 81048 - Ss 3:11PM 0:01.68 postgres: deployment pg93_postgis21_sig10 [local] (postgres) pgsql 15779 0.0 0.8 80004 17024 2 S 3:04PM 0:00.04 /usr/local/bin/postgres -D /var/db/pgsql/data [root@bludgeon ~]# gdb -p 15861 GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "amd64-marcel-freebsd". Attaching to process 15861 /usr/src/gnu/usr.bin/gdb/libgdb/../../../../contrib/gdb/gdb/solib-svr4.c:1444: internal-error: legacy_fetch_link_map_offsets called without legacy link_map support enabled. A problem internal to GDB has been detected, further debugging may prove unreliable. Quit this debugging session? (y or n) n /usr/src/gnu/usr.bin/gdb/libgdb/../../../../contrib/gdb/gdb/solib-svr4.c:1444: internal-error: legacy_fetch_link_map_offsets called without legacy link_map support enabled. A problem internal to GDB has been detected, further debugging may prove unreliable. Create a core file of GDB? (y or n) n Reading symbols from /usr/local/bin/postgres...done. Reading symbols from /usr/local/lib/libintl.so.9...done. Loaded symbols for /usr/local/lib/libintl.so.9 Reading symbols from /usr/local/lib/libxml2.so.2...done. Loaded symbols for /usr/local/lib/libxml2.so.2 Reading symbols from /usr/lib/libssl.so.7...done. Loaded symbols for /usr/lib/libssl.so.7 Reading symbols from /lib/libcrypto.so.7...done. Loaded symbols for /lib/libcrypto.so.7 Reading symbols from /lib/libm.so.5...done. Loaded symbols for /lib/libm.so.5 Reading symbols from /lib/libc.so.7...done. Loaded symbols for /lib/libc.so.7 Reading symbols from /lib/libz.so.6...done. Loaded symbols for /lib/libz.so.6 Reading symbols from /usr/lib/liblzma.so.5...done. Loaded symbols for /usr/lib/liblzma.so.5 Reading symbols from /usr/local/lib/postgresql/plpgsql.so...done. Loaded symbols for /usr/local/lib/postgresql/plpgsql.so Reading symbols from /usr/local/lib/postgresql/postgis-2.1.so...done. Loaded symbols for /usr/local/lib/postgresql/postgis-2.1.so Reading symbols from /usr/local/lib/libgeos_c.so.1...done. Loaded symbols for /usr/local/lib/libgeos_c.so.1 Reading symbols from /usr/local/lib/libproj.so.7...done. Loaded symbols for /usr/local/lib/libproj.so.7 Reading symbols from /usr/local/lib/libjson-c.so.2...done. Loaded symbols for /usr/local/lib/libjson-c.so.2 Reading symbols from /usr/local/lib/libgeos-3.4.2.so...done. Loaded symbols for /usr/local/lib/libgeos-3.4.2.so Reading symbols from /usr/lib/libc++.so.1...done. Loaded symbols for /usr/lib/libc++.so.1 Reading symbols from /lib/libcxxrt.so.1...done. Loaded symbols for /lib/libcxxrt.so.1 Reading symbols from /lib/libgcc_s.so.1...done. Loaded symbols for /lib/libgcc_s.so.1 Reading symbols from /usr/local/lib/postgresql/rtpostgis-2.1.so...done. Loaded symbols for /usr/local/lib/postgresql/rtpostgis-2.1.so Reading symbols from /usr/local/lib/libgdal.so...done. Loaded symbols for /usr/local/lib/libgdal.so Reading symbols from /usr/local/lib/libjasper.so.4...done. Loaded symbols for /usr/local/lib/libjasper.so.4 Reading symbols from /usr/local/lib/libgif.so.5...done. Loaded symbols for /usr/local/lib/libgif.so.5 Reading symbols from /usr/local/lib/libjpeg.so.11...done. Loaded symbols for /usr/local/lib/libjpeg.so.11 Reading symbols from /usr/local/lib/libgeotiff.so.2...done. Loaded symbols for /usr/local/lib/libgeotiff.so.2 Reading symbols from /usr/local/lib/libtiff.so.4...done. Loaded symbols for /usr/local/lib/libtiff.so.4 Reading symbols from /usr/local/lib/libpng15.so.15...done. Loaded symbols for /usr/local/lib/libpng15.so.15 Reading symbols from /usr/lib/librt.so.1...done. Loaded symbols for /usr/lib/librt.so.1 Reading symbols from /lib/libthr.so.3...done. [New Thread 802dd8800 (LWP 100651/postgres)] Loaded symbols for /lib/libthr.so.3 Reading symbols from /usr/local/lib/libjbig.so.1...done. Loaded symbols for /usr/local/lib/libjbig.so.1 Reading symbols from /libexec/ld-elf.so.1...done. Loaded symbols for /libexec/ld-elf.so.1 [Switching to Thread 802dd8800 (LWP 100651/postgres)] 0x0000000801ed8f28 in recvfrom () from /lib/libc.so.7 (gdb) c Continuing. Program received signal SIGBUS, Bus error. 0x000000000060b1d2 in std_fetch_func (stats=0x807846852, rownum=0, isNull=0x7fffffffca57 "?") at analyze.c:1755 1755 HeapTuple tuple = stats->rows[rownum]; Current language: auto; currently minimal (gdb) bt #0 0x000000000060b1d2 in std_fetch_func (stats=0x807846852, rownum=0, isNull=0x7fffffffca57 "?") at analyze.c:1755 #1 0x0000000807c3fea7 in geometry_estimated_extent () from /usr/local/lib/postgresql/postgis-2.1.so #2 0x000000000060777f in do_analyze_rel (onerel=0x802e2ee10, vacstmt=0x802c5dae0, acquirefunc=0x606590 , relpages=1, inh=0 '\0', elevel=17) at analyze.c:527 #3 0x0000000000606515 in analyze_rel (relid=58705, vacstmt=0x802c5dae0, bstrategy=0x80781a038) at analyze.c:267 #4 0x0000000000690f32 in vacuum (vacstmt=0x802c5dae0, relid=0, do_toast=1 '\001', bstrategy=0x80781a038, for_wraparound=0 '\0', isTopLevel=1 '\001') at vacuum.c:254 #5 0x0000000000839cc3 in standard_ProcessUtility (parsetree=0x802c5dae0, queryString=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x802c5de88, completionTag=0x7fffffffd480 "") at utility.c:639 #6 0x00000000008393eb in ProcessUtility (parsetree=0x802c5dae0, queryString=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x802c5de88, completionTag=0x7fffffffd480 "") at utility.c:309 #7 0x0000000000838f78 in PortalRunUtility (portal=0x802dce038, utilityStmt=0x802c5dae0, isTopLevel=1 '\001', dest=0x802c5de88, completionTag=0x7fffffffd480 "") at pquery.c:1187 #8 0x0000000000837f68 in PortalRunMulti (portal=0x802dce038, isTopLevel=1 '\001', dest=0x802c5de88, altdest=0x802c5de88, completionTag=0x7fffffffd480 "") at pquery.c:1318 #9 0x00000000008375bd in PortalRun (portal=0x802dce038, count=9223372036854775807, isTopLevel=1 '\001', dest=0x802c5de88, altdest=0x802c5de88, completionTag=0x7fffffffd480 "") at pquery.c:816 #10 0x0000000000832e21 in exec_simple_query (query_string=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;") at postgres.c:1048 #11 0x0000000000832150 in PostgresMain (argc=1, argv=0x802c0c210, dbname=0x802c0c058 "pg93_postgis21_sig10", username=0x802c0c030 "deployment") at postgres.c:4007 #12 0x00000000007b8842 in BackendRun (port=0x802c71200) at postmaster.c:4011 #13 0x00000000007b7e17 in BackendStartup (port=0x802c71200) at postmaster.c:3685 #14 0x00000000007b4090 in ServerLoop () at postmaster.c:1586 #15 0x00000000007b1984 in PostmasterMain (argc=3, argv=0x7fffffffdbe8) at postmaster.c:1253 #16 0x00000000006f912c in main (argc=3, argv=0x7fffffffdbe8) at main.c:226