Ir al contenido
Se marcó esta pregunta
multiprocesschat12.04pgpool2cronjob
1 Responder
6414 Vistas
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
Descartar
Avatar
Roland Lee
Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
Crons in multi-server infrastructure
cron servers multiprocess config cronjob
Avatar
Avatar
1
jul 21
5207
how to deploy multiple odoo services with multiprocessing
multiprocess
Avatar
0
ene 25
1803
Product Serial Number in Invoice Resuelto
12.04
Avatar
Avatar
Avatar
2
oct 25
9048
How do I know if the apps in the new menu for new additions are paid or not?
12.04
Avatar
Avatar
1
sept 24
41
Cron action not work automatically just manually
cronjob
Avatar
Avatar
1
oct 23
3042