Postgresql support in Zabbix 1.1?

[rinsan]

Will Zabbix 1.1 contain Postgresql support when it's released in stable version?

[James Wells]

Greetings,

Zabbix already supports Postgress, however, the schema files are bit out of sync with the MySQL schema files.

If you want to use Postgress, you create the DB, load the schema, then you will need to go through the MySQL schema and do a comparison, updating the Postgress schema to match what is in the MySQL schema. Not sure why they got so far out of sync, but, once you get them in sync, it appears to work properly, if quite a bit slower than MySQL.

Please note that if you use any of the patches that I create, the dbupdates have support for Postgress and should be fully functional.

[rinsan]

Greetings,

I tried to compile Zabbix 1.1beta1 now and activated both pgsql support and compilations of both server and agent in configure, but then make died with this error:

if gcc -DHAVE_CONFIG_H -I. -I. -I../../../include -I../../../include -I/usr/pkg /include -g -O2 -MT db.o -MD -MP -MF ".deps/db.Tpo" -c -o db.o db.c; then m v -f ".deps/db.Tpo" ".deps/db.Po"; else rm -f ".deps/db.Tpo"; exit 1; fi
db.c:239:2: #error SUPPORT OF POSTGRESQL NOT IMPLEMENTED YET
db.c: In function `DBaffected_rows':
db.c:253: error: `NOT' undeclared (first use in this function)
db.c:253: error: (Each undeclared identifier is reported only once
db.c:253: error: for each function it appears in.)
db.c:253: error: parse error before "IMPLEMENTED"
*** Error code 1

Stop.
make: stopped in /home/users/rinsan/scratch/download/zabbix-1.1beta1/src/libs/zb xdbhigh
*** Error code 1

[sauron]

Maybe you read errors first ?

 #error SUPPORT OF POSTGRESQL NOT IMPLEMENTED YET

[rinsan]

Yep I read it and I posted it because James Wells said in the thread that Zabbix had working Postgress support.

[elkor]

In James' defense.. as it was working and supported in 1.0, it was just assumed that the database schema was the only thing behind (so Alexei didn't have to maintain two separate database layouts during development).

at least *I* assumed that to be the case.

[rinsan]

Aah Ok, it seems that it' just some small parts code that are missing but I will look at it and try to produce a patch if not some one is already working on it?

[James Wells]

In James' defense.. as it was working and supported in 1.0, it was just assumed that the database schema was the only thing behind

Additionally, when I was working on the MySQL variable port patch, I remember seeing the Postgress connectors in the 1.1alpha12 and 1.1beta1 source code.