Setting environment variables for PostgreSQL

Andreas Tille tillea at rki.de
Mon Feb 19 14:58:20 CET 2007


Hi,

when facing a font encoding problem during a migration from
PostgreSQL 7.4 to 8.1 I found out that setting the client
encoding explicitely via

      SET CLIENT_ENCODING='iso-8859-1';

solves this.  This can be enforced using an environment
variable

      export PGCLIENTENCODING=LATIN1

which works perfectly if I use psql as client.  So I tried
both

    1. Adding
          export PGCLIENTENCODING=LATIN1
       on top of /etc/init.d/zope2.9 and
    2. adding
          PGCLIENTENCODING=LATIN1
       to /etc/default/zope2.9

on a quite recent testing machine.  Unfortunately I can not
see any result and wonder, whether the environment variable
setting is destroyed anywhere in the startup proces or whether
there might be another reason for this problem.

BTW, I tried to set the encoding directly in the
      Z Psycopg Database Connection
object, as 'LATIN1' without any success as well

Kind regards

            Andreas.

-- 
http://fam-tille.de



More information about the pkg-zope-developers mailing list