[Bucardo-general] BYTEA columns not synchronized correctly

[Christian Kaltepoth]

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
________________________________________________________________________
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 6131 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120302/1dc9d800/attachment.bin