PostgreSQL11.4使用rpm安装

1.下载RPM包

下载地址: https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/

或者直接执行wget下载

wget https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7.2-x86_64/postgresql11-11.4-1PGDG.rhel7.x86_64.rpm
wget https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7.2-x86_64/postgresql11-libs-11.4-1PGDG.rhel7.x86_64.rpm
wget https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7.2-x86_64/postgresql11-server-11.4-1PGDG.rhel7.x86_64.rpm

2.安装

先安装相应依赖

yum install -y libicu systemd-sysv

安装rpm包，需要按照这个顺序安装，卸载就反序卸载

rpm -ivh postgresql11-libs-11.4-1PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql11-11.4-1PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql11-server-11.4-1PGDG.rhel7.x86_64.rpm

卸载

rpm -e postgresql11-server-11.4-1PGDG.rhel7.x86_64
rpm -e postgresql11-11.4-1PGDG.rhel7.x86_64
rpm -e postgresql11-libs-11.4-1PGDG.rhel7.x86_64

rm -rf /usr/pgsql-11/
rm -rf /var/lib/pgsql/

3.数据库初始化

/usr/pgsql-11/bin/postgresql-11-setup initdb
#Initializing database ... OK

4.启动

systemctl enable postgresql-11  #设置开机启动psql
systemctl start postgresql-11   #启动postgresql

5.查看状态

[root@7beccf3c3c2c pg11.4]# systemctl status postgresql-11
● postgresql-11.service - PostgreSQL 11 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2019-07-26 08:00:06 UTC; 11min ago
     Docs: https://www.postgresql.org/docs/11/static/
  Process: 390 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 395 (postmaster)
   CGroup: /system.slice/docker-7beccf3c3c2c90152d9c6eeb67fc2f4bdb854426e27e1e765a91011415f9650e.scope/system.slice/postgresql-11.service
           ├─395 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/
           ├─396 postgres: logger   
           ├─398 postgres: checkpointer   
           ├─399 postgres: background writer   
           ├─400 postgres: walwriter   
           ├─401 postgres: autovacuum launcher   
           ├─402 postgres: stats collector   
           └─403 postgres: logical replication launcher   

Jul 26 08:00:06 7beccf3c3c2c systemd[1]: Starting PostgreSQL 11 database server...
Jul 26 08:00:06 7beccf3c3c2c postmaster[395]: 2019-07-26 08:00:06.251 UTC [395] LOG:  listening on IPv6 address "::1", port 5432
Jul 26 08:00:06 7beccf3c3c2c postmaster[395]: 2019-07-26 08:00:06.251 UTC [395] LOG:  listening on IPv4 address "127.0.0.1", port 5432
Jul 26 08:00:06 7beccf3c3c2c postmaster[395]: 2019-07-26 08:00:06.253 UTC [395] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Jul 26 08:00:06 7beccf3c3c2c postmaster[395]: 2019-07-26 08:00:06.254 UTC [395] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
Jul 26 08:00:06 7beccf3c3c2c postmaster[395]: 2019-07-26 08:00:06.267 UTC [395] LOG:  redirecting log output to logging collector process
Jul 26 08:00:06 7beccf3c3c2c postmaster[395]: 2019-07-26 08:00:06.267 UTC [395] HINT:  Future log output will appear in directory "log".
Jul 26 08:00:06 7beccf3c3c2c systemd[1]: Started PostgreSQL 11 database server.