yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
yum list | grep postgresql
yum install postgresql10-contrib postgresql10-server -y
初始化
/usr/pgsql-10/bin/postgresql-10-setup initdb
启动数据库并设置开机启动
sudo systemctl start postgresql-10
sudo systemctl enable postgresql-10.service
登录postgresql并设置密码
postgresql在安装时默认添加用户postgres
su - postgres
psql
设置密码
ALTER USER postgres WITH PASSWORD '密码';
退出:\q
默认情况下postgresql是不用密码不支持远程登录的。我们需要修改配置文件
vi /var/lib/pgsql/10/data/postgresql.conf
listen_addresses = '*' #改成 * 号
vi /var/lib/pgsql/10/data/pg_hba.conf
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 0.0.0.0/0 trust