Skip ke Konten
Pertanyaan ini telah diberikan tanda
multiprocesschat12.04pgpool2cronjob
1 Balas
5792 Tampilan
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
Buang
Avatar
Roland Lee
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
Crons in multi-server infrastructure
cron servers multiprocess config cronjob
Avatar
Avatar
1
Jul 21
4227
how to deploy multiple odoo services with multiprocessing
multiprocess
Avatar
0
Jan 25
999
Product Serial Number in Invoice
12.04
Avatar
Avatar
Avatar
2
Des 24
8591
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
2131