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.
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
