[Pkg-postgresql-public] Bug#791526: Bug#791526: postgresql-9.4: postgresql needs locales-all to create cluster on install

Malte malte at wk3.org
Tue Jul 7 17:41:39 UTC 2015 

Hi,

here are the outputs for locales and the installation procedures with apt-get 
and aptitude (as I have seen differenct behaviours in those two in the past as 
well). The installations were prepared by purging all postgresql* packages and 
rm -rf /etc/postg* /var/lib/postg*.

###
# locale
LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=en_US.UTF-8


###
# cat /etc/default/locale
#  File generated by update-locale
LANG=en_US.UTF-8


###
# apt-get install postgresql-9.4
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  cron libpopt0 libpq5 logrotate lsb-release postgresql-client-9.4 postgresql-
client-common
  postgresql-common ucf
Suggested packages:
  anacron checksecurity lsb oidentd ident-server locales-all postgresql-
doc-9.4
The following NEW packages will be installed:
  cron libpopt0 libpq5 logrotate lsb-release postgresql-9.4 postgresql-
client-9.4
  postgresql-client-common postgresql-common ucf
0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded.
Need to get 5,170 kB/5,462 kB of archives.
After this operation, 25.2 MB of additional disk space will be used.
Do you want to continue? [Y/n] 
Get:1 http://http.debian.net/debian/ jessie/main libpq5 amd64 9.4.3-0+deb8u1 
[122 kB]
Get:2 http://http.debian.net/debian/ jessie/main postgresql-client-common all 
165 [73.3 kB]
Get:3 http://http.debian.net/debian/ jessie/main postgresql-client-9.4 amd64 
9.4.3-0+deb8u1 [1,072 kB]
Get:4 http://http.debian.net/debian/ jessie/main postgresql-common all 165 
[202 kB]
Get:5 http://http.debian.net/debian/ jessie/main postgresql-9.4 amd64 
9.4.3-0+deb8u1 [3,702 kB]
Fetched 5,170 kB in 17s (291 kB/s)                                                                        
debconf: delaying package configuration, since apt-utils is not installed
Selecting previously unselected package cron.
(Reading database ... 17149 files and directories currently installed.)
Preparing to unpack .../cron_3.0pl1-127_amd64.deb ...
Unpacking cron (3.0pl1-127) ...
Selecting previously unselected package libpopt0:amd64.
Preparing to unpack .../libpopt0_1.16-10_amd64.deb ...
Unpacking libpopt0:amd64 (1.16-10) ...
Selecting previously unselected package libpq5:amd64.
Preparing to unpack .../libpq5_9.4.3-0+deb8u1_amd64.deb ...
Unpacking libpq5:amd64 (9.4.3-0+deb8u1) ...
Selecting previously unselected package logrotate.
Preparing to unpack .../logrotate_3.8.7-1+b1_amd64.deb ...
Unpacking logrotate (3.8.7-1+b1) ...
Selecting previously unselected package ucf.
Preparing to unpack .../archives/ucf_3.0030_all.deb ...
Moving old data out of the way
Unpacking ucf (3.0030) ...
Selecting previously unselected package lsb-release.
Preparing to unpack .../lsb-release_4.1+Debian13+nmu1_all.deb ...
Unpacking lsb-release (4.1+Debian13+nmu1) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../postgresql-client-common_165_all.deb ...
Unpacking postgresql-client-common (165) ...
Selecting previously unselected package postgresql-client-9.4.
Preparing to unpack .../postgresql-client-9.4_9.4.3-0+deb8u1_amd64.deb ...
Unpacking postgresql-client-9.4 (9.4.3-0+deb8u1) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_165_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by 
postgresql-common'
Unpacking postgresql-common (165) ...
Selecting previously unselected package postgresql-9.4.
Preparing to unpack .../postgresql-9.4_9.4.3-0+deb8u1_amd64.deb ...
Unpacking postgresql-9.4 (9.4.3-0+deb8u1) ...
Processing triggers for systemd (215-17+deb8u1) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up cron (3.0pl1-127) ...
update-rc.d: warning: start and stop actions are no longer supported; falling 
back to defaults
Setting up libpopt0:amd64 (1.16-10) ...
Setting up libpq5:amd64 (9.4.3-0+deb8u1) ...
Setting up logrotate (3.8.7-1+b1) ...
Setting up ucf (3.0030) ...
Setting up lsb-release (4.1+Debian13+nmu1) ...
Setting up postgresql-client-common (165) ...
Setting up postgresql-client-9.4 (9.4.3-0+deb8u1) ...
update-alternatives: using /usr/share/postgresql/9.4/man/man1/psql.1.gz to 
provide /usr/share/man/man1/psql
.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (165) ...

Creating config file /etc/postgresql-common/createcluster.conf with new 
version

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Setting up postgresql-9.4 (9.4.3-0+deb8u1) ...
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/man
1/postmaster.1.gz (postmaster.1.gz) in auto mode
Processing triggers for libc-bin (2.19-18) ...
Processing triggers for systemd (215-17+deb8u1) ...


###
# aptitude install postgresql-9.4                                                          
The following NEW packages will be installed:
  cron{a} libpopt0{a} libpq5{a} logrotate{a} lsb-release{a} postgresql-9.4 
postgresql-client-9.4{a} 
  postgresql-client-common{a} postgresql-common{a} ucf{a} 
0 packages upgraded, 10 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/5,462 kB of archives. After unpacking 25.2 MB will be used.
Do you want to continue? [Y/n/?] 
debconf: delaying package configuration, since apt-utils is not installed
Selecting previously unselected package cron.
(Reading database ... 17149 files and directories currently installed.)
Preparing to unpack .../cron_3.0pl1-127_amd64.deb ...
Unpacking cron (3.0pl1-127) ...
Selecting previously unselected package libpopt0:amd64.
Preparing to unpack .../libpopt0_1.16-10_amd64.deb ...
Unpacking libpopt0:amd64 (1.16-10) ...
Selecting previously unselected package libpq5:amd64.
Preparing to unpack .../libpq5_9.4.3-0+deb8u1_amd64.deb ...
Unpacking libpq5:amd64 (9.4.3-0+deb8u1) ...
Selecting previously unselected package logrotate.
Preparing to unpack .../logrotate_3.8.7-1+b1_amd64.deb ...
Unpacking logrotate (3.8.7-1+b1) ...
Selecting previously unselected package ucf.
Preparing to unpack .../archives/ucf_3.0030_all.deb ...
Moving old data out of the way
Unpacking ucf (3.0030) ...
Selecting previously unselected package lsb-release.
Preparing to unpack .../lsb-release_4.1+Debian13+nmu1_all.deb ...
Unpacking lsb-release (4.1+Debian13+nmu1) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../postgresql-client-common_165_all.deb ...
Unpacking postgresql-client-common (165) ...
Selecting previously unselected package postgresql-client-9.4.
Preparing to unpack .../postgresql-client-9.4_9.4.3-0+deb8u1_amd64.deb ...
Unpacking postgresql-client-9.4 (9.4.3-0+deb8u1) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_165_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by 
postgresql-common'
Unpacking postgresql-common (165) ...
Selecting previously unselected package postgresql-9.4.
Preparing to unpack .../postgresql-9.4_9.4.3-0+deb8u1_amd64.deb ...
Unpacking postgresql-9.4 (9.4.3-0+deb8u1) ...
Processing triggers for systemd (215-17+deb8u1) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up cron (3.0pl1-127) ...
update-rc.d: warning: start and stop actions are no longer supported; falling 
back to defaults
Setting up libpopt0:amd64 (1.16-10) ...
Setting up libpq5:amd64 (9.4.3-0+deb8u1) ...
Setting up logrotate (3.8.7-1+b1) ...
Setting up ucf (3.0030) ...
Setting up lsb-release (4.1+Debian13+nmu1) ...
Setting up postgresql-client-common (165) ...
Setting up postgresql-client-9.4 (9.4.3-0+deb8u1) ...
update-alternatives: using /usr/share/postgresql/9.4/man/man1/psql.1.gz to 
provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (165) ...

Creating config file /etc/postgresql-common/createcluster.conf with new 
version

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Setting up postgresql-9.4 (9.4.3-0+deb8u1) ...
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
Processing triggers for libc-bin (2.19-18) ...
Processing triggers for systemd (215-17+deb8u1) ...



Sincerely,

Malte

More information about the Pkg-postgresql-public mailing list