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".
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 > [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
