PostgreSQL13
install
本机环境
[root@sonarqube02 ~]# cat /etc/redhat-release CentOS Linux release 7.8.2003 (Core) [root@sonarqube02 ~]# cat /proc/version Linux version 3.10.0-1127.19.1.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-39) (GCC) ) #1 SMP Tue Aug 25 17:23:54 UTC 2020
1.通过清华大学源yum安装
Index of /postgresql/ | 清华大学开源软件镜像站 | Tsinghua Open Source Mirror
1.创建repo文件
[root@sonarqube02 ~]# cat /etc/yum.repos.d/postgresql.repo [postgresql] name=postgresql baseurl=https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/13/redhat/rhel-7-x86_64/ gpgcheck=1 gpgkey=https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/RPM-GPG-KEY-PGDG-13
报错1：
Downloading packages:
warning: /var/cache/yum/x86_64/7/postgresql/packages/postgresql13-libs-13.3-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Public key for postgresql13-libs-13.3-1PGDG.rhel7.x86_64.rpm is not installed
解决1：
指定gpgkey即可
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/RPM-GPG-KEY-PGDG-13
2.安装postgresql13-server
[root@sonarqube02 ~]# yum list|grep postgresql13 postgresql13.x86_64 13.3-1PGDG.rhel7 @postgresql postgresql13-libs.x86_64 13.3-1PGDG.rhel7 @postgresql postgresql13-server.x86_64 13.3-1PGDG.rhel7 @postgresql postgresql13-contrib.x86_64 13.3-1PGDG.rhel7 postgresql postgresql13-devel.x86_64 13.3-1PGDG.rhel7 postgresql postgresql13-docs.x86_64 13.3-1PGDG.rhel7 postgresql postgresql13-llvmjit.x86_64 13.3-1PGDG.rhel7 postgresql postgresql13-odbc.x86_64 13.00.0000-1PGDG.rhel7 postgresql postgresql13-plperl.x86_64 13.3-1PGDG.rhel7 postgresql postgresql13-plpython3.x86_64 13.3-1PGDG.rhel7 postgresql postgresql13-pltcl.x86_64 13.3-1PGDG.rhel7 postgresql postgresql13-test.x86_64 13.3-1PGDG.rhel7 postgresql yum makecache yum -y install postgresql13-server.x86_64
3.启动服务
/usr/pgsql-13/bin/postgresql-13-setup initdb systemctl enable postgresql-13 systemctl start postgresql-13
4.验证
[root@sonarqube02 ~]# ps -ef|grep postgres postgres 2384 1 0 Jul30 ? 00:00:00 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/ postgres 2386 2384 0 Jul30 ? 00:00:00 postgres: logger postgres 2388 2384 0 Jul30 ? 00:00:00 postgres: checkpointer postgres 2389 2384 0 Jul30 ? 00:00:00 postgres: background writer postgres 2390 2384 0 Jul30 ? 00:00:00 postgres: walwriter postgres 2391 2384 0 Jul30 ? 00:00:00 postgres: autovacuum launcher postgres 2392 2384 0 Jul30 ? 00:00:00 postgres: stats collector postgres 2393 2384 0 Jul30 ? 00:00:00 postgres: logical replication launcher
2.通过官方二进制包安装
PostgreSQL: Linux downloads (Red Hat family)
1.选择安装包版本
2.Copy, paste and run the relevant parts of the setup script:
# Install the repository RPM: sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm # Install PostgreSQL: sudo yum install -y postgresql13-server # Optionally initialize the database and enable automatic start: sudo /usr/pgsql-13/bin/postgresql-13-setup initdb sudo systemctl enable postgresql-13 sudo systemctl start postgresql-13
test
安装完毕后，系统会创建一个数据库超级用户 postgres，密码为空
1.切换用户
[root@sonarqube02 ~]# cat /etc/passwd|grep postgres postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash [root@sonarqube02 ~]# sudo -iu postgres -bash-4.2$
[root@sonarqube02 ~]# sudo --help
sudo - execute a command as another user
Options:
-i, --login run login shell as the target user; a command may also be specified
-u, --user=user run command (or edit file) as specified user name or ID
2.这时使用以下命令进入 postgres，输出以下信息，说明安装成功：
-bash-4.2$ psql psql (13.3) Type "help" for help. postgres=#
3.输入以下命令退出 PostgreSQL 提示符：
postgres=# \q -bash-4.2$ exit logout [root@sonarqube02 ~]#