[portland] Psycopg Question

Rich Shepard rshepard at appl-ecosys.com
Tue Feb 3 04:30:12 CET 2009

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.


   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,


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

More information about the Portland mailing list