PostgreSQL安装

下载安装

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install -y postgresql12-server

初始化

/usr/pgsql-12/bin/postgresql-12-setup initdb

坑：
修改临时目录路径，并修改目录/tmp/pgsql的权限

vim /var/lib/pgsql/12/data/postgresql.conf
unix_socket_directories = '/var/run/postgresql, /tmp/pgsql'

chown postgres:postgres /tmp/pgsql

修改postgresql.conf

vim /var/lib/pgsql/12/data/postgresql.conf
listen_addresses = '*' # what IP address(es) to listen on;
unix_socket_directories = '/var/run/postgresql, /tmp/pgsql' # comma-separated list of directories

修改pg_hba.conf

vim /var/lib/pgsql/12/data/pg_hba.conf
#host all all 127.0.0.1/32 ident
host all all 0.0.0.0/0 md5

启动

systemctl enable postgresql-12
systemctl start postgresql-12

修改密码、授权

su - postgres
psql

ALTER USER postgres with encrypted password 'xxxxxxxxxxx';
GRANT ALL PRIVILEGES ON DATABASE postgres TO postgres
\q

连接验证

psql -h 127.0.0.1 -p 5432 -d jcmms -U postgres