tar xf postgresql-9.4.5.tar.gz
cd postgresql-9.4.5
yum grouplist
yum grouplist|grep Deve
yum groupinstall Development tools
./configure –prefix=/test/postgresql9.4.5 –without-readline –without-zlib
make && make install
mkdir /test/postgresql9.4.5/data
adduser postgres
chown postgres:postgres /test/postgresql9.4.5/data/
su – postgres
/test/postgresql9.4.5/bin/initdb -D /test/postgresql9.4.5/data/ #初始化数据库
/test/postgresql9.4.5/bin/pg_ctl -D /test/postgresql9.4.5/data/ -m start #启动数据库
/test/postgresql9.4.5/bin/pg_ctl -D /test/postgresql9.4.5/data/ -m stop #停止数据库
###################
如果想要远程访问则修改配置文件pg_hba.conf
# “local” is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 0.0.0.0/0 trust
host all all 0.0.0.0/24 md5
# IPv6 local connections:
host all all ::1/128 trust
还有postgresql.conf
listen_addresses = ‘*‘