Skip to Content
This question has been flagged
multiprocesschat12.04pgpool2cronjob
1 Reply
4868 Views
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
Discard
Avatar
Roland Lee
Best 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.

Avatar
Discard
Related Posts Replies Views Activity
Crons in multi-server infrastructure
cron servers multiprocess config cronjob
Avatar
Avatar
1
Jul 21
3048
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
Oct 23
828
How to change color of chat text (Odoo online) Solved
chat
Avatar
Avatar
2
Jul 23
2817
Chat sound from web page
chat
Avatar
0
Dec 23
949