which is the preferred Database

[bignose]

I'm running zabbix on Postgresql 8.1 right now with zabbix 1.6

I just had to update the trends and history table to make some of the numeric fields larger than they were, and as well in my zabbix error log i'm getting lots of errors like this:

HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
WARNING: nonstandard use of \' in a string literal
LINE 1: ...643204+delay,lastfailedstep=1,time=0.000000,err or='Status co...

Which leads me to believe, maybe zabbix is supported on Postgres, but not preferred? Would mysql be tested better?

Maybe just upgrading to 1.8 would make this better? Comments?

[richlv]

mysql is much more widely used with zabbix, so it's probably more tested.
as for postgresql, i would expect it to work much better in 1.8, there have been lots of fixes and improvements (for example, 1.8.2 will have postgresql watchdog just like mysql has, so zabbix server won't die when pgsql is unavailable for some time)

[stu42j]

I wouldn't worry too much about that warning message. It due to a future change in behavior in Postgres, not a problem with Zabbix.