After installing and executing openerp-server-5.0.0-3 over ubuntu 8.04 with postgresql 8.3, I get the following while creating a new database:
[2009-02-18 16:17:47,507] INFO:dbpool:Connecting to template1 [2009-02-18 16:17:47,517] DEBUG:sql:bad query: CREATE DATABASE "dev" ENCODING 'unicode' [2009-02-18 16:17:47,517] DEBUG:sql:[01]: encoding UTF8 does not match server's locale en_US [2009-02-18 16:17:47,518] DEBUG:sql:[02]: DETAIL: The server's LC_CTYPE setting requires encoding LATIN1. [2009-02-18 16:17:47,518] INFO:dbpool:Closing all connections to template1 Closing connection <connection object at 0x883c818; dsn: 'user=root dbname=template1', closed: 0>
I tried to set all locales to en_US.UTF-8 (my ubuntu's default was just en_US):
ubuntu@ubuntu:~$ locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=
After that, I reinstalled postgresql, but it did not work
After installing and executing openerp- server- 5.0.0-3 over ubuntu 8.04 with postgresql 8.3, I get the following while creating a new database:
[2009-02-18 16:17:47,507] INFO:dbpool: Connecting to template1
[2009-02-18 16:17:47,517] DEBUG:sql:bad query: CREATE DATABASE "dev" ENCODING 'unicode'
[2009-02-18 16:17:47,517] DEBUG:sql:[01]: encoding UTF8 does not match server's locale en_US
[2009-02-18 16:17:47,518] DEBUG:sql:[02]: DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
[2009-02-18 16:17:47,518] INFO:dbpool:Closing all connections to template1
Closing connection <connection object at 0x883c818; dsn: 'user=root dbname=template1', closed: 0>
I tried to set all locales to en_US.UTF-8 (my ubuntu's default was just en_US):
ubuntu@ubuntu:~$ locale "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" "en_US. UTF-8" ON="en_ US.UTF- 8"
LANG=en_US.UTF-8
LC_CTYPE=
LC_NUMERIC=
LC_TIME=
LC_COLLATE=
LC_MONETARY=
LC_MESSAGES=
LC_PAPER=
LC_NAME=
LC_ADDRESS=
LC_TELEPHONE=
LC_MEASUREMENT=
LC_IDENTIFICATI
LC_ALL=
After that, I reinstalled postgresql, but it did not work