Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
databasedbtemplate0pg
1 Odgovori
3127 Prikazi
Avatar
Aadeel S. Puri

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 =

Avatar
Opusti
Avatar
Roland Lee
Best Answer

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.

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
Why odoo table are too much giant ? Solved
fields database db odoo
Avatar
Avatar
1
mar. 25
917
Odoo Hosting: Database missing
database sql mysql mysqldb db
Avatar
0
apr. 22
3270
[odoo 11] Error while restoring database Solved
database backup restoredb db odoo11
Avatar
Avatar
Avatar
2
dec. 19
12959
How to connect Odoo 10 community with Online hosted database?
database connection db odoo hosted
Avatar
0
sep. 17
5640
Database disappeared from list after activating Google Oauth for administrator
database
Avatar
0
jul. 25
1416