zabbix6.2.3系统数据库从Mysql迁移至PostgreSQL数据库（二）安装zabbix6.2.3及初始化zabbix数据库

在上一节我们已经完成PostgreSQL数据库的安装，本节继续进行zabbix6.2.3运行环境的搭建，本例数据库与zabbbix不在同一台服务器上。

1、收集zabbix服务程序所需rpm文件包

请到zabbix官网下载

Zabbix Official Repositoryhttps://repo.zabbix.com/zabbix/6.2/rhel/8/x86_64/以下文件：

zabbix-apache-conf-6.2.3-release1.el8.noarch.rpm
zabbix-selinux-policy-6.2.3-release1.el8.x86_64.rpm
zabbix-server-pgsql-6.2.3-release1.el8.x86_64.rpm
zabbix-sql-scripts-6.2.3-release1.el8.noarch.rpm
zabbix-web-6.2.3-release1.el8.noarch.rpm
zabbix-web-deps-6.2.3-release1.el8.noarch.rpm
zabbix-web-pgsql-6.2.3-release1.el8.noarch.rpm
打包上传至zabbix服务器

2、安装，执行：

dnf localinstall zabbix-server-pgsql-6.2.3-release1.el8.x86_64.rpm zabbix-web-pgsql-6.2.3-release1.el8.noarch.rpm zabbix-apache-conf-6.2.3-release1.el8.noarch.rpm zabbix-web-deps-6.2.3-release1.el8.noarch.rpm zabbix-sql-scripts-6.2.3-release1.el8.noarch.rpm zabbix-selinux-policy-6.2.3-release1.el8.x86_64.rpm zabbix-web-6.2.3-release1.el8.noarch.rpm  -y 

[root@localhost 6.2.3]# dnf localinstall zabbix-server-pgsql-6.2.3-release1.el8.x86_64.rpm zabbix-web-pgsql-6.2.3-release1.el8.noarch.rpm zabbix-apache-conf-6.2.3-release1.el8.noarch.rpm zabbix-web-deps-6.2.3-release1.el8.noarch.rpm zabbix-sql-scripts-6.2.3-release1.el8.noarch.rpm zabbix-selinux-policy-6.2.3-release1.el8.x86_64.rpm zabbix-web-6.2.3-release1.el8.noarch.rpm  -y    
上次元数据过期检查：0:38:42 前，执行于 2022年10月27日 星期四 10时44分26秒。
依赖关系解决。
=======================================================================================================================================
 软件包                            架构               版本                                              仓库                      大小
=======================================================================================================================================
安装:
 zabbix-apache-conf                noarch             6.2.3-release1.el8                                @commandline              23 k
 zabbix-selinux-policy             x86_64             6.2.3-release1.el8                                @commandline             290 k
 zabbix-server-pgsql               x86_64             6.2.3-release1.el8                                @commandline             1.7 M
 zabbix-sql-scripts                noarch             6.2.3-release1.el8                                @commandline             6.9 M
 zabbix-web                        noarch             6.2.3-release1.el8                                @commandline             8.1 M
 zabbix-web-deps                   noarch             6.2.3-release1.el8                                @commandline              23 k
 zabbix-web-pgsql                  noarch             6.2.3-release1.el8                                @commandline              22 k
安装依赖关系:
 libpq                             x86_64             13.3-1.el8_4                                      AppStream                197 k
 php-pgsql                         x86_64             7.2.24-1.module_el8.2.0+313+b04d0a66              AppStream                117 k

事务概要
=======================================================================================================================================
安装  9 软件包

总计：17 M
总下载：315 k
安装大小：54 M
下载软件包：
(1/2): php-pgsql-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64.rpm                                       1.7 MB/s | 117 kB     00:00    
(2/2): libpq-13.3-1.el8_4.x86_64.rpm                                                                   2.5 MB/s | 197 kB     00:00    
---------------------------------------------------------------------------------------------------------------------------------------
总计                                                                                                   3.9 MB/s | 315 kB     00:00     
...                                                                            9/9 

已安装:
  libpq-13.3-1.el8_4.x86_64                                      php-pgsql-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64                 
  zabbix-apache-conf-6.2.3-release1.el8.noarch                   zabbix-selinux-policy-6.2.3-release1.el8.x86_64                       
  zabbix-server-pgsql-6.2.3-release1.el8.x86_64                  zabbix-sql-scripts-6.2.3-release1.el8.noarch                          
  zabbix-web-6.2.3-release1.el8.noarch                           zabbix-web-deps-6.2.3-release1.el8.noarch                             
  zabbix-web-pgsql-6.2.3-release1.el8.noarch                    

完毕！

[root@localhost 6.2.3]# rpm -qa|grep zabbix
zabbix-apache-conf-6.2.3-release1.el8.noarch
zabbix-web-pgsql-6.2.3-release1.el8.noarch
zabbix-server-pgsql-6.2.3-release1.el8.x86_64
zabbix-sql-scripts-6.2.3-release1.el8.noarch
zabbix-agent-6.2.1-1.el8.x86_64
zabbix-web-deps-6.2.3-release1.el8.noarch
zabbix-selinux-policy-6.2.3-release1.el8.x86_64
zabbix-web-6.2.3-release1.el8.noarch

3、在postgresql服务器上创建zabbix库及用户：

[root@localhost postgresqlrpm]# su - postgres
上一次登录：四 10月 27 10:24:40 CST 2022pts/0 上
[postgres@localhost ~]$ createuser --pwprompt zabbix
Enter password for new role: 
Enter it again: 
[postgres@localhost ~]$ createdb -O zabbix -E Unicode -T template0 zabbix
[postgres@localhost ~]$ exit
[root@localhost postgresqlrpm]# psql -U postgres -h localhost
psql (14.5)
输入 "help" 来获取帮助信息.

postgres=# \dx
                                            已安装扩展列表
    名称     | 版本  |  架构模式  |                               描述                                
-------------+-------+------------+-------------------------------------------------------------------
 plpgsql     | 1.0   | pg_catalog | PL/pgSQL procedural language
 timescaledb | 2.7.0 | public     | Enables scalable inserts and complex queries for time-series data
(2 行记录)

postgres=# select version();
                                                 version                                                 
---------------------------------------------------------------------------------------------------------
 PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit
(1 行记录)

postgres=# select * from pg_authid;
  oid  |          rolname          | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolbypassrls 
| rolconnlimit |                                                              rolpassword                                              
...                                                                                                                  
                | 
    10 | postgres                  | t        | t          | t             | t           ...
 16989 | zabbix                    | f        | t          | f             | f           ...
(13 行记录)

postgres=# select * from pg_database;
  oid  |  datname  | datdba | encoding | datcollate  |  datctype   | datistemplate | datallowconn | datconnlimit | datlastsysoid | datf
rozenxid | datminmxid | dattablespace |               datacl                
-------+-----------+--------+----------+-------------+-------------+---------------+--------------+--------------+---------------+-----
---------+------------+---------------+-------------------------------------
 13707 | postgres  |     10 |        6 | zh_CN.UTF-8 | zh_CN.UTF-8 | f             | t            |           -1 |         13706 |     
     726 |          1 |          1663 | 
 16990 | zabbix    |  16989 |        6 | zh_CN.UTF-8 | zh_CN.UTF-8 | f             |