This wiki is outdated and will be removed on 2015.03.01. Do not rely on this information. Move any useful information to the Zabbix community wiki at
ODT Export

Configuring PostgreSQL for use by Zabbix

Setting up a local user account for zabbix in the database meant adding this line to /var/lib/pgsql/data/pg_hba.conf:

local   zabbix      zabbix                            md5

Also this psql command to create the user and database – initially you will probably need to do this as the postgres user.

CREATE USER zabbix WITH PASSWORD 'zzzzzzzzzz';

Then, as root or any other user, I can create the tables, etc, as described in the zabbix installation guide:

cd create/schema 
cat postgresql.sql | psql -U zabbix zabbix 
cd ../data 
cat images_postgresql.sql | psql -U zabbix zabbix
cat data.sql | psql -U zabbix zabbix
howto/db/postgres.txt · Last modified: 2011/08/30 06:44 by delatbabel
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki