[Pkg-postgresql-public] Bug#877920: postgresql-common: pg_upgradecluster 9.6 -> 10 fails (locale problem)

Karsten Hilbert karsten.hilbert at gmx.net
Sat Oct 7 09:58:23 UTC 2017

Package: postgresql-common
Version: 186
Severity: important


when upgrading

	Ver Cluster Port Status Owner    Data directory               Log file
	9.6 main    5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log

like so:

	root at hermes:~/bin# pg_upgradecluster 9.6 main

the following happens:

	Use of uninitialized value $ctype in scalar chomp at /usr/share/perl5/PgCommon.pm line 947.
	Use of uninitialized value $collate in scalar chomp at /usr/share/perl5/PgCommon.pm line 948.
	Error: could not get cluster locales
	root at hermes:~/bin#

Anything else I can provide ?


-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'stable-updates'), (500, 'unstable'), (500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 4.13.0-trunk-686-pae (SMP w/2 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE=de_DE.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.116
ii  debconf                   1.5.63
ii  init-system-helpers       1.49
ii  lsb-base                  9.20170808
ii  postgresql-client-common  186
ii  procps                    2:3.3.12-3
ii  ssl-cert                  1.0.39
ii  ucf                       3.0036

Versions of packages postgresql-common recommends:
ii  logrotate  3.11.0-0.1

Versions of packages postgresql-common suggests:
ii  libjson-perl  2.94-1

-- Configuration Files:
/etc/postgresql-common/createcluster.conf changed:
initdb_options = '-k'
ssl = on
cluster_name = '%v/%c'
stats_temp_directory = '/var/run/postgresql/%v-%c.pg_stat_tmp'
log_line_prefix = '%%m [%%p] %%q%%u@%%d '
add_include_dir = 'conf.d'
include_dir '/etc/postgresql-common/createcluster.d'

-- debconf information:
  postgresql-common/ssl: true
* postgresql-common/obsolete-major:

More information about the Pkg-postgresql-public mailing list