Odoo Help

2

PgPool and pgBouncer in Odoo

By
Midhunmadhu
on 3/23/15, 3:07 AM 2,534 views

Hi,

Does anybody know how we can use pgPool and pgBoucner for helping load balancing in Odoo

2
Vasanth
On 3/23/15, 3:21 AM

http://girders.org/blog/2012/09/29/scaling-postgresql-with-pgpool-and-pgbouncer/

Hi vasanth thanks for your reply. Did you use this process for load balancing in odoo db?

Midhunmadhu
on 3/23/15, 7:14 AM

no.I am did not use this process yet.i heared about it

Vasanth
on 3/23/15, 7:42 AM
0
CodeCrax
On 8/3/17, 11:31 AM
Hey! I tried connecting odoo with PostgreSQL via pgbouncer. I'll just give you a brief connections configurations! Just try this!

Say suppose I have two servers:

1.192.168.1.1 (Which has Odoo & Pgbouncer running on it)

2. 192.168.2.12 (Which has Postgresql running on it)

Postgresql Config on 192.168.2.12

pg_hba.conf: add these lines to your pg_hba.conf file
# IPv4 local connections:
host      all      all      192.168.1.1/32     trust
posgresql.conf: make PostgreSQL listen to all the IPs
# Connection Settings -
listen_addresses = '*'
Creating User Database Password on PostgreSQL
$ sudo -i -u postgres
$ psql
$ CREATE USER user_pg WITH PASSWORD '1234';
$ CREATE DATABASE db_pg WITH OWNER user_pg;
$ ALTER ROLE user_pg WITH CREATEDB CREATEROLE; 

Pgbouncer Config on 192.168.1.1

/etc/pgbouncer/pgbouncer.ini: Edit the following in your pgbouncer.ini
[DATABASES]
*= host=192.168.2.12 port=5432 db_name=db_pg
listening address= *
listening port= 6432
auth_type=trust
/etc/pgbouncer/userlist.txt: Add the following in your userlist.txt
"user_pg" "1234"
Running Odoo:
$ ./odoo-bin --database=db_pg --db_host=127.0.0.1 --db_port=6432 --db_user=user_pg --db_password=1234
0
ahmad
On 10/4/16, 10:45 PM

any tutorial on implementing pgBouncer with odoo?

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 3/23/15, 3:07 AM
Seen: 2534 times
Last updated: 8/3/17, 11:31 AM