Tue Sep 23 10:52:31 PDT 2008
- Previous message: [Slony1-general] Slony 1.2.15 on Win
- Next message: [Slony1-general] Using EXECUTE SCRIPT for adding time partitioned tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello Lukas, Something is wrong in you replication. See that the log is acusing another encoding: UTF-8. And you said that you are using SQL_ASCII I had something like that some time ago, and I corrected adjusting the encoding. 2008-09-22 23:39:39 FLE Standard Time ERROR remoteWorkerThread_1: copy from stdin on local node - PGRES_FATAL_ERROR ERROR: invalid byte sequence for encoding "UTF8": 0xebfe79 2008/9/23 Lukas <lukas at fmf.vtu.lt> > Hello, > > If you are talking about encoding of postgresql database, then it is not > - on all nodes (on windows as well) it is SQL_ASCII. I double checked > that.. > Also if it is because of encoding of database it should not work when I > start slon from Linux host.. > > Lukas > > > Hello there, > > The problem is here: > > 2008-09-22 23:39:39 FLE Standard Time ERROR remoteWorkerThread_1: copy > > from stdin on local node - PGRES_FATAL_ERROR ERROR: invalid byte sequen= ce > > for encoding "UTF8": 0xebfe79 > > > > Maybe the Windows Server is not using the same encoding that the others > > servers...! > > > > 2008/9/22 Lukas <lukas at fmf.vtu.lt> > > > >> Hello, > >> > >> we have replication from 9 nodes, 8 of it is on Linux OS, and one more > >> on > >> Windows.. we use Postgresql 8.3.3 and Slony 1.2.15 on all nodes. Also > >> All > >> DB on all nodes are on SQL_ASCII encoding. > >> when I started replication and made fist "subscribe" I got error on W= in > >> system: > >> > >> 08-09-22 23:39:39 FLE Standard Time DEBUG2 remoteWorkerThread_1: Begin > >> COPY of table "public"."padalinys" > >> 08-09-22 23:39:39 FLE Standard Time DEBUG2 remoteWorkerThread_1: > >> nodeon73 > >> is 0 > >> TICE: truncate of "public"."padalinys" failed - doing delete > >> 2008-09-22 23:39:39 FLE Standard Time ERROR remoteWorkerThread_1: copy > >> from stdin on local node - PGRES_FATAL_ERROR ERROR: invalid byte > >> sequence > >> for encoding "UTF8": 0xebfe79 > >> 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". > >> > >> The most important thing that, when I started slon from other host on > >> Linux for the same DB which is on Win, it replicated without an errorr= .. > >> May it is a bug? > >> > >> thx > >> Lukas > >> > >> > >> -- > >> This message has been scanned for viruses and > >> dangerous content by OpenProtect(http://www.openprotect.com), and is > >> believed to be clean. > >> > >> _______________________________________________ > >> Slony1-general mailing list > >> Slony1-general at lists.slony.info > >> http://lists.slony.info/mailman/listinfo/slony1-general > >> > > > > -- > > This message has been scanned for viruses and > > dangerous content by OpenProtect(http://www.openprotect.com), and is > > believed to be clean. > > > > > > > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080923/= b8837584/attachment.htm
- Previous message: [Slony1-general] Slony 1.2.15 on Win
- Next message: [Slony1-general] Using EXECUTE SCRIPT for adding time partitioned tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list