pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04

From: Rob Hills <rhills(at)medimorphosis(dot)com(dot)au>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04
Date: 2017-12-23 09:36:45
Message-ID: 1c03aa8c-529e-ecaf-550c-ee8a0db28073@medimorphosis.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Today I upgraded from Ubuntu 16.04 LTS to 17.04 which forced a
Postgresql upgrade from 9.5.10 to 9.6.6.

I followed the instructions specified during the Ubuntu upgrade:

sudo pg_dropcluster --stop 9.6 main
sudo pg_upgradecluster 9.5 main

The pg_dropcluster completed without any issues. pg_upgradecluster
failed with the following:

rob(at)robs-zenbook-3:~$ sudo pg_upgradecluster 9.5 main
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Redirecting start request to systemctl
psql: FATAL:  the database system is starting up
psql: FATAL:  the database system is starting up
Use of uninitialized value $out in pattern match (m//) at
/usr/share/perl5/PgCommon.pm line 944.
psql: FATAL:  the database system is starting up
Use of uninitialized value $out in pattern match (m//) at
/usr/share/perl5/PgCommon.pm line 950.
Use of uninitialized value $ctype in scalar chomp at
/usr/share/perl5/PgCommon.pm line 953.
Use of uninitialized value $collate in scalar chomp at
/usr/share/perl5/PgCommon.pm line 954.
Error: could not get cluster locales

In case it makes a difference, here's the output from my "locale" command:

rob(at)robs-zenbook-3:~$ locale
LANG=en_AU.UTF-8
LANGUAGE=en_AU:en
LC_CTYPE="en_AU.UTF-8"
LC_NUMERIC="en_AU.UTF-8"
LC_TIME="en_AU.UTF-8"
LC_COLLATE="en_AU.UTF-8"
LC_MONETARY="en_AU.UTF-8"
LC_MESSAGES="en_AU.UTF-8"
LC_PAPER="en_AU.UTF-8"
LC_NAME="en_AU.UTF-8"
LC_ADDRESS="en_AU.UTF-8"
LC_TELEPHONE="en_AU.UTF-8"
LC_MEASUREMENT="en_AU.UTF-8"
LC_IDENTIFICATION="en_AU.UTF-8"
LC_ALL=

I tried specifying a locale in the pg_upgradecluster command but got the
same error as previously:

sudo pg_upgradecluster --locale=en_AU.UTF-8 9.5 main

I've found some threads discussing this specific issue, but none of them
really identify the cause or provide any workaround.

Is there anything else I can do to try and work out what's causing the
problem and get my cluster upgraded?

TIA,

--
Rob Hills
Waikiki, Western Australia

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Günce Kaya 2017-12-23 10:55:20 Log File Size
Previous Message Scott Whitney 2017-12-22 21:40:32 Re: Database file compatibility between OS