Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
3095 Widoki

Hello Everyone,

I have installed Odoo13 in my VPS using below tutorial.

https://www.73lines.com/blog/erp-5/post/how-to-install-odoo-13-on-centos7-27

Now i want to install pg_bouncer in which requires editing database parameters.

Below is my db configuration in config file. I am not able to understand where to edit database parameter? Can anyone please help.

I have some databases running right now that is why thinking hard before going to change anything in configuration.

db_host = False
db_maxconn = 64
db_name = False
db_password = False
db_port = False
db_sslmode = prefer
db_template = template0
db_user = False
dbfilter =

Awatar
Odrzuć
Najlepsza odpowiedź

Try the Heimdall Proxy (http://www.heimdalldata.com/odoo). Pg-bouncer or Pg-Pool-II does not work for Odoo because queries are in transactions.

The Heimdall Proxy was specifically designed for Odoo to handle transactions and data consistency. It can support connection pooling, query caching, automated Postgres failover, and Read/Write split with Strong Consistency. Query caching will give you the biggest performance/scale boost. We have seen cache hit rates up to 90% on Odoo.

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
mar 25
892
0
kwi 22
3222
2
gru 19
12912
0
wrz 17
5572
0
lip 25
1353