[Bucardo-general] BYTEA columns not synchronized correctly

[Paul Bagyenda]

Strange. I have 'bytea_output' set to 'escape' in postgresql.conf on both boxes. Not sure if that would make a difference for you…

P.

On Mar 02, 2012, at 14:46, Christian Kaltepoth wrote:

> Hey Paul,
> 
> we are using version 9.0.7 from the PostgreSQL repositories:
> 
> postgresql90-9.0.7-1PGDG.rhel6.i686
> postgresql90-plperl-9.0.7-1PGDG.rhel6.i686
> postgresql90-devel-9.0.7-1PGDG.rhel6.i686
> postgresql90-libs-9.0.7-1PGDG.rhel6.i686
> postgresql90-server-9.0.7-1PGDG.rhel6.i686
> perl-DBI-1.609-4.el6.i686
> perl-DBIx-Safe-1.2.5-6.el6.noarch
> perl-DBD-Pg-2.15.1-3.el6.i686
> 
> It's a fresh install of the virtual server so I don't think there are
> any old libs around.
> 
> Christian
> 
> 
> 
> Am Freitag, den 02.03.2012, 14:38 +0300 schrieb Paul Bagyenda:
>> What version of postgreSQL are you running? I've had problems with BYTEA encoding issues when moving to v9.0 while the libs are pre-9.0. 
>> P.
>> 
>> On Mar 02, 2012, at 11:24, Christian Kaltepoth wrote:
>> 
>>>> I'm just going to throw something out there ...  have you checked the
>>>> default character sets on all systems involved?  I have seen issues with
>>>> various (not Bucardo specifically, eg I've seen it with MySQL as well)
>>>> systems where not having the default charset has resulted in differing
>>>> data sets that is supposed to be a 'replica' ... sometimes it is the
>>>> data different, sometimes it is the console displaying it and the data
>>>> is actually correct.
>>>> 
>>>> Michelle
>>> 
>>> Dear Michelle,
>>> 
>>> thank you very much for your response. I also thought of some encoding
>>> issue. But the two virtual machines that I'm using for testing the
>>> replication setup are exactly the same (created from the same VM image).
>>> So I don't think that it's related to some default encoding issue. At
>>> least not on OS level.
>>> 
>>> Any other ideas?
>>> 
>>> Thanks
>>> 
>>> Christian
>>> 
>>> 
>>> -- 
>>> ________________________________________________________________________
>>> 
>>> Dipl.-Inform. Christian Kaltepoth                kaltepoth at ingenit.com
>>> Senior Developer
>>> ----------------------------------------------------------------------
>>> ingenit GmbH & Co. KG                       Tel. +49 (0)231 58 698-168
>>> Emil-Figge-Strasse 76-80                    Fax. +49 (0)231 58 698-121
>>> D-44227 Dortmund                                       www.ingenit.com
>>> 
>>> Registergericht: Amtsgericht Dortmund, HRA 13 914
>>> Gesellschafter : Thomas Klute, Marc-Christian Schröer
>>> ________________________________________________________________________
>>> _______________________________________________
>>> Bucardo-general mailing list
>>> Bucardo-general at bucardo.org
>>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>> 
>> 
> 
> -- 
> ________________________________________________________________________
> 
> Dipl.-Inform. Christian Kaltepoth                kaltepoth at ingenit.com
> Senior Developer
> ----------------------------------------------------------------------
> ingenit GmbH & Co. KG                       Tel. +49 (0)231 58 698-168
> Emil-Figge-Strasse 76-80                    Fax. +49 (0)231 58 698-121
> D-44227 Dortmund                                       www.ingenit.com
> 
> Registergericht: Amtsgericht Dortmund, HRA 13 914
> Gesellschafter : Thomas Klute, Marc-Christian Schröer
> ________________________________________________________________________