签到成功

知道了

CNDBA社区CNDBA社区

PostgreSQL 学习笔记（3） -- PG 单实例安装手册

2022-12-05 21:58 1950 0 原创 PostgreSQL
作者： dave
本文链接：https://www.cndba.cn/dave/article/116374

在之前的博客，我们了解的PG的相关概念和版本信息，如下：https://www.cndba.cn/dave/article/116374

PostgreSQL 学习笔记（1） — PG 概述
https://www.cndba.cn/dave/article/116370https://www.cndba.cn/dave/article/116374

PostgreSQL 学习笔记（2） — PG 版本发布策略 和 生命周期说明
https://www.cndba.cn/dave/article/116372

本片来看下PG 单实例的安装。

1 使用YUM 安装

在可以联网的情况下使用yum 源直接安装是最建的的，官网链接如下：

https://www.postgresql.org/download/linux/redhat/https://www.cndba.cn/dave/article/116374

我们这里以Redhat 7.9 平台，14.6 为例进行说明。 

[dave@www.cndba.cn ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)
[dave@www.cndba.cn ~]#

1.1 安装YUM 源

官方手册是一步到位，我这里测试报错，所有先wget 下载后在安装：

[dave@www.cndba.cn yum.repos.d]# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Cannot open: https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm. Skipping.
Error: Nothing to do
[dave@www.cndba.cn yum.repos.d]#

[dave@www.cndba.cn yum.repos.d]# wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm --no-check-certificate
--2022-09-10 01:51:41--  https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Resolving download.postgresql.org (download.postgresql.org)... 87.238.57.227, 147.75.85.69, 72.32.157.246, ...
Connecting to download.postgresql.org (download.postgresql.org)|87.238.57.227|:443... connected.
WARNING: cannot verify download.postgresql.org's certificate, issued by ‘/C=US/O=Let's Encrypt/CN=R3’:
  Issued certificate has expired.
HTTP request sent, awaiting response... 200 OK
Length: 8808 (8.6K) [application/x-redhat-package-manager]
Saving to: ‘pgdg-redhat-repo-latest.noarch.rpm’

100%[=================================================================================================>] 8,808       --.-K/s   in 0s

2022-09-10 01:51:42 (254 MB/s) - ‘pgdg-redhat-repo-latest.noarch.rpm’ saved [8808/8808]

[dave@www.cndba.cn yum.repos.d]# ll
total 20
-rw-r--r--. 1 root root   59 Sep  7 11:36 dave.repo
-rw-r--r--. 1 root root 8808 Oct 18  2022 pgdg-redhat-repo-latest.noarch.rpm
-rw-r--r--. 1 root root  358 Jun 29 11:15 redhat.repo
[dave@www.cndba.cn yum.repos.d]# yum install -y pgdg-redhat-repo-latest.noarch.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Examining pgdg-redhat-repo-latest.noarch.rpm: pgdg-redhat-repo-42.0-28.noarch
Marking pgdg-redhat-repo-latest.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-redhat-repo.noarch 0:42.0-28 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

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

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

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

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

Complete!
[dave@www.cndba.cn yum.repos.d]#

1.2 安装PG

这里要注意系统时间要同步，否则会报如下错误：

https://www.cndba.cn/dave/article/116374

Linux YUM Peer’s Certificate has expired 错误解决方法
https://www.cndba.cn/dave/article/116373

[dave@www.cndba.cn yum.repos.d]# yum install -y postgresql14-server
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

dave                                                                                                                | 2.8 kB  00:00:00
pgdg-common/7Server/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 <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg-common/7Server/x86_64/signature                                                                                | 2.9 kB  00:00:00 !!!
pgdg10/7Server/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 <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg10/7Server/x86_64/signature                                                                                     | 3.6 kB  00:00:00 !!!
pgdg11/7Server/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 <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg11/7Server/x86_64/signature                                                                                     | 3.6 kB  00:00:00 !!!
pgdg12/7Server/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 <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg12/7Server/x86_64/signature                                                                                     | 3.6 kB  00:00:00 !!!
pgdg13/7Server/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 <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg13/7Server/x86_64/signature                                                                                     | 3.6 kB  00:00:00 !!!
pgdg14/7Server/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 <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg14/7Server/x86_64/signature                                                                                     | 3.6 kB  00:00:00 !!!
pgdg15/7Server/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 <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
pgdg15/7Server/x86_64/signature                                                                                     | 3.6 kB  00:00:00 !!!
(1/13): pgdg11/7Server/x86_64/group_gz                                                                              |  245 B  00:00:01
(2/13): pgdg12/7Server/x86_64/group_gz                                                                              |  245 B  00:00:00
(3/13): pgdg10/7Server/x86_64/group_gz                                                                              |  245 B  00:00:01
(4/13): pgdg-common/7Server/x86_64/primary_db                                                                       | 165 kB  00:00:01
(5/13): pgdg13/7Server/x86_64/group_gz                                                                              |  246 B  00:00:00
(6/13): pgdg14/7Server/x86_64/group_gz                                                                              |  244 B  00:00:00
(7/13): pgdg13/7Server/x86_64/primary_db                                                                            | 245 kB  00:00:00
(8/13): pgdg10/7Server/x86_64/primary_db                                                                            | 400 kB  00:00:02
(9/13): pgdg15/7Server/x86_64/group_gz                                                                              |  246 B  00:00:00
(10/13): pgdg15/7Server/x86_64/primary_db                                                                           |  70 kB  00:00:00
(11/13): pgdg12/7Server/x86_64/primary_db                                                                           | 339 kB  00:00:01
(12/13): pgdg11/7Server/x86_64/primary_db                                                                           | 453 kB  00:00:03
(13/13): pgdg14/7Server/x86_64/primary_db                                                                           | 159 kB  00:00:01
Resolving Dependencies
--> Running transaction check
---> Package postgresql14-server.x86_64 0:14.6-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql14-libs(x86-64) = 14.6-1PGDG.rhel7 for package: postgresql14-server-14.6-1PGDG.rhel7.x86_64
--> Processing Dependency: postgresql14(x86-64) = 14.6-1PGDG.rhel7 for package: postgresql14-server-14.6-1PGDG.rhel7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: postgresql14-server-14.6-1PGDG.rhel7.x86_64
--> Running transaction check
---> Package postgresql14.x86_64 0:14.6-1PGDG.rhel7 will be installed
---> Package postgresql14-libs.x86_64 0:14.6-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

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

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

Total download size: 7.2 M
Installed size: 31 M
Downloading packages:
warning: /var/cache/yum/x86_64/7Server/pgdg14/packages/postgresql14-libs-14.6-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Public key for postgresql14-libs-14.6-1PGDG.rhel7.x86_64.rpm is not installed
(1/3): postgresql14-libs-14.6-1PGDG.rhel7.x86_64.rpm                                                                | 269 kB  00:00:03
(2/3): postgresql14-14.6-1PGDG.rhel7.x86_64.rpm                                                                     | 1.5 MB  00:00:03
(3/3): postgresql14-server-14.6-1PGDG.rhel7.x86_64.rpm                                                              | 5.5 MB  00:02:01
-------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                       59 kB/s | 7.2 MB  00:02:05
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-28.noarch (@/pgdg-redhat-repo-latest.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql14-libs-14.6-1PGDG.rhel7.x86_64                                                                               1/3
  Installing : postgresql14-14.6-1PGDG.rhel7.x86_64                                                                                    2/3
  Installing : postgresql14-server-14.6-1PGDG.rhel7.x86_64                                                                             3/3
  Verifying  : postgresql14-libs-14.6-1PGDG.rhel7.x86_64                                                                               1/3
  Verifying  : postgresql14-server-14.6-1PGDG.rhel7.x86_64                                                                             2/3
  Verifying  : postgresql14-14.6-1PGDG.rhel7.x86_64                                                                                    3/3

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

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

Complete!
[dave@www.cndba.cn yum.repos.d]#

1.3 初始化数据库

[dave@www.cndba.cn yum.repos.d]# /usr/pgsql-14/bin/postgresql-14-setup initdb
Initializing database ... OK

[dave@www.cndba.cn yum.repos.d]# 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.
[dave@www.cndba.cn yum.repos.d]# systemctl start postgresql-14
[dave@www.cndba.cn yum.repos.d]#
[dave@www.cndba.cn yum.repos.d]#
[dave@www.cndba.cn yum.repos.d]#

1.4 登陆验证

[dave@www.cndba.cn yum.repos.d]# su - postgres
-bash-4.2$ psql
psql (14.6)
Type "help" for help.

postgres=# /l
                                  List of databases
   Name   
|  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(3 rows)

postgres=#

2 离线RPM安装

2.1 下载RPM 包

在外网不同的情况下，只能离线安装，从官网下载rpm包：

https://www.cndba.cn/dave/article/116374
https://www.cndba.cn/dave/article/116374

https://yum.postgresql.org/14/redhat/rhel-7-x86_64/repoview/

我们下载的是14.6 的包，如下：https://www.cndba.cn/dave/article/116374

[dave@www.cndba.cn software]# ll
total 8116
-rw-r--r--. 1 root root 1567924 Aug  8 09:25 postgresql14-14.6-1PGDG.rhel7.x86_64.rpm
-rw-r--r--. 1 root root  702604 Aug  8 09:25 postgresql14-contrib-14.6-1PGDG.rhel7.x86_64.rpm
-rw-r--r--. 1 root root  275596 Aug  8 09:25 postgresql14-libs-14.6-1PGDG.rhel7.x86_64.rpm
-rw-r--r--. 1 root root 5757176 Aug  8 09:25 postgresql14-server-14.6-1PGDG.rhel7.x86_64.rpm
[dave@www.cndba.cn software]#

2.2 安装RPM 包

因为这里涉及到依赖包的问题，所以直接使用YUM 命令来安装RPM, 注意安装顺序也不能换：

https://www.cndba.cn/dave/article/116374 

[dave@www.cndba.cn software]# yum install postgresql14-libs-14.6-1PGDG.rhel7.x86_64.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Examining postgresql14-libs-14.6-1PGDG.rhel7.x86_64.rpm: postgresql14-libs-14.6-1PGDG.rhel7.x86_64
Marking postgresql14-libs-14.6-1PGDG.rhel7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package postgresql14-libs.x86_64 0:14.6-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution
dave                                                                                                                | 2.8 kB  00:00:00
dave/group                                                                                                          | 628 kB  00:00:00
dave/primary                                                                                                        | 2.1 MB  00:00:00

Dependencies Resolved

===========================================================================================================================================
 Package                      Arch              Version                        Repository                                             Size
===========================================================================================================================================
Installing:
 postgresql14-libs            x86_64            14.6-1PGDG.rhel7               /postgresql14-libs-14.6-1PGDG.rhel7.x86_64            923 k

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

Total size: 923 k
Installed size: 923 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql14-libs-14.6-1PGDG.rhel7.x86_64                                                                               1/1
  Verifying  : postgresql14-libs-14.6-1PGDG.rhel7.x86_64                                                                               1/1

Installed:
  postgresql14-libs.x86_64 0:14.6-1PGDG.rhel7

Complete!

[dave@www.cndba.cn software]# yum install postgresql14-14.6-1PGDG.rhel7.x86_64.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Examining postgresql14-14.6-1PGDG.rhel7.x86_64.rpm: postgresql14-14.6-1PGDG.rhel7.x86_64
Marking postgresql14-14.6-1PGDG.rhel7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package postgresql14.x86_64 0:14.6-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================
 Package                    Arch                 Version                         Repository                                           Size
===========================================================================================================================================
Installing:
 postgresql14               x86_64               14.6-1PGDG.rhel7                /postgresql14-14.6-1PGDG.rhel7.x86_64               7.9 M

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

Total size: 7.9 M
Installed size: 7.9 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql14-14.6-1PGDG.rhel7.x86_64                                                                                    1/1
  Verifying  : postgresql14-14.6-1PGDG.rhel7.x86_64                                                                                    1/1

Installed:
  postgresql14.x86_64 0:14.6-1PGDG.rhel7

Complete!
[dave@www.cndba.cn software]# yum install postgresql14-server-14.6-1PGDG.rhel7.x86_64.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Examining postgresql14-server-14.6-1PGDG.rhel7.x86_64.rpm: postgresql14-server-14.6-1PGDG.rhel7.x86_64
Marking postgresql14-server-14.6-1PGDG.rhel7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package postgresql14-server.x86_64 0:14.6-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================
 Package                       Arch             Version                       Repository                                              Size
===========================================================================================================================================
Installing:
 postgresql14-server           x86_64           14.6-1PGDG.rhel7              /postgresql14-server-14.6-1PGDG.rhel7.x86_64            22 M

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

Total size: 22 M
Installed size: 22 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql14-server-14.6-1PGDG.rhel7.x86_64                                                                             1/1
  Verifying  : postgresql14-server-14.6-1PGDG.rhel7.x86_64                                                                             1/1

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

Complete!
[dave@www.cndba.cn software]# yum install postgresql14-contrib-14.6-1PGDG.rhel7.x86_64.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Examining postgresql14-contrib-14.6-1PGDG.rhel7.x86_64.rpm: postgresql14-contrib-14.6-1PGDG.rhel7.x86_64
Marking postgresql14-contrib-14.6-1PGDG.rhel7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package postgresql14-contrib.x86_64 0:14.6-1PGDG.rhel7 will be installed
--> Processing Dependency: libpython3.6m.so.1.0()(64bit) for package: postgresql14-contrib-14.6-1PGDG.rhel7.x86_64
--> Running transaction check
---> Package python3-libs.x86_64 0:3.6.8-17.el7 will be installed
--> Processing Dependency: python(abi) = 3.6 for package: python3-libs-3.6.8-17.el7.x86_64
--> Running transaction check
---> Package python3.x86_64 0:3.6.8-17.el7 will be installed
--> Processing Dependency: python3-setuptools for package: python3-3.6.8-17.el7.x86_64
--> Processing Dependency: python3-pip for package: python3-3.6.8-17.el7.x86_64
--> Running transaction check
---> Package python3-pip.noarch 0:9.0.3-8.el7 will be installed
---> Package python3-setuptools.noarch 0:39.2.0-10.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================
 Package                        Arch             Version                     Repository                                               Size
===========================================================================================================================================
Installing:
 postgresql14-contrib           x86_64           14.6-1PGDG.rhel7            /postgresql14-contrib-14.6-1PGDG.rhel7.x86_64           2.4 M
Installing for dependencies:
 python3                        x86_64           3.6.8-17.el7                dave                                                     70 k
 python3-libs                   x86_64           3.6.8-17.el7                dave                                                    6.9 M
 python3-pip                    noarch           9.0.3-8.el7                 dave                                                    1.6 M
 python3-setuptools             noarch           39.2.0-10.el7               dave                                                    629 k

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

Total size: 12 M
Total download size: 9.3 M
Installed size: 50 M
Is this ok [y/d/N]: y
Downloading packages:
-------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                      8.0 MB/s | 9.3 MB  00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : python3-libs-3.6.8-17.el7.x86_64                                                                                        1/5
  Installing : python3-pip-9.0.3-8.el7.noarch                                                                                          2/5
  Installing : python3-setuptools-39.2.0-10.el7.noarch                                                                                 3/5
  Installing : python3-3.6.8-17.el7.x86_64                                                                                             4/5
  Installing : postgresql14-contrib-14.6-1PGDG.rhel7.x86_64                                                                            5/5
  Verifying  : python3-3.6.8-17.el7.x86_64                                                                                             1/5
  Verifying  : python3-pip-9.0.3-8.el7.noarch                                                                                          2/5
  Verifying  : python3-libs-3.6.8-17.el7.x86_64                                                                                        3/5
  Verifying  : python3-setuptools-39.2.0-10.el7.noarch                                                                                 4/5
  Verifying  : postgresql14-contrib-14.6-1PGDG.rhel7.x86_64                                                                            5/5

Installed:
  postgresql14-contrib.x86_64 0:14.6-1PGDG.rhel7

Dependency Installed:
  python3.x86_64 0:3.6.8-17.el7                      python3-libs.x86_64 0:3.6.8-17.el7          python3-pip.noarch 0:9.0.3-8.el7
  python3-setuptools.noarch 0:39.2.0-10.el7

Complete!
[dave@www.cndba.cn software]#

2.3 初始化数据库

默认安装在如下路径：

https://www.cndba.cn/dave/article/116374 

[dave@www.cndba.cn pgsql-14]# ll
total 16
drwxr-xr-x. 2 root root 4096 Aug  8 09:41 bin
drwxr-xr-x. 3 root root   23 Aug  8 09:41 doc
drwxr-xr-x. 3 root root 4096 Aug  8 09:41 lib
drwxr-xr-x. 8 root root 4096 Aug  8 09:41 share
[dave@www.cndba.cn pgsql-14]#

初始化DB:https://www.cndba.cn/dave/article/116374

[dave@www.cndba.cn pgsql-14]# /usr/pgsql-14/bin/postgresql-14-setup initdb
Initializing database ... OK

[dave@www.cndba.cn pgsql-14]# systemctl enable postgresql-14.service
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-14.service to /usr/lib/systemd/system/postgresql-14.service.
[dave@www.cndba.cn pgsql-14]# systemctl start postgresql-14.service
[dave@www.cndba.cn pgsql-14]#

2.4 登陆验证

[dave@www.cndba.cn pgsql-14]# su - postgres
-bash-4.2$ psql
psql (14.6)
Type "help" for help.

postgres=# /l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(3 rows)

postgres=#

版权声明：本文为博主原创文章，未经博主允许不得转载。

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
dave

dave

关注

人的一生应该是这样度过的：当他回首往事的时候，他不会因为虚度年华而悔恨，也不会因为碌碌无为而羞耻；这样，在临死的时候，他就能够说：“我的整个生命和全部精力，都已经献给世界上最壮丽的事业....."

  • 2262
    原创
  • 3
    翻译
  • 578
    转载
  • 192
    评论
  • 访问：8080891次
  • 积分：4349
  • 等级：核心会员
  • 排名：第1名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ