[Pkg-postgresql-public] Bug#784956: postgresql can't start when fallback to C locale

[Pirate Praveen]

package: postgresql
version: 9.4+165

This happens when default locale is set to 'None' (en_IN without en_IN
locale in the system).

root at pod:~# dpkg-reconfigure locales
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
	LANGUAGE = (unset),
	LC_ALL = (unset),
	LC_PAPER = "en_IN.utf8",
	LC_MONETARY = "en_IN.utf8",
	LC_NUMERIC = "en_IN.utf8",
	LC_MEASUREMENT = "en_IN.utf8",
	LC_TIME = "en_IN.utf8",
	LANG = "en_IN"

# pg_createcluster 9.4 main --start succeeds after en_IN is generated.
root at pod:~# pg_createcluster 9.4 main --start
Creating new cluster 9.4/main ...
  config /etc/postgresql/9.4/main
  data   /var/lib/postgresql/9.4/main
  locale en_IN
Flags of /var/lib/postgresql/9.4/main set as -------------e-C
could not change directory to "/root": Permission denied
  port   5432

original error:

locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
Setting up postgresql-common (165) ...
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
Adding user postgres to group ssl-cert

Creating config file /etc/postgresql-common/createcluster.conf with new
version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
insserv: warning: script 'wide-dhcpv6-client' missing LSB tags and overrides
[warn] No PostgreSQL clusters exist; see "man pg_createcluster" ...
(warning).
Setting up postgresql-9.4 (9.4.1-1) ...
Error: The locale requested by the environment is invalid.
Error: could not create default cluster. Please create it manually with

  pg_createcluster 9.4 main --start

or a similar command (see 'man pg_createcluster').
update-alternatives: using
/usr/share/postgresql/9.4/man/man1/postmaster.1.gz to provide
/usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
[warn] No PostgreSQL clusters exist; see "man pg_createcluster" ...
(warning).

I think this is an issue with perl, but I think falling back to C locale
should work.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20150511/00ab626e/attachment.sig>