migrating to Zabbix 3.0 and changing database

[erore]

I have Zabbix 2.4 running under MySQL on openSuse. I would like to migrate to Debian with the newest Zabbix 3.0 and to postgresql. I have seen several posts about how to migrate from MySQL to postgresql but most of them are rather old and not very complete.

My question thus, would you recommend bothering with the migration of data or is it better to do a fresh installation of new Zabbix 3 with postgresql and importing only the custom templates from the old system and readding all the hosts (about 20) (and just losing the data because it may not be worth the migration pain)?

If I was to stay on MySQL would the migration be easier (I assume it would require first install zabbix 2.4 and then update it to v. 3?)?

Thank you.

[kloczek]

Zabbix uses in almost all SQL queries SQL92 compliant queries.
In other words: if you are expecting that migration to posgresql will give you sometring you are wrong. IMO MySQL is better suited as DB engine than postgresql because it provides less functionalities above what zabbix really needs.
Keep in mind KISS principle.

https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems