PostgreSql14.2 部署

1. postgresql 官网关于需要安装的包和依赖：

来源：https://yum.postgresql.org/14/redhat/rhel-7-x86_64/repoview/postgresqldbserver14.group.html

 2. 四个包都下载下来：

3. 进行PostgresSQL的安装

[root@db-postgresql13 home]# rpm -ivh postgresql14-*

4. 初始化db

[root@db-postgresql13 home]# /usr/pgsql-13/bin/postgresql-13-setup initdb
Initializing database ... OK

5. 启动PostgreSQL服务

[root@db-postgresql13 home]# systemctl start postgresql-13

# 查看服务状态

[root@db-postgresql13 ~]# systemctl status postgresql-13

6. 进入PostgreSQL数据库

[root@db-postgresql13 ~]# su - postgres

Last login: Tue Jun 22 11:13:17 CST 2021 on pts/1

# 查看postgresql版本
-bash-4.2$ psql --version
psql (PostgreSQL) 13.3

# 进入数据库
-bash-4.2$ psql
psql (13.3)
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=#