[root@localhost ~]# mkdir -p /home/digoal/data
[root@localhost ~]# chown -R digoal /opt/pgsql_934
[root@localhost ~]# chown -R digoal /home/digoal/data

6：初始化环境变量

<pre name="code" class="sql">export PGPORT=5432
export PGDATA=/home/digoal/data
export PGPHOME=/opt/pgsql_934
export LANG=en_US.utf8
export PGHOME=/opt/pgsql_934
export LD_LIBRARY_PATH=$PGHOME/lib:/opt/pgpool/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH
export DATE=`date +"%Y%m%d%H%M"`
export PATH=$PGHOME/bin:$PATH:.:/usr/local/rj/postgresql-9.3.4/src
export PATH=/opt/pgpool/bin:$PATH:.:/usr/local/rj/postgresql-9.3.4/src
export PATH=/opt/pgsql_934/bin:$PATH
export MANPATH=$PGHOME/share/man:$MANPATH
export MANPATH=/opt/pgpool/share/man:$MANPATH
export PGUSER=postgres
export PGHOST=$PGDATA
alias rm='rm -i'
alias ll='ls -lh'
export PGDATABASE=digoal

[digoal@localhost ~]$ gdb
GNU gdb (GDB) Red Hat Enterprise Linux (7.2-60.el6_4.1)
Copyright (C) 2010 Free Software Foundation,Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
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:
<http://www.gnu.org/software/gdb/bugs/>.
(gdb) attach 34446
Attaching to process 34446
Reading symbols from /opt/pgsql_934/bin/postgres...done.
Reading symbols from /lib64/libdl.so.2...Reading symbols from /usr/lib/debug/lib64/libdl-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libm.so.6...Reading symbols from /usr/lib/debug/lib64/libm-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libc.so.6...Reading symbols from /usr/lib/debug/lib64/libc-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/ld-linux-x86-64.so.2...Reading symbols from /usr/lib/debug/lib64/ld-2.12.so.debug...done.
done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /lib64/libnss_files.so.2...Reading symbols from /usr/lib/debug/lib64/libnss_files-2.12.so.debug...done.
done.
Loaded symbols for /lib64/libnss_files.so.2
0x0000003ebb6e98d2 in __libc_recv (fd=<value optimized out>,buf=0xb110a0,n=8192,flags=0) at ../sysdeps/unix/sysv/linux/x86_64/recv.c:30
30     return INLINE_SYSCALL (recvfrom,6,fd,buf,n,flags,NULL,NULL);
(gdb) b ExecResult
Breakpoint 1 at 0x594c10
(gdb) bt
#0 0x0000003ebb6e98d2 in __libc_recv (fd=<value optimized out>,flags=0) at ../sysdeps/unix/sysv/linux/x86_64/recv.c:30
#1 0x00000000005a1420 in secure_read ()
#2 0x00000000005a99ab in pq_recvbuf ()
#3 0x00000000005a9dab in pq_getbyte ()
#4 0x0000000000650f11 in PostgresMain ()
#5 0x000000000060ee55 in PostmasterMain ()
#6 0x00000000005aba20 in main ()
(gdb) b main
Breakpoint 2 at 0x5ab6b0
(gdb) r
The program being debugged has been started already.
Start it from the beginning? (y or n) y
Starting program: /opt/pgsql_934/bin/postgres


Breakpoint 2,0x00000000005ab6b0 in main ()
(gdb) l
1    /* Run time dynamic linker.
2     Copyright (C) 1995-2006,2007,2008,2009,2010 Free Software Foundation,Inc.
3     This file is part of the GNU C Library.
4
5     The GNU C Library is free software; you can redistribute it and/or
6     modify it under the terms of the GNU Lesser General Public
7     License as published by the Free Software Foundation; either
8     version 2.1 of the License,or (at your option) any later version.
9
10     The GNU C Library is distributed in the hope that it will be useful,(gdb)
11     but WITHOUT ANY WARRANTY; without even the implied warranty of
12     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13     Lesser General Public License for more details.
14
15     You should have received a copy of the GNU Lesser General Public
16     License along with the GNU C Library; if not,write to the Free
17     Software Foundation,Inc.,59 Temple Place,Suite 330,Boston,MA
18     02111-1307 USA. */
19
20   #include <errno.h>
(gdb)
21   #include <dlfcn.h>
22   #include <fcntl.h>
23   #include <stdbool.h>
24   #include <stdlib.h>
25   #include <string.h>
26   #include <unistd.h>
27   #include <sys/mman.h>
28   #include <sys/param.h>
29   #include <sys/stat.h>
30   #include <ldsodefs.h>
(gdb)
31   #include <stdio-common/_itoa.h>
32   #include <entry.h>
33   #include <fpu_control.h>
34   #include <hp-timing.h>
35   #include <bits/libc-lock.h>
36   #include "dynamic-link.h"
37   #include <dl-librecon.h>
38   #include <unsecvars.h>
39   #include <dl-cache.h>
40   #include <dl-osinfo.h>
(gdb)
41   #include <dl-procinfo.h>
42   #include <tls.h>
43   #include <stap-probe.h>
44
45   #include <assert.h>
46
47   /* Avoid PLT use for our local calls at startup. */
48   extern __typeof (__mempcpy) __mempcpy attribute_hidden;
49
50   /* GCC has mental blocks about _exit. */
(gdb)
51   extern __typeof (_exit) exit_internal asm ("_exit") attribute_hidden;
52   #define _exit exit_internal
53
54   /* Helper function to handle errors while resolving symbols. */
55   static void print_unresolved (int errcode,const char *objname,