Configure 12.0 CE as Multiprocess with PGBouncer where CRON and CHAT Both Work?

Question

Hi All,
I'm vexed by the issue of adding PGBouncer to existing 12.0 CE sites. The issue comes down to this:
If I set pgbouncer.ini pool_mode = session, then everything works but there's no benefit from PGBouncer.
If I set pgbouncer.ini pool_mode = transaction, then pooling is a benefit, but CRON and CHAT become inoperative.
To try and resolve Case 1, I've tried many pgbouncer.ini configurations.
To try and resolve Case 2, I've read Odoo and Openerp forums back to version 6, and tried many permut

Roland Lee · Answer

Hello. Yes. you are correct. Pg-bouncer or Pg-Pool-II does not work for Odoo. Odoo queries are in transactions. If you are looking for proxy for Odoo, check out the Heimdall Proxy: https://www.heimdalldata.com/odoo. It can support connection pooling, query caching, automated Postgres failover and Read/Write split with Strong Consistency.

Powiązane posty	Odpowiedzi	Widoki
Crons in multi-server infrastructure cron servers multiprocess config cronjob	1 lip 21	4243
how to deploy multiple odoo services with multiprocessing multiprocess	0 sty 25	1004
Product Serial Number in Invoice 12.04	2 gru 24	8594
How do I know if the apps in the new menu for new additions are paid or not? 12.04	1 wrz 24	41
Cron action not work automatically just manually cronjob	1 paź 23	2158

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!