PostgreSQL12安装
提示:非root用户,请使用sudo权限
1)导入yum源
(base) [root@song ~]# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
2)安装Postgre SQL服务
(base) [root@song ~]# yum install -y postgresql12 postgresql12-server
注意版本选择问题:
安装PostgreSQL 11就是 yum install postgresql12 postgresql12-server
安装PostgreSQL 9.5就是 yum install postgresql95 postgresql95-server
依此类推
3)初始化数据库
(base) [root@song ~]# /usr/pgsql-12/bin/postgresql-12-setup initdb
Initializing database ... OK
4)启动PostgreSQL服务
(base) [root@song ~]# systemctl start postgresql-12 #启动PostgreSQL服务
(base) [root@song ~]# systemctl enable postgresql-12 #设置PostgreSQL服务为开机启动
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-12.service to /usr/lib/systemd/system/postgresql-12.service.
9.x版本的服务名是postgresql-9.x