Forum OpenACS Q&A: Response to client_encoding message

Collapse
Posted by Ben Adida on
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...)