1、用yum 命令下载。
yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum 命令锁定 执行(Existing lock /var/run/yum.pid: another copy is running as...)
rm -f /var/run/yum.pid
2、安装 PostgreSQL:
yum install -y postgresql96-server
3、 初始化数据库并启用自动启动
/usr/pgsql-9.6/bin/postgresql96-setup initdb
systemctl enable postgresql-9.6
systemctl start postgresql-9.6
4、创建用户、设置密码
adduser postgres
passwd postgres
5、登录数据库
su postgres
psql
6、创建smartapi默认用户和数据库
CREATE USER smartapi WITH PASSWORD '123456';
CREATE DATABASE smartapi OWNER smartapi;
grant all privileges on database smartapi to smartapi; // 授权
查询刚刚创建的用户
select * from pg_user;
退出命令
#\quit
退出
exit;
7、默认不允许远程连接5432端口只能本机连,远程需要打开;
vi /var/lib/pgsql/9.6/data/postgresql.conf
listen_addresses 与 port 修改为
listen_addresses = '*'
port = 5432
保存
8、添加信任服务器
vi /var/lib/pgsql/9.6/data/pg_hba.conf
添加一行
host all all 0.0.0.0/0 trust
如下所示:
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
host all all 0.0.0.0/0 trust
保存退出:
:wq
9、重启数据库
systemctl restart postgresql-9.6.service