Which PostgreSQL version does Zabbix Officially Support?

[doctorbal82]

Hello,

We currently use PostgreSQL v10.6 for Zabbix 3.4.15. It works well and we will soon implement declarative range partitioning on the clock column for history* and trends* tables to mitigate the housekeeper problems on >500NVPS.

PostgreSQL came out with version 11 on 2018-10-18 with fantastic improvements for partitioning (automatic Index creations on partitioned tables from parent, primary key on partitions, default partition tables, improved query performance, etc. (https://www.postgresql.org/about/news/1894/) which will work even better than using implicit, trigger based partitioning as suggested with previous versions in the wiki.

Thus my question is what version of PostgreSQL does Zabbix fully support? Is there a minimum version or basically "whatever the team is most comfortable with regarding a database"?

Thanks!

[kloczek]

None of the zabbix versions depends on exact version of the PostgreSQL.
None of the zabbix versions depends on added or not partitioning.
Partitioning is completely transparent from point of view of results of the queries.

[doctorbal82]

Thanks for the reply and input kloczek!