I've ubuntu 8.04 with postgres 8.3. The locale was en_US in /etc/default/locale, change that to LANG="en_US.UTF-8" and rebooted. The "locale" command return the new value for root, postgres, openerp users etc.
Still getting in the postgres log: 2010-08-03 14:01:50 CEST ERROR: encoding UTF8 does not match server's locale en_US 2010-08-03 14:01:50 CEST DETAIL: The server's LC_CTYPE setting requires encoding LATIN1. 2010-08-03 14:01:50 CEST STATEMENT: CREATE DATABASE "sean1" ENCODING 'unicode' TEMPLATE "template0" In /etc/postgresql/8.3/main/postgresql.conf found 4 lc_ settings = 'en_US'. Changed those to en_US.UTF-8 and restarted postgres. Still the same error message as above Next used psql as the postgres user: postgres=# initdb -E en_US.UTF-8 Didn't help either. But the following did work: Stop postgres, kill my current cluster, reinit and restart: /etc/init.d/postgresql-8.3 stop cd /var/lib/postgresql/8.3 mv main main.old mkdir main su - postgres locale (make sure you have en_US.UTF-8) /usr/lib/postgresql/8.3/bin/initdb -D /var/lib/postgresql/8.3/main cd main ln -s /etc/postgresql-common/root.crt root.crt ln -s /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt ln -s /etc/ssl/private/ssl-cert-snakeoil.key server.key /etc/init.d/postgresql-8.3 start # Test: su - postgres psql postgres=# CREATE DATABASE "test3" ENCODING 'unicode' TEMPLATE "template0"; postgres=# drop database test3; chown postgres:postgres main Finally start Openerp, create DBs: all is sweet. So, basically I'd say make sure that locale is right BEFORE installing postgres :-) -- "could not create database" on a new installation of ubuntu and postgresql 8.3 https://bugs.launchpad.net/bugs/331065 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs