CentOS7 安装postgreSQL11.5

新建用户

$sudo useradd -d /data/postgres -m postgres

$sudo passwd postgres

$su - postgres

$ wget http://ftp.postgresql.org/pub/source/v11.5/postgresql-11.5.tar.bz2

$tar jxf postgresql-11.5.tar.bz2

$cd postgresql-11.5

$./configure --prefix=/data/postgres/pgsql11 --without-readline

$make

$make install

如果找不到zlib那么先装

$sudo yum install zlib-devel

$cd /data/postgres/pgsql11/

$mkdir data

$bin/initdb -D /data/postgres/pgsql11/data

$bin/pg_ctl -D /data/postgres/pgsql11/data -l logfile start

正常启动，安装完毕

设置密码

$bin/psql -U postgres

#alter user postgres with password '123456'

postgres=# show password_encryption;
 password_encryption
---------------------
 md5
(1 row)

修改pg_hba.conf

增加一行

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
host    all             all             172.31.18.24/32         md5

配置生效

$ bin/pg_ctl reload -D data