[Pkg-postgresql-public] Bug#790507: pg_createcluster should default to UTF8 clusters, not SQL_ASCII

Diederik de Haas didi.debian at cknow.org
Thu Mar 10 05:11:40 UTC 2016

Package: postgresql-common
Version: 172
Followup-For: Bug #790507

I want to give this bug a BIG +1

I have 2 locales installed (en_US.UTF-8 and nl_NL.UTF-8) but have chosen
to not set a system-wide default locale.
The result was that all the databases were created with SQL_ASCII ...
and I find that rather disappointing.
After purging everything and setting a default locate (C.UTF-8) and
reinstalling postgresql again, the databases were created with UTF8.

I don't know whether this change or a configuration error somewhere else
but the difference was absolute HUGE when used with Akonadi/KDEPIM from
experimental. I'm talking about FAST versus unworkable slow.

Going by the email address of the original reporter, raising the
severity seems to be in order, but I'll leave that up to the maintainer.


-- System Information:
Debian Release: stretch/sid
  APT prefers unstable-debug
  APT policy: (500, 'unstable-debug'), (500, 'unstable'), (500, 'testing'), (101, 'experimental'), (1, 'experimental-debug')
Architecture: amd64 (x86_64)
Foreign Architectures: i386, armhf

Kernel: Linux 4.4.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages postgresql-common depends on:
ii  adduser                   3.113+nmu3
ii  debconf [debconf-2.0]     1.5.58
ii  init-system-helpers       1.29
ii  lsb-base                  9.20160110
ii  postgresql-client-common  172
ii  procps                    2:3.3.11-3
ii  ssl-cert                  1.0.37
ii  ucf                       3.0035

Versions of packages postgresql-common recommends:
ii  logrotate  3.8.7-2

postgresql-common suggests no packages.

-- debconf information:
  postgresql-common/ssl: true

More information about the Pkg-postgresql-public mailing list