linux安装postgresql

1.安装镜像仓库

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

2. 安装 PostgreSQL

sudo yum install -y postgresql13-server

3. 初始化数据库

sudo /usr/pgsql-13/bin/postgresql-13-setup initdb

4. 启动数据库

sudo systemctl enable postgresql-13

sudo systemctl start postgresql-13

5.开放防火墙

firewall-cmd --add-port=5432/tcp --permanent

firewall-cmd --reload

6.修改默认用户密码

su - postgres //登录数据库

psql -U postgres

alter user postgres with encrypted password 'wuliang'; //修改密码

\q

Exit //退出

7.配置远程访问

vi /var/lib/pgsql/13/data/postgresql.conf

listen_addresses = '*' //在所有IP地址上监听，从而允许远程连接到数据库服务器

vi /var/lib/pgsql/13/data/pg_hba.conf c

host all all 0.0.0.0/0 md5  //允许任意用户从任意机器上以密码方式访问数据库

systemctl restart postgresql-13

8. 新建用户

create user wuliang with password 'wuliang';

9. 新建数据库

CREATE DATABASE wuliang OWNER wuliang;

10. 赋权

GRANT ALL PRIVILEGES ON DATABASE wuliang TO wuliang;

11. 查看命令

ps aux | grep postgres

netstat -npl | grep postgres

#启动，停止，重启服务

systemctl start  postgresql-13.service   //启动

systemctl stop postgresql-13.service //停止

systemctl restart postgresql-13.service //重启

#查看一个服务的状态

systemctl status postgresql-13.service

#开机时启用一个服务

systemctl enable postgresql-13.service

#开机时关闭一个服务

systemctl disable postgresql-13.service

#查看服务是否开机启动

systemctl is-enabled postgresql-13.service