PostgreSQL Installation Documentation

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 #停止数据库

###################

Modify the configuration file if you want remote access pg_hba.conf

# "Local" is for Unix domain sockets connections only
Local all All trust
# IPV4 Local connections:
Host All 0.0.0.0/0 Trust
Host All 0.0.0.0/24 MD5
# IPV6 Local connections:
Host all:: 1/128 Trust

and a postgresql.conf.

listen_addresses = ' * '

PostgreSQL Installation Documentation