tag 641913 + wontfix retitle 641913 gforge-db-postgresql requires an Unicode locale (or C) thanks
Andreas Karnetzki, 2011-09-17 15:04:27 +0200 : > When trying to create the postgresSQL database for the package the post > install > script reports this failure: [...] > CREATE DATABASE's STDOUT: > SET > CREATE DATABASE's STDERR: > ERROR: encoding UTF8 does not match locale de_DE@euro > DETAIL: The chosen LC_CTYPE setting requires encoding LATIN9. Yes, that's because FusionForge is a multi-lingual application, and therefore needs an Unicode database (with UTF-8 encoding). This can only be created if the system locale is either C, POSIX, or an UTF-8 locale. When the system locale that has a different encoding (such as Latin-9 in your case), new databases can only be created with that same encoding (see [1] for details). I don't think there's any sane way around that in the FusionForge packaging; your best bet would be to either upgrade your system locale (and database templates) to Unicode-aware, or to create a new dedicated PostgreSQL cluster on a different port, with a Unicode locale. [1] http://www.postgresql.org/docs/current/static/sql-createdatabase.html Roland. -- Roland Mas When you have a hammer in your hand, most things look like a nail. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
