Zabbix 3.0 installation and postgres

[Ronald]

Hi,

I was curious about the new zabbix version, during the installation i found out the installation manual was not entirely correct.
The package files are installed from repo.zabbix.com.
Database postgres
Centos 7
I found out there is a schema /usr/share/doc/zabbix-server-pgsql-3.0.0/create.sql.gz
Gunzip the file and import create.sql in the zabbix database.

The installation manual is not correct as this point.

PostgreSQL

We assume that a username user exists and has permissions to create database objects.

shell> psql -U <username>
psql> create database zabbix;
psql> \q
shell> cd database/postgresql
shell> psql -U <username> zabbix < schema.sql
# stop here if you are creating database for Zabbix proxy
shell> psql -U <username> zabbix < images.sql
shell> psql -U <username> zabbix < data.sql


Don't forget to check SELinux and configure the right permissions.
Zabbix 3.0 runs like charm.

Regards

Ronald Schouw

[Hal0n]

Create.sql wasn't correct for Debian + PostgreSQL

I'm stuck at trying to point the front end at the local PostgreSQL installation.

Our standard server is Debian 7 and our default database is PostgreSQL 9.4 (but in dev I'll try 9.5 so that by the time I'm done testing prod has caught up)

I was really hoping this would work, it would fit nicely into our stack if it did.

[dimir]

Right, for packages, the instructions are:

psql -U <db user> -c "create database <database>"
zcat /usr/share/doc/zabbix-server-pgsql/create.sql.gz | psql -U <db user> <database>

Related Jira issue: https://support.zabbix.com/browse/ZBX-10959

[Shalini]

Reply

Now how i have to use this version, which one is right now or else What i have to do now to get a correct solution for this problem.

[dimir]

Hope this helps you to get started with Zabbix:

https://www.zabbix.com/documentation/3.0/manual/installation/getting_zabbix