Hi all,
  I'm replicating a database that has 8 tables. 7 of them replicate fine on
first replication but the last table (reports table) keeps giving this error
whenever I try to replicate it:
2008-03-07 08:59:31 EST ERROR  remoteWorkerThread_1: copy from stdin on
local node - PGRES_FATAL_ERROR ERROR:  invalid byte sequence for encoding
"UTF8": 0x80

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".
 I have ran a SET CLIENT_ENCODING TO 'UTF-8' command on both the master and
slave databases and I keep getting the same error. I have also dropped the
table on the slave and recreated it with the exact schema of the master and
still the same error.
 I noticed that if I use pg_dump to extract the data on the reports table of
the master and I insert it into the table on the slave, I don't get that
error. Also, it seems to be giving the error on the last row of the table
and the table is dynamically updated (on the average 5 times within the
hour).
  Does anyone have an idea as to what the problem could be?

     Victor
-- 
View this message in context: http://www.nabble.com/UTF-8-encoding-Error-tp16000710p16000710.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.