Centso安装PostgreSQL

1、拉去PostgreSQL源码包

[root@c3349c483e7c ~]# wget https://ftp.postgresql.org/pub/source/v9.6.3/postgresql-9.6.3.tar.gz

2、解压PostgreSQL源码包

tar -xzvf postgresql-9.6.3

3、安装PostgreSQL依赖包，zlib-devel,gcc,gcc-c++
readline-devel，make，并进行编译安装

[root@c3349c483e7c ~]# yum -y install zlib-devel gcc gcc-c++ readline-devel make
[root@c3349c483e7c ~]# postgresql-9.6.3
[root@c3349c483e7c postgresql-9.6.3]# ./configure --prefix=/opt/postgresql --enable-debug #这样就表示该扩展能够进行调试了，然后编译该扩展，使用命令
[root@c3349c483e7c postgresql-9.6.3]# make && make install

4、配置环境变量

[root@c3349c483e7c postgresql-9.6.3]# useradd postgres
[root@c3349c483e7c postgresql-9.6.3]# vi /home/postgres/.bash_profile
 export PGHOME=/opt/postgresql
 export PGDATA=/opt/postgresql/data
 export PATH=$PATH:$HOME/bin:$PGHOME/bin 
 export LD_LIBRARY_PATH=/opt/postgresql/lib    
[root@c3349c483e7c postgresql-9.6.3]# source /home/postgres/.bash_profile

6.创建目录并初始化数据库

[root@c3349c483e7c postgresql-9.6.3]# chown postgres:postgres /opt/postgresql
[root@c3349c483e7c postgresql-9.6.3]# su postgres
[postgres@c3349c483e7c postgresql-9.6.3]$ cd /opt/postgresql/
[postgres@c3349c483e7c postgresql]$ mkdir data logs
[postgres@c3349c483e7c postgresql]$ init

7.启动停止postgresql

[postgres@c3349c483e7c postgresql]$ pg_ctl -D /opt/postgresql/data -l /opt/postgresql/logs/psql.log start
[postgres@c3349c483e7c postgresql]$ pg_ctl  stop

8、测试数据库

[postgres@c3349c483e7c postgresql]$ psql