Rafael Domiciano rafael.domiciano at gmail.com
Tue Sep 23 10:52:31 PDT 2008
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


More information about the Slony1-general mailing list