centos7下安装postgresql13

[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

[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=1gpgkey=https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/RPM-GPG-KEY-PGDG-13

[root@sonarqube02 ~]# yum list|greppostgresql13
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

yummakecache
yum -y install postgresql13-server.x86_64

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

systemctl enable postgresql-13systemctl start postgresql-13

[root@sonarqube02 ~]# ps -ef|greppostgres
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:00postgres: logger 
postgres   2388   2384  0 Jul30 ?        00:00:00postgres: checkpointer 
postgres   2389   2384  0 Jul30 ?        00:00:00postgres: background writer 
postgres   2390   2384  0 Jul30 ?        00:00:00postgres: walwriter 
postgres   2391   2384  0 Jul30 ?        00:00:00postgres: autovacuum launcher 
postgres   2392   2384  0 Jul30 ?        00:00:00postgres: stats collector 
postgres   2393   2384  0 Jul30 ?        00:00:00 postgres: logical replication launcher 

# 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

[root@sonarqube02 ~]# cat /etc/passwd|greppostgres
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash

[root@sonarqube02 ~]# sudo -iu postgres
-bash-4.2$ 

-bash-4.2$ psql 
psql (13.3)
Type "help" forhelp.

postgres=# 

postgres=# q

-bash-4.2$ exit
logout
[root@sonarqube02 ~]# 

ALTER USER postgres PASSWORD 'postgres';

## 创建用户
创建用户名称为postgre02，并具有创建数据库和创建角色的权限
CREATE USER postgre02 PASSWORD '123456789'CREATEDB CREATEROLE  ;

## 删除用户
使用DROP USER删除账户“postgre02”

DROP USER postgre02;

## 下载库文件
wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-2-1.noarch.rpm
## 安装
rpm -ivh pgadmin4-redhat-repo-2-1.noarch.rpm

[root@sonarqube01 ~]# rpm -qpl pgadmin4-redhat-repo-2-1.noarch.rpm
/etc/pki/rpm-gpg/PGADMIN_PKG_KEY
/etc/yum.repos.d/pgadmin4.repo            ## 添加了pgadmin的repo

## 安装pgadmin web端
# Install forweb mode only.
sudo yum -y install pgadmin4-web

sudo /usr/pgadmin4/bin/setup-web.sh

[root@sonarqube01 ~]# cd /var/lib/pgsql/13/data/[root@sonarqube01 data]# lsbase              pg_commit_ts   pg_logical    pg_serial     pg_subtrans  pg_wal                postmaster.opts
current_logfiles  pg_dynshmem    pg_multixact  pg_snapshots  pg_tblspc    pg_xact               postmaster.pid
global            pg_hba.conf    pg_notify     pg_stat       pg_twophase  postgresql.auto.conf
log               pg_ident.conf  pg_replslot   pg_stat_tmp   PG_VERSION   postgresql.conf
[root@sonarqube01 data]# vim postgresql.conf

# - Connection Settings -
#listen_addresses = 'localhost'# what IP address(es) to listen on;
listen_addresses = '10.1.10.74'# what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost'; use '*' forall
                                        # (change requires restart)
#port = 5432                            # (change requires restart)

[root@sonarqube01 data]# pwd
/var/lib/pgsql/13/data
[root@sonarqube01 data]# vim pg_hba.conf

host    all             all             0.0.0.0/0               md5