Your message dated Sun, 4 Sep 2016 18:55:58 +0200
with message-id <[email protected]>
and subject line Re: Bug#660209: initdb doesn't handle C.UTF-8
has caused the Debian Bug report #660209,
regarding set_system_locale(); doesn't work with locales-all
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
660209: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=660209
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-9.1
Version: 9.1.2-1
initdb does misdetect C.UTF-8 as C (ascii) and populates postgresql.conf
wrongly, resulting that by default, all newly created dbs have ascii
rather than UTF-8 as encoding.
This also affects all other postgresql-* versions packaged in debian.
--
Address: Daniel Baumann, Donnerbuehlweg 3, CH-3012 Bern
Email: [email protected]
Internet: http://people.progress-technologies.net/~daniel.baumann/
--- End Message ---
--- Begin Message ---
Re: Daniel Baumann 2015-09-07 <[email protected]>
> retitle 660209 initdb doesn't work with locales-all
> thanks
>
> Hi,
>
> the problem is still there. the reason for it is that initdb looks for
> /etc/default/locale rather than $LANG or $LC_*.
>
> This has the effect that on a proper system using locales-all, where
> /etc/default/locale does not exist, all DBs are always created with
> SQL_ASCII instead of UTF8 albeit the system is using en_US.UTF-8 (or
> C.UTF-8) and LANG/LC_ALL are properly set.
Hi,
I think you are conflating two different issues here:
1) the initial cluster that is created when "apt-get install
postgresql" is run doesn't use LANG/LC_ALL, but whatever the system
locale is (which is defined by /etc/default/locale and
/etc/environment). I believe the issue you have been seeing is due to
misunderstanding this.
2) if no system locale is found, pg_createcluster (or rather the code
in maintscript-functions) falls back to C. This will be changed to
C.UTF-8 as part of the upcoming fix for #790507.
Christoph
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
