Re: encoding problems

On 4/27/2010 7:22 PM, jks@... wrote:
> Slony replication between my two servers is failing with this:
> 
> " ERROR:  invalid byte sequence for encoding "UTF8": 0xac
> HINT:  This error can also happen if the byte sequence does not match the 
> encoding expected by the server, which is controlled by "client_encoding".

Please see this thread:

http://lists.slony.info/pipermail/slony1-general/2010-April/010596.html

The fix is committed in all relevant branches and will be released ASAP.

Jan

> 
> Searching the archives has revealed that people have had this problem 
> before, but the consensus was that the problem was caused by the two pg 
> installations having different versions or different encodings.  Both my 
> servers are pg 8.4.3, encodings are UTF8, and slony is 2.0.3.
> 
> So my questions are:
> 
> 1) How can I fix this problem and make sure it never happens again?
> 
> 2) In the short run how can I break slony out of its loop?  Can I find 
> this entry in sl_log_X somewhere and delete it?
> _______________________________________________
> Slony1-general mailing list
> Slony1-general@...