Forum OpenACS Q&A: client_encoding message

Collapse
1: client_encoding message
Posted by Mark S on 10/12/00 04:42 PM
After installing PostgreSQL 7.0.2 on Redhat following the simple
postgres instructions, I get a message saying:

NOTICE: Unrecognized variable client_encoding

When I create a test database.  It seems to go ahead and create it.
Is that normal and I just haven't noticed it before or have I set
something up wrong?

Thanks.

Collapse
2: Response to client_encoding message (response to 1)
Posted by Ben Adida on 10/12/00 04:46 PM
Be wary of this. This will come back to bite you. What this means
(and I learned this thanks to Tom Lane of PostgreSQL) is that
you probably have an older version of PostgreSQL installed on
your box, probably 6.5.3, in addition to the latest version 7.0.2 you
just installed.

Try doing "which psql" at the prompt, and see where that leads
you. Chances are, it leads you to /usr/bin/psql, which is the
RedHat-installed PostgreSQL. To solve this problem, try
removing the PostgreSQL RPM. To be extra certain, you might
want to remove all traces of Postgres and reinstall 7.0.2 from
scratch.

If you want to remove the executables by hand, remember that
there are a lot (psql, pg_dump, pg_dumpall, createdb,
destroydb, createuser, destroyuser, etc...)