I'm trying to set another server that will be the duplicate of the first server (production). So I set up 2 exactly same servers, tuned PG same too, installed pgpool2 on first server, installed postgresql-9.1-pgpool2 on both servers. I set up OpenERP to connect to pgpool2 on port 5433. Set the 2 backends as follow in pgpool.conf (for now , its on LAN for testing purpose) :
backend_hostname0 = '192.168.1.110'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/postgresql/9.1/main/'
backend_flag0 = 'ALLOW_TO_FAILOVER'
backend_hostname1 = '192.168.1.120'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/postgresql/9.1/main/'
backend_flag1 = 'ALLOW_TO_FAILOVER'
All works fine.
I can connect to OpenERP on server 1 and data is well duplicated on both PG.
But it seems to have some troubles with transientModel.
Each time I call a module (I made) that uses TransientModel, I get an error like below :
File "/usr/lib/pymodules/python2.7/openerp/tools/image.py", line 103, in
return image_resize_image(base64_source, size, encoding, filetype,
File "/usr/lib/pymodules/python2.7/openerp/tools/image.py", line 67, in
image_stream = io.BytesIO(base64_source.decode(encoding))
File "/usr/lib/python2.7/encodings/base64_codec.py", line 42, in base64_decode
output = base64.decodestring(input)
File "/usr/lib/python2.7/base64.py", line 321, in decodestring
Error: Incorrect padding
If I go back to standard config (one server and direct to PG) , OpenERP works fine. So I think there is a problem with binary fields and transientmodel ??
Can anyone help me please ?
Thanks a lot
It seems that Openerp makes SELECT queries that are operated on both PG servers, so that binary fields are corrupted because of transient model ? Id o not have any trouble with models, except with transient ones.
I'm looking for a simple replication solution for PostgreSQL. I searched on GG but I did not find anything so "easy" to install. I do not need load balancing, I just want to save data (streaming replication) for backup purpose and switch on failover.
Thanks but I'm not sure pgbouncer is for replication.
Anyway, I've finally gone with native PG replication thanks to the excellent tutorial found on Greg Reinacker's Blog
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/16/14, 10:20 AM|
|Seen: 2346 times|
|Last updated: 3/16/15, 8:10 AM|