redhat 9 安装zabbix server pgsql

安装zabbix server pgsql

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

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

安装rpm包

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

# fpinghttps://dl.fedoraproject.org/pub/epel/9/Everything/x86_64/Packages/f/fping-5.0-4.el9.x86_64.rpm## postgresqlhttps://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# zabbixhttps://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

执行下面的命令安装

服务器会自动完成安装

dnfinstall-y*.rpm

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

下面一行行执行

# 初始化数据库postgresql-15-setup initdb systemctlenable--nowpostgresql-15# 建库sudo-upostgres 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-upostgres psql-dzabbix# 授权sudo-upostgres psql-dzabbix-c"GRANT ALL ON ALL TABLES IN SCHEMA public TO zabbix;"sudo-upostgres psql-dzabbix-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 systemctlenable--nownginx systemctlenable--nowphp-fpm

开机自启动

systemctlenablezabbix-server systemctlenablenginx systemctlenablephp-fpm systemctlenablepostgresql-15

访问

http://你的服务器IP/ 账号：Admin 密码：zabbix

zabbix 程序升级

停止服务端

# 停服务端systemctl stop zabbix-server# 如需也停agent2systemctl stop zabbix-agent2

运行更新程序

dnf update zabbix*-y

启动服务器

systemctl start zabbix-server systemctl start zabbix-agent2