[Bucardo-general] BYTEA columns not synchronized correctly

[Christian Kaltepoth]

Dear Paul,

thank you very much for this hint. You are completely right. I can
confirm that setting 'bytea_output' to 'escape' on both server fixes the
issue I had. Replication is now working fine. If I set 'bytea_output' to
'hex' (which is the default), the replication breaks like described in
my first mail.

Thanks for your help.

Christian



Am Freitag, den 02.03.2012, 14:57 +0300 schrieb 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
> > ________________________________________________________________________
> 
> _______________________________________________
> 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/0b405e7f/attachment.bin