[portland] Psycopg Question
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.
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