[portland] Psycopg Question
pacopablo at pacopablo.com
Tue Feb 3 05:54:23 CET 2009
Rich Shepard wrote:
> 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.
With most projects that use postgresql as a backend, they require that
you create the database manually. It appears that tinyerp (now openerp)
is no exception 
Additionally, it doesn't really matter what the default encoding is for
postgresql. You can specify the encoding when creating the db.
More information about the Portland