Zabbix + PostgreSQL + pgbouncer

[monosoul]

Hi!

I'm interested in using bgbouncer to reduce amount of connections to DB (which is PostgreSQL 9.3).
I'm getting best results with connections pooling by transactions (pool_mode=transaction), but I'm not sure if zabbix is using some features that are not supported in this mode or not.
Here is feature matrix from postgresql wiki. Could someone take a look on it and tell if we can use this pooling mode or not?

Thanks in advance!

[Slash]

Did you run on any problem with pgbouncer?

This could be some things that I'll use in the future because the nubmer of db connections used by zabbix is outrageous.

[monosoul]

Did you run on any problem with pgbouncer?

This could be some things that I'll use in the future because the nubmer of db connections used by zabbix is outrageous.

Hi, Slash!

I'm running zabbix + pgbouncer for a 1,5 week now and didn't faced any issues yet. Also, amount of connections to DB is reduced by 3 times which is fantastic IMHO.

[Slash]

I just installed pgbouncer and configured my zabbix server/frondend to use it, no immediate problem that I saw with the "pool_mode = transaction" setting.

About the number of connection, before it was at 200 and now it's at 11

Great idea to use this tool for Zabbix indeed!

I'll update the post if I notice any issue with zabbix calling one of the few incompatible features listed at http://wiki.postgresql.org/wiki/PgBouncer . But I really don't think that any of those features are used by zabbix (too specific) so we should be fine

[monosoul]

@Slash Very nice result! Glad for you!
And yep, I don't think so too.

[cgaspero]

Hi guys: I would like to implement pg_bouncer on my zabbix.
Anyone can help with the configuration?

Thanks in Advance!!

[monosoul]

@cgaspero You could use this useful doc. Also this manual could be useful for you. Try it and post here any issues you'll face.

[cgaspero]

@cgaspero You could use this useful doc. Also this manual could be useful for you. Try it and post here any issues you'll face.

Thanks for reply.
Yesterday, after read others docs I could configure pgbouncer to use in our client server.
Just I would like to know what is the best conf to use with zabbix. Already, I put transaction mode, with 400 max connections and 20 default pooling.
The client server has 1400 monitored hosts with 550 nvps. The main problem for the company is Memory resource on that server. So, I hope pgbouncer can help me