数据库crash掉，日志报错信息：
2016-08-31 12:06:25.172 CST,,,17072,,568e2c84.42b0,60,,2016-01-07 17:14:44 CST,,0,LOG,00000,"server process (PID 10613) was terminated by signal 11: Segmentation fault","Failed process was running: select count(1) from pg_stat_activity",,,,,,,,""
2016-08-31 12:06:25.172 CST,,,17072,,568e2c84.42b0,61,,2016-01-07 17:14:44 CST,,0,LOG,00000,"terminating any other active server processes",,,,,,,,,""
查看core dump：
[root@yazuodb-a1 corefile]# gdb /usr/local/postgresql-9.4.1/bin/postgres core-postgres-10613-1472616372
GNU gdb (GDB) Red Hat Enterprise Linux (7.2-64.el6_5.2)
Copyright (C) 2010 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<
Reading symbols from /usr/local/postgresql-9.4.1/bin/postgres...(no debugging symbols found)...done.
[New Thread 10613]
Missing separate debuginfo for
Try: yum --disablerepo='*' --enablerepo='*-debug*' install /usr/lib/debug/.build-id/1e/0a7d58f454926e2afb4797865d85801ed65ece
Reading symbols from /lib64/librt-2.12.so...Reading symbols from /usr/lib/debug/lib64/librt-2.12.so.debug...done.
done.
Loaded symbols for /lib64/librt-2.12.so
Reading symbols from /lib64/libdl-2.12.so...Reading symbols from /usr/lib/debug/lib64/libdl-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libdl-2.12.so
Reading symbols from /lib64/libm-2.12.so...Reading symbols from /usr/lib/debug/lib64/libm-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libm-2.12.so
Reading symbols from /lib64/libc-2.12.so...Reading symbols from /usr/lib/debug/lib64/libc-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libc-2.12.so
Reading symbols from /lib64/libpthread-2.12.so...Reading symbols from /usr/lib/debug/lib64/libpthread-2.12.so.debug...done.
[Thread debugging using libthread_db enabled]
done.
Loaded symbols for /lib64/libpthread-2.12.so
Reading symbols from /lib64/ld-2.12.so...Reading symbols from /usr/lib/debug/lib64/ld-2.12.so.debug...done.
done.
Loaded symbols for /lib64/ld-2.12.so
Reading symbols from /lib64/libnss_files-2.12.so...Reading symbols from /usr/lib/debug/lib64/libnss_files-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libnss_files-2.12.so
Core was generated by `postgres: postgres postgres [local] SELECT '.
Program terminated with signal 11, Segmentation fault.
#0 0x000000000066149b in BackendIdGetTransactionIds ()
(gdb) where
#0 0x000000000066149b in BackendIdGetTransactionIds ()
#1 0x000000000061f074 in pgstat_read_current_status ()
#2 0x000000000061f0f9 in pgstat_fetch_stat_numbackends ()
#3 0x00000000006ef3c2 in pg_stat_get_activity ()
#4 0x00000000005977fc in ExecMakeTableFunctionResult ()
#5 0x00000000005a9202 in FunctionNext ()
#6 0x00000000005983ee in ExecScan ()
#7 0x00000000005913d8 in ExecProcNode ()
#8 0x00000000005a2392 in ExecHashJoin ()
#9 0x0000000000591368 in ExecProcNode ()
#10 0x00000000005a8640 in ExecNestLoop ()
#11 0x0000000000591388 in ExecProcNode ()
#12 0x000000000059ed77 in ExecAgg ()
#13 0x0000000000591328 in ExecProcNode ()
#14 0x000000000058ff42 in standard_ExecutorRun ()
#15 0x000000000067b8f7 in PortalRunSelect ()
#16 0x000000000067caf1 in PortalRun ()
#17 0x00000000006792f4 in exec_simple_query ()
#18 0x000000000067a8d8 in PostgresMain ()
#19 0x0000000000628cf6 in PostmasterMain ()
#20 0x00000000005c15e8 in main ()
请问我该怎么继续排查错误原因？
