Rafael Domiciano wrote:
> 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... :)

Thanks, once I got all my encodings the same, all is well.

> 
> 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 taken
>>>> 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, because 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
>>
> 


-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin