[Pkg-postgresql-public] Bug#700271: postgresql-9.1: non-obvious choice of database locale

[Helmut Grohne]

Package: postgresql-9.1
Version: 9.1.7-1
Severity: wishlist

I am a fairly novice postgresql user, so I was just installing
postgresql-9.1 without any knowledge about database locale and how it
can go wrong. The installation procedure determined that LATIN1 would be
a perfect choice for my system, which lead to a number of problems later
on.

Given the number of issues that arise when using a non-UTF8 locale for
databases I suggest defaulting the locale to UTF8 and ignoring
environment variables used during installation and/or creating a
priority low debconf prompt for this.

Here is a list of problems which seem related.

#660209
#699453
https://www.blog.akendo.eu/debian-postgresql-8-4-cant-create-database-with-utf-8-encoding/
http://jacobian.org/writing/pg-encoding-ubuntu/

Feel free to disagree with me. In that case wontfix is your tag.

Helmut