I finally got a working setup in FreeBSD+Postgreql, but the Zabbix server keeps dying with errors like:
079900:20070407:211843 Do not update functions, same value
079900:20070407:211843 In update_triggers [18132]
079899:20070407:211853 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oi
d,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i .hostid,h.status,i.value_type,h.errors_from,i.snmp _port,i.delta,i.prevorgvalue,i.las
tclock,i.units,i.multiplier,i.snmpv3_securityname, i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.s nmpv3_privpassphrase,i.formula,h.a
vailable,i.status,i.trapper_hosts,i.logtimefmt,i.v aluemapid from hosts h, items i where i.nextcheck<=1175995122 and i.status in (0) and i.type not in (2,7) and h.status=0 and h.disable_until<=1175995122 and h.errors_from!=0 and h.hostid=i.hostid and i.key_ not in ('st
atus','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck
079899:20070407:211853 Query failed:PGRES_FATAL_ERROR:could not receive data from server: Operation timed out
079900:20070407:211843 Do not update functions, same value
079900:20070407:211843 In update_triggers [18132]
079899:20070407:211853 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oi
d,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i .hostid,h.status,i.value_type,h.errors_from,i.snmp _port,i.delta,i.prevorgvalue,i.las
tclock,i.units,i.multiplier,i.snmpv3_securityname, i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.s nmpv3_privpassphrase,i.formula,h.a
vailable,i.status,i.trapper_hosts,i.logtimefmt,i.v aluemapid from hosts h, items i where i.nextcheck<=1175995122 and i.status in (0) and i.type not in (2,7) and h.status=0 and h.disable_until<=1175995122 and h.errors_from!=0 and h.hostid=i.hostid and i.key_ not in ('st
atus','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck
079899:20070407:211853 Query failed:PGRES_FATAL_ERROR:could not receive data from server: Operation timed out