On 4/27/2010 7:22 PM, [email protected] 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 > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general -- Anyone who trades liberty for security deserves neither liberty nor security. -- Benjamin Franklin _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
