On 4/27/2010 7:22 PM, jks at selectacast.net 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".
> 
> 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.

You mean the DB encodings are both UTF8?

First thing to check then is if the client_encoding, used by the slon 
process on both databases the same? You can set that explicitly for the 
slon DB user with ALTER USER;


Jan

> 
> 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 at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin