The net/zabbix,pgsql,-server port

zabbix-server-6.4.11-pgsql – network and application monitoring - server (cvsweb github mirror)


ZABBIX is an enterprise-class open source distributed monitoring
solution designed to monitor and track performance and availability of
network servers, devices and other IT resources. It supports distributed
and WEB monitoring, and more.

This package contains the ZABBIX server parts.

Available flavors:
	mysql - build with support for MySQL
	pgsql - build with support for PostgreSQL
	sqlite3 - build with support for SQLite3
WWW: http://www.zabbix.com/


| Running ${PKGSTEM} on OpenBSD

NOTE for users updating from version <1.8.6 using a node-based
distributed setup, see
for improving performance of configuration syncing.

The original documentation is available as a PDF file at

A manual is available at:

On OpenBSD, Zabbix is packaged in three parts:

- the agent (in the zabbix-agent package) for installing onto a
monitored machine. To simplify installation from ports on client
machines, only this part is built by default.

- the server and proxy (in the database-dependent zabbix-server
package); this has heavier dependencies and is built by selecting
the FLAVOR for the database you use (currently mysql, pgsql or sqlite3).

- the web interface to run with the server (in the zabbix-web package).

Before doing anything, you have to adapt the configuration files under
(make sure your webserver can resolve hostnames; otherwise use IP
addresses in the configuration files).

On OpenBSD, the default shared memory value is too low for the Zabbix
Server and Proxy to work properly. You should set kern.shminfo.shmall
according to your needs ("32768" is a good value for starter) -- see
sysctl(8) and sysctl.conf(5).

Next you must create the database following the relevant set of
instructions below. When this is done you can proceed to configure
through the web interface at http:///zabbix/setup.php.
(default user is 'Admin' with password 'zabbix')

MariaDB (InnoDB)

Connect to MariaDB, and create a user and database for Zabbix;

    $ mysql -u root -p
    MariaDB [(none)]> create user zabbix@localhost identified by 'password';
    MariaDB [(none)]> create database zabbix character set utf8;
    MariaDB [(none)]> grant all privileges on zabbix.* to zabbix@localhost;
    MariaDB [(none)]> quit

Then initialize the database from the files installed in

    $ cd ${TRUEPREFIX}/share/zabbix-server/schema/mysql
    $ mysql -uzabbix -p[password] zabbix < schema.sql
The following steps are not required for setting up a Zabbix Proxy.
    $ mysql -uzabbix -p[password] zabbix < images.sql
    $ mysql -uzabbix -p[password] zabbix < data.sql


Assuming you have an administrative account named `postgres',
you can create the 'zabbix' user and database like this:

    $ createuser -U postgres --pwprompt --no-superuser \
      --createdb --no-createrole zabbix
    $ createdb -U zabbix zabbix

And initialize the database:

    $ cd ${TRUEPREFIX}/share/zabbix-server/schema/postgresql
    $ cat schema.sql | psql -U zabbix zabbix
The following steps are not required for setting up a Zabbix Proxy.
    $ cat images.sql | psql -U zabbix zabbix
    $ cat data.sql | psql -U zabbix zabbix

When using PostgreSQL at least the following sysctl limits need to be set:



The following steps are optional on a Zabbix Proxy, the database will be
automatically created and initialized if it does not exist. Note that
for obvious performance reasons, it is NOT encouraged to use the SQLite
backend for a server.

    # cd ${TRUEPREFIX}/share/zabbix-server/schema/sqlite3
    # su -m _zabbix -c "sqlite3 /var/db/zabbix/zabbix.db < schema.sql"
The following steps are not required for setting up a Zabbix Proxy.
    # su -m _zabbix -c "sqlite3 /var/db/zabbix/zabbix.db < images.sql"
    # su -m _zabbix -c "sqlite3 /var/db/zabbix/zabbix.db < data.sql"


Robert Nagy


zabbix-agent-6.4.11 zabbix-web-6.4.11 zabbix-proxy-6.4.11-pgsql zabbix-server-6.4.11-pgsql

Only for arches

aarch64 alpha amd64 arm hppa i386 mips64 mips64el powerpc powerpc64 riscv64 sparc64


lang/php net

Library dependencies

Run dependencies