postgres

centos自带postgres启用过程

初始化数据库:

postgresql-setup initdb

启动服务:

systemctl start postgresql.service

开机启动:

systemctl enable postgresql.service

允许局域网访问:

echo "host    all             all             192.168.5.0/24          md5" >> /var/lib/pgsql/data/pg_hba.conf

配置监听ip:

echo "listen_addresses = '*'" >> /var/lib/pgsql/data/postgresql.conf

开通防火墙:

firewall-cmd --permanent --zone=public --add-port=5432/tcp
firewall-cmd --reload

修改数据库postgres用户密码:

ALTER USER postgres WITH PASSWORD 'xxxxxx';

创建数据库:

su postgres
psql
create database uc;