Odoo Help


Postgresql replication - Problem with pgpool2 and transient model and binary field

Thierry Godin
on 5/16/14, 10:20 AM 3,671 views

Hi all,

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 = ''
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/postgresql/9.1/main/'
backend_flag0 = 'ALLOW_TO_FAILOVER'

backend_hostname1 = ''
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
    return binascii.a2b_base64(s)
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


EDIT 2014-05-22:

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.


Thierry Godin

--Thierry Godin--
| 8 7 8
Collegien, France
--Thierry Godin--


Thierry Godin
On 5/23/14, 7:39 AM

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



swapnil wagh

--swapnil wagh--
| 6 5 8
Pune, India
--swapnil wagh--

My name is Swapnil A. Wagh. I studied Master Of computer Science and work as a Software Engineer. I’m a technology enthusiast and always eager to learn new and exciting technologies. I’m constantly looking for innovative solutions to age-old problems that push the limits of what we conceive to be possible.

swapnil wagh
On 5/23/14, 7:19 AM

You can try pgbouncer 


Axel Mendoza

--Axel Mendoza--
| 7 8 8
Camaguey, Cuba
--Axel Mendoza--

DevOps - Full stack - Software Architect - Developer - Technology Integrator

I could help you to develop anything and solve complex problems based on technologies, integrations and tricky stuffs mostly in Python with OpenERP/Odoo, Zato, Django and many others frameworks programming languages and technologies.

I offers consulting services to anyone with an unanswered questions or needs for customizations. Think about it, maybe it's better to have an expert to solve your issues and projects than having a full-time employee trying to understand what to do and how

Reach me at aekroft@gmail.com

Axel Mendoza
On 8/4/14, 6:54 AM

You only need to turn off replication in pgpool.conf. I have this issue and get resolved turning replication off

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.


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

4 follower(s)


Asked: 5/16/14, 10:20 AM
Seen: 3671 times
Last updated: 3/16/15, 8:10 AM