jks at selectacast.net jks at selectacast.net
Tue Apr 27 16:22:15 PDT 2010
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.

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?


More information about the Slony1-general mailing list