2009/10/13 Andrew Sullivan <[email protected]> > On Mon, Oct 12, 2009 at 01:40:55PM +0200, Filip Rembiałkowski wrote: > > > LOG: duration: 3.091 ms statement: select "_replication".copyFields(1); > > ERROR: character 0x829c of encoding "MULE_INTERNAL" has no equivalent in > > "WIN1250" > > STATEMENT: copy "public"."uslugi" (<FIELDS LIST>) to stdout; > > > > I have no idea why "WIN1250" comes into stage; both databases are UTF-8. > > It may be the client encoding. What locale are the slon daemons running > under? >
yes, this was the case. the database was latin2 - encoded, but from some reason (*) this was made: ALTER DATABASE foo SET client_encoding TO 'WIN1250'; problem was solved by: ALTER ROLE slony SET client_encoding to 'LATIN2'; btw - this also breaks "pg_dump dbname"; I have to use -E LATIN2 to make it work (*) business-critical win32 app -- Filip Rembiałkowski JID,mailto:[email protected] http://filip.rembialkowski.net/
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
