2. 添加postgres用户

3.修改postgres环境变量

1. [postgres@localhost ~]$ vi .bash_profile
2. 新增
3. export PGPORT=1233
4. export PGHOME=/home/postgres
5. export PGDATA=/database/pg
6. export PATH=$PGHOME/bin:$PATH
7. export MANPATH=$PGHOME/share/man:$MANPATH
8. export LANG=en_US.utf8
9. export DATE=`date +"%Y-%m-%d %H:%M:%S"`
10. export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH
12. alias pg_stop='pg_ctl -D $PGDATA stop -m fast'
13. alias pg_start='pg_ctl -D $PGDATA start'
14. alias pg_reload='pg_ctl -D $PGDATA reload'

4. 通过yum安装依赖关系包

5. 上传源码包并解决

点击(此处)折叠或打开

1. [postgres@localhost ~]$ tar -zxvf postgresql-9.3.6.tar.gz
2. [postgres@localhost ~]$ cd postgresql-9.3.6
3. [postgres@localhost ~]$ ./configure --prefix=/home/postgres --with-pgport=1233  --with-perl --with-python --with-openssl --with-pam --with-ldap --with-libxml --with-libxslt --enable-thread-safety 
   
4. [postgres@localhost ~]$ make && make install
   
5. [postgres@localhost bin]$ initdb -D /database/pgdata -E UTF8 --locale=C -U postgres -W
          
6. 完成后可以看到提示：
7. Success. You can now start the database server using:
         postgres -D /database/pgdata
         or
         pg_ctl -D /database/pgdata -l logfile start
   

6.Pg数据库的启动和停止

1. 启动数据库并指定日志
2. pg_ctl -D $PGDATA -l /home/postgres/pgsql.log start
3. 关闭数据库
4. pg_ctl -D $PGDATA stop

7.登录数据库并验证

点击(此处)折叠或打开

1. [postgres@localhost bin]$ psql
2. psql (9.3.6)
3. Type "help" for help.
5. postgres=# select version();
6. version
7. --------------------------------------------------------------------------------------------------------------
8. PostgreSQL 9.3.6 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit