Rafael Domiciano wrote:
Good morning,

I had the same issued, about the enconding.
My replication is made by 2 PCs using Fedora, and slony 1.2.14.
And I started the DB with encoding UTF-8, but at the start of the Slon I had
the same error discussed here.
So, i had to change de i18n file of fedora to use ISO8859-1, recreated the
db and now my base is sync... :)

Thanks, once I got all my encodings the same, all is well.


2008/6/11 Geoffrey <[EMAIL PROTECTED]>:

Jeff Davis wrote:

On Wed, 2008-06-11 at 16:14 -0400, Geoffrey wrote:

I definitely seem some issues with encoding, and from what I see, there's
database and client encoding.  The database encoding is different, but I've
not figured out where that is configured, assuming it should be in the
postgresql.conf file somewhere.  It appears that the client_encoding is
different as well, although I would have expected that to have been taken
care when the databases were built.  I have explicitly set the
client_encoding in the postgresql.conf file, but haven't found where to set
the database encoding.

The database encoding can only be set at initdb time. Client_encoding is
only used to be able to convert from one encoding to another, assuming
that some conversion exists. You might be able to get it working by
setting the client encoding to something like iso-8859-1.

The PostgreSQL manual has more details.

Thanks, I'm in the process of re-creating the node 2 empty databases with
the proper encoding.  Something must have changed from 7.4 to 8.3, because I
used the same process to create these databases, and didn't have this
problem before.


Regards,
       Jeff Davis



--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
 - Benjamin Franklin
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general




--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
 - Benjamin Franklin
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to