[portland] Psycopg Question

[Rich Shepard]

On Mon, 2 Feb 2009, Dylan Reinhardt wrote:

> Is postgres correctly installed and running?  Does tinyerp need a connection 
> string configured?
>
> If you haven't eliminated those possibilities, I'd check there first.

Dylan,

   Yes, postgres is running correctly. Further research revealed that the
LANG environment is en_US and this limits postgres encoding to LATIN1. The
application wants UTF8.

   So I copied postgresql.conf.sample to postgresql.conf, changed the
encoding variable to utf8 (from us_ascii), moved the file to
/var/lib/pgsql/data and issued 'kill -HUP <pid>'. That didn't help.

   So, it's a postgres locale issue and not a python or psycopg issue. I'll
pursue a solution there.

Many thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863