Skip to Content
Dette spørgsmål er blevet anmeldt
multiprocesschat12.04pgpool2cronjob
1 Svar
6409 Visninger
Avatar
George Kondrach

Hi All,

I'm vexed by the issue of adding PGBouncer to existing 12.0 CE sites. The issue comes down to this:

  1. If I set pgbouncer.ini pool_mode = session, then everything works but there's no benefit from PGBouncer.

  2. 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 permutations of the suggestions using odoo-bin, odoo-gevent, 3rd party wsgi servers (gunicorn, cherrypy), CRON and CHAT listeners bypassing PGBouncer, etc.

Can anyone make some new qualified CONFIG or PROCESS or CODE suggestions for running 12.0 CE through PGBouncer and keeping CRON and CHAT features?

Many thanks!

George

Avatar
Kassér
Avatar
Roland Lee
Bedste svar

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.

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
Crons in multi-server infrastructure
cron servers multiprocess config cronjob
Avatar
Avatar
1
jul. 21
5204
how to deploy multiple odoo services with multiprocessing
multiprocess
Avatar
0
jan. 25
1802
Product Serial Number in Invoice Løst
12.04
Avatar
Avatar
Avatar
2
okt. 25
9044
How do I know if the apps in the new menu for new additions are paid or not?
12.04
Avatar
Avatar
1
sep. 24
41
Cron action not work automatically just manually
cronjob
Avatar
Avatar
1
okt. 23
3038