安装zabbix server pgsql

先安装zabbixs server 所需的红帽依赖包

  dnf install -y --downloadonly --downloaddir=/home/offline-zabbix7-pg15 nginx php-fpm php-cli

安装rpm包

下载下列的rpm包：zabbix-server pgsql fping

# fping
    https://dl.fedoraproject.org/pub/epel/9/Everything/x86_64/Packages/f/fping-5.0-4.el9.x86_64.rpm
## postgresql
    https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-9-x86_64/postgresql15-15.7-1PGDG.rhel9.x86_64.rpm
    https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-9-x86_64/postgresql15-contrib-15.7-1PGDG.rhel9.x86_64.rpm
    https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-9-x86_64/postgresql15-libs-15.7-1PGDG.rhel9.x86_64.rpm
    https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-9-x86_64/postgresql15-server-15.7-1PGDG.rhel9.x86_64.rpm

# zabbix
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-release-latest-7.0.el9.noarch.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-web-pgsql-7.0.26-release1.el9.noarch.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix_agent2-7.0.26-windows-amd64-openssl.msi
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-agent2-7.0.26-release1.el9.x86_64.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-nginx-conf-7.0.26-release1.el9.noarch.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-selinux-policy-7.0.26-release1.el9.x86_64.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-server-pgsql-7.0.26-release1.el9.x86_64.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-sql-scripts-7.0.26-release1.el9.noarch.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-web-7.0.26-release1.el9.noarch.rpm
    https://repo.zabbix.com/zabbix/7.0/rhel/9/x86_64/zabbix-web-deps-7.0.26-release1.el9.noarch.rpm

将刚刚下载的rpm包上传到服务器/home/offline-zabbix7-pg15

执行下面的命令安装

服务器会自动完成安装

dnf install -y *.rpm 

安装数据库,zabbix-server数据初始化

下面一行行执行

# 初始化数据库
postgresql-15-setup initdb
systemctl enable --now postgresql-15

# 建库
sudo -u postgres psql
create database zabbix;
create user zabbix with password 'zabbix';
grant all privileges on database zabbix to zabbix;
\q

# 导入zabbix初始化数据
zcat /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz | sudo -u postgres psql -d zabbix

# 授权
sudo -u postgres psql -d zabbix -c "GRANT ALL ON ALL TABLES IN SCHEMA public TO zabbix;"
sudo -u postgres psql -d zabbix -c "GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO zabbix;"

设置数据库本地密码加密方式

vi /var/lib/pgsql/15/data/pg_hba.conf

把 local all all peer 改成local all all trust

重启数据库：systemctl restart postgresql-15

设置zabbixs数据库连接

vi /etc/zabbix/zabbix_server.conf
确保下面的配置

DBName=zabbix
DBUser=zabbix
DBPassword=zabbix

启动服务端

systemctl start zabbix-server
systemctl enable --now nginx
systemctl enable --now php-fpm

开机自启动

systemctl enable zabbix-server
systemctl enable nginx
systemctl enable php-fpm
systemctl enable postgresql-15

访问

http://你的服务器IP/

账号：Admin
密码：zabbix

zabbix 程序升级

停止服务端

#  停服务端
systemctl stop zabbix-server

# 如需也停agent2
systemctl stop zabbix-agent2

运行更新程序

dnf update zabbix* -y

启动服务器

systemctl start zabbix-server
systemctl start zabbix-agent2