Good morning,

I had the same issued, about the enconding.
My replication is made by 2 PCs using Fedora, and slony 1.2.14.
And I started the DB with encoding UTF-8, but at the start of the Slon I had
the same error discussed here.
So, i had to change de i18n file of fedora to use ISO8859-1, recreated the
db and now my base is sync... :)

2008/6/11 Geoffrey <lists at serioustechnology.com>:

> Jeff Davis wrote:
>
>> On Wed, 2008-06-11 at 16:14 -0400, Geoffrey wrote:
>>
>>> I definitely seem some issues with encoding, and from what I see, there=
's
>>> database and client encoding.  The database encoding is different, but =
I've
>>> not figured out where that is configured, assuming it should be in the
>>> postgresql.conf file somewhere.  It appears that the client_encoding is
>>> different as well, although I would have expected that to have been tak=
en
>>> care when the databases were built.  I have explicitly set the
>>> client_encoding in the postgresql.conf file, but haven't found where to=
 set
>>> the database encoding.
>>>
>>
>> The database encoding can only be set at initdb time. Client_encoding is
>> only used to be able to convert from one encoding to another, assuming
>> that some conversion exists. You might be able to get it working by
>> setting the client encoding to something like iso-8859-1.
>>
>> The PostgreSQL manual has more details.
>>
>
> Thanks, I'm in the process of re-creating the node 2 empty databases with
> the proper encoding.  Something must have changed from 7.4 to 8.3, becaus=
e I
> used the same process to create these databases, and didn't have this
> problem before.
>
>
>> Regards,
>>        Jeff Davis
>>
>>
>>
>
> --
> Until later, Geoffrey
>
> Those who would give up essential Liberty, to purchase a little
> temporary Safety, deserve neither Liberty nor Safety.
>  - Benjamin Franklin
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080612/=
70ee6fa1/attachment.htm