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