Postgresql replication - Problem with pgpool2 and transient model and binary field
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.