Change password for any user in Zabbix running with PostgreSQL

First login to PostgreSQL, next switch the zabbix database and change the password:

\c zabbix
zabbix=> update users set passwd=md5('admin') where alias='admin';