【Linux操作记录】PostgreSQL安装记录，直接复制命令即可安装

[root@dev02 ~]# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Loaded plugins: fastestmirror, langpacks
pgdg-redhat-repo-latest.noarch.rpm                                                                                                           | 7.7 kB  00:00:00     
Examining /var/tmp/yum-root-JETut8/pgdg-redhat-repo-latest.noarch.rpm: pgdg-redhat-repo-42.0-20.noarch
Marking /var/tmp/yum-root-JETut8/pgdg-redhat-repo-latest.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-redhat-repo.noarch 0:42.0-20 will be installed
--> Finished Dependency Resolution
base/7/x86_64                                                                                                                                | 3.6 kB  00:00:00     
extras/7/x86_64                                                                                                                              | 2.9 kB  00:00:00     
mysql-connectors-community/x86_64                                                                                                            | 2.6 kB  00:00:00     
mysql-tools-community/x86_64                                                                                                                 | 2.6 kB  00:00:00     
mysql80-community/x86_64                                                                                                                     | 2.6 kB  00:00:00     
updates/7/x86_64                                                                                                                             | 2.9 kB  00:00:00     

Dependencies Resolved

====================================================================================================================================================================
 Package                                 Arch                          Version                         Repository                                              Size
====================================================================================================================================================================
Installing:
 pgdg-redhat-repo                        noarch                        42.0-20                         /pgdg-redhat-repo-latest.noarch                         11 k

Transaction Summary
====================================================================================================================================================================
Install  1 Package

Total size: 11 k
Installed size: 11 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : pgdg-redhat-repo-42.0-20.noarch                                                                                                                  1/1 
  Verifying  : pgdg-redhat-repo-42.0-20.noarch                                                                                                                  1/1 

Installed:
  pgdg-redhat-repo.noarch 0:42.0-20                                                                                                                                 

Complete!
[root@dev02 ~]# yum install -y postgresql14-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirrors.ustc.edu.cn
 * extras: ftp.sjtu.edu.cn
 * updates: ftp.sjtu.edu.cn
pgdg-common/7/x86_64/signature                                                                                                               |  198 B  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg-common/7/x86_64/signature                                                                                                               | 2.9 kB  00:00:00 !!! 
pgdg10/7/x86_64/signature                                                                                                                    |  198 B  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg10/7/x86_64/signature                                                                                                                    | 3.6 kB  00:00:00 !!! 
pgdg11/7/x86_64/signature                                                                                                                    |  198 B  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg11/7/x86_64/signature                                                                                                                    | 3.6 kB  00:00:00 !!! 
pgdg12/7/x86_64/signature                                                                                                                    |  198 B  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg12/7/x86_64/signature                                                                                                                    | 3.6 kB  00:00:00 !!! 
pgdg13/7/x86_64/signature                                                                                                                    |  198 B  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg13/7/x86_64/signature                                                                                                                    | 3.6 kB  00:00:00 !!! 
pgdg14/7/x86_64/signature                                                                                                                    |  198 B  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg14/7/x86_64/signature                                                                                                                    | 3.6 kB  00:00:00 !!! 
pgdg96/7/x86_64/signature                                                                                                                    |  198 B  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg96/7/x86_64/signature                                                                                                                    | 3.6 kB  00:00:00 !!! 
(1/13): pgdg10/7/x86_64/group_gz                                                                                                             |  245 B  00:00:01     
(2/13): pgdg12/7/x86_64/group_gz                                                                                                             |  245 B  00:00:00     
(3/13): pgdg11/7/x86_64/group_gz                                                                                                             |  245 B  00:00:01     
(4/13): pgdg13/7/x86_64/group_gz                                                                                                             |  246 B  00:00:00     
(5/13): pgdg-common/7/x86_64/primary_db                                                                                                      | 147 kB  00:00:02     
(6/13): pgdg14/7/x86_64/group_gz                                                                                                             |  244 B  00:00:00     
(7/13): pgdg12/7/x86_64/primary_db                                                                                                           | 229 kB  00:00:01     
(8/13): pgdg10/7/x86_64/primary_db                                                                                                           | 350 kB  00:00:03     
(9/13): pgdg11/7/x86_64/primary_db                                                                                                           | 376 kB  00:00:03     
(10/13): pgdg13/7/x86_64/primary_db                                                                                                          | 149 kB  00:00:01     
(11/13): pgdg96/7/x86_64/group_gz                                                                                                            |  249 B  00:00:00     
(12/13): pgdg14/7/x86_64/primary_db                                                                                                          |  64 kB  00:00:00     
(13/13): pgdg96/7/x86_64/primary_db                                                                                                          | 337 kB  00:00:01     
Resolving Dependencies
--> Running transaction check
---> Package postgresql14-server.x86_64 0:14.0-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql14-libs(x86-64) = 14.0-1PGDG.rhel7 for package: postgresql14-server-14.0-1PGDG.rhel7.x86_64
--> Processing Dependency: postgresql14(x86-64) = 14.0-1PGDG.rhel7 for package: postgresql14-server-14.0-1PGDG.rhel7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: postgresql14-server-14.0-1PGDG.rhel7.x86_64
--> Running transaction check
---> Package postgresql14.x86_64 0:14.0-1PGDG.rhel7 will be installed
---> Package postgresql14-libs.x86_64 0:14.0-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================
 Package                                       Arch                             Version                                      Repository                        Size
====================================================================================================================================================================
Installing:
 postgresql14-server                           x86_64                           14.0-1PGDG.rhel7                             pgdg14                           5.5 M
Installing for dependencies:
 postgresql14                                  x86_64                           14.0-1PGDG.rhel7                             pgdg14                           1.5 M
 postgresql14-libs                             x86_64                           14.0-1PGDG.rhel7                             pgdg14                           265 k

Transaction Summary
====================================================================================================================================================================
Install  1 Package (+2 Dependent packages)

Total download size: 7.3 M
Installed size: 31 M
Downloading packages:
warning: /var/cache/yum/x86_64/7/pgdg14/packages/postgresql14-libs-14.0-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEYB  00:00:45 ETA 
Public key for postgresql14-libs-14.0-1PGDG.rhel7.x86_64.rpm is not installed
(1/3): postgresql14-libs-14.0-1PGDG.rhel7.x86_64.rpm                                                                                         | 265 kB  00:00:03     
(2/3): postgresql14-14.0-1PGDG.rhel7.x86_64.rpm                                                                                              | 1.5 MB  00:00:07     
(3/3): postgresql14-server-14.0-1PGDG.rhel7.x86_64.rpm                                                                                       | 5.5 MB  00:00:09     
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                               574 kB/s | 7.3 MB  00:00:12     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project "
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql14-libs-14.0-1PGDG.rhel7.x86_64                                                                                                        1/3 
  Installing : postgresql14-14.0-1PGDG.rhel7.x86_64                                                                                                             2/3 
  Installing : postgresql14-server-14.0-1PGDG.rhel7.x86_64                                                                                                      3/3 
  Verifying  : postgresql14-server-14.0-1PGDG.rhel7.x86_64                                                                                                      1/3 
  Verifying  : postgresql14-14.0-1PGDG.rhel7.x86_64                                                                                                             2/3 
  Verifying  : postgresql14-libs-14.0-1PGDG.rhel7.x86_64                                                                                                        3/3 

Installed:
  postgresql14-server.x86_64 0:14.0-1PGDG.rhel7                                                                                                                     

Dependency Installed:
  postgresql14.x86_64 0:14.0-1PGDG.rhel7                                         postgresql14-libs.x86_64 0:14.0-1PGDG.rhel7                                        

Complete!
[root@dev02 ~]# /usr/pgsql-14/bin/postgresql-14-setup initdb
Initializing database ... OK

[root@dev02 ~]# systemctl enable postgresql-14
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-14.service to /usr/lib/systemd/system/postgresql-14.service.
[root@dev02 ~]# systemctl start postgresql-14
[root@dev02 ~]# systemctl status postgresql-14
● postgresql-14.service - PostgreSQL 14 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-14.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-10-28 09:03:27 CST; 9s ago
     Docs: https://www.postgresql.org/docs/14/static/
  Process: 8007 ExecStartPre=/usr/pgsql-14/bin/postgresql-14-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 8014 (postmaster)
    Tasks: 8
   CGroup: /system.slice/postgresql-14.service
           ├─8014 /usr/pgsql-14/bin/postmaster -D /var/lib/pgsql/14/data/
           ├─8016 postgres: logger 
           ├─8018 postgres: checkpointer 
           ├─8019 postgres: background writer 
           ├─8020 postgres: walwriter 
           ├─8021 postgres: autovacuum launcher 
           ├─8022 postgres: stats collector 
           └─8023 postgres: logical replication launcher 

Oct 28 09:03:27 dev02 systemd[1]: Starting PostgreSQL 14 database server...
Oct 28 09:03:27 dev02 postmaster[8014]: 2021-10-28 09:03:27.694 CST [8014] LOG:  redirecting log output to logging collector process
Oct 28 09:03:27 dev02 postmaster[8014]: 2021-10-28 09:03:27.694 CST [8014] HINT:  Future log output will appear in directory "log".
Oct 28 09:03:27 dev02 systemd[1]: Started PostgreSQL 14 database server.
[root@dev02 ~]#
【Linux操作记录】PostgreSQL安装记录，直接复制命令即可安装

Linux相关栏目本月热门文章
