安装依赖:
yum install readline readline-devel make zlib zlib-devel
下载源码:
wget https://ftp.postgresql.org/pub/source/v9.3.2/postgresql-9.3.2.tar.gz
tar -zxf postgresql-9.3.2.tar.gz
cd postgresql-9.3.2
./configure --prefix=/usr/local/pgsql --with-openssl
gmake
gmake install
添加postgres用户,PostgreSQL的默认超级管理员
groupadd postgres
adduser -g postgres postgres
mkdir /usr/local/pgsql/data
chown postgres:postgres /usr/local/pgsql/data
测试
su - postgres
/usr/local/pgsql/bin/psql -V
初始数据库的存储区间
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data --locale=en_US.UTF8 -U postgres
启动数据库服务器
cp contrib/start-scripts/linux /etc/init.d/postgresql
chmod a+x /etc/init.d/postgresql
/etc/init.d/postgresql start
连接进数据库
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql -U postgres test
配置一下动态连接库的搜索路径和环境变量
在~./bash_profile添加如下内容:
PGHOME=/usr/local/pgsql
PGDATA=$PGHOME/data
PATH=$PATH:$HOME/bin:$PGHOME/bin
export PGHOME
export PGDATA
export PATH
----------------------------
LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH
PATH=/usr/local/pgsql/bin:$PATH
export PATH
PostgreSQL9.3安装完成。