pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04
3+ messages / 3 participants
[nested] [flat]
* pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04
@ 2017-12-23 09:36 Rob Hills <rhills@medimorphosis.com.au>
2018-01-04 18:40 ` Re: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04 Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 3+ messages in thread
From: Rob Hills @ 2017-12-23 09:36 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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@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@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04
2017-12-23 09:36 pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04 Rob Hills <rhills@medimorphosis.com.au>
@ 2018-01-04 18:40 ` Bruce Momjian <bruce@momjian.us>
2018-01-04 18:59 ` Re: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04 Ibrahim Edib Kokdemir <kokdemir@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Bruce Momjian @ 2018-01-04 18:40 UTC (permalink / raw)
To: Rob Hills <rhills@medimorphosis.com.au>; +Cc: pgsql-admin@lists.postgresql.org
On Sat, Dec 23, 2017 at 05:36:45PM +0800, Rob Hills wrote:
> 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?
Since this bug looks to be in the pg_upgradecluster script, my only
suggestion would be to run pg_upgrade manually.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04
2017-12-23 09:36 pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04 Rob Hills <rhills@medimorphosis.com.au>
2018-01-04 18:40 ` Re: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04 Bruce Momjian <bruce@momjian.us>
@ 2018-01-04 18:59 ` Ibrahim Edib Kokdemir <kokdemir@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Ibrahim Edib Kokdemir @ 2018-01-04 18:59 UTC (permalink / raw)
To: rhills@medimorphosis.com.au; pgsql-admin@lists.postgresql.org
> Is there anything else I can do to try and work out what's causing the
problem and get my cluster upgraded?
Sometimes, in Ubuntu systems, if ssh login user's locale is different, it
may happen.
After login, make "sudo su -" and try again as a root. It may help.
2018-01-04 21:40 GMT+03:00 Bruce Momjian <bruce@momjian.us>:
> On Sat, Dec 23, 2017 at 05:36:45PM +0800, Rob Hills wrote:
> > 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?
>
> Since this bug looks to be in the pg_upgradecluster script, my only
> suggestion would be to run pg_upgrade manually.
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + As you are, so once was I. As I am, so you will be. +
> + Ancient Roman grave inscription +
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-01-04 18:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-12-23 09:36 pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04 Rob Hills <rhills@medimorphosis.com.au>
2018-01-04 18:40 ` Bruce Momjian <bruce@momjian.us>
2018-01-04 18:59 ` Ibrahim Edib Kokdemir <kokdemir@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox