Interesting to see a PostgreSQL template in Zabbix

will zabbix be able to monitor via agent a postgresql database 

with same functionalities like the module of Ryan does at the moment?

http://cavaliercoder.com/libzbxpgsql/

patrik The template will be slightly different as it will feature user parameters instead of loadable module for now.
The first version of the template has been published. You can review it here: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/postgresql

Available in 4.4.0alpha2 298a3379

I tried out this template with a PostgreSQL 11 DB and Zabbix 4.2 and came across several issues:

1.

Discovered items "DB {#DBNAME}: Queries * time" should have type Numeric (float) and not Numeric (unsigned). 

2.

Item "Replication: lag in seconds" should have type Numeric (float) and not Numeric (unsigned). 

3.

At least when installing from the PGDG repos, pg_isready is not in the $PATH for the zabbix user, leading to false alerts. So perhaps something could be added to the README.md about that. 

afayantsev Thank you for your feedback! Added type conversion in SQL queries and an installation note from the PGDG repository.