Ubuntu
openerp-server package

  1. Bug #331065
  2. Comment #0

Comment 0 for bug 331065

Revision history for this message
Lorenzo Battistini (elbati) wrote : "could not create database" on a new installation of ubuntu 8.04 and postgresql 8.3

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