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

Karsten Hilbert Karsten.Hilbert at gmx.net
Sat Oct 7 13:21:23 UTC 2017

On Sat, Oct 07, 2017 at 02:11:14PM +0200, Christoph Berg wrote:

> > 	postgres at hermes:~$ psql -d template1
> > 	Ausgabeformat ist »wrapped«.
> PgCommon.pm doesn't use 'psql -X' so your (or postgres') .psqlrc might
> be getting in the way. Could you try the upgrade again after moving
> .psqlrc away, or (better) adding an 'X' to PgCommon.pm lines 935 and
> 939?
> open PSQL, '-|', $psql, '-h', $socketdir, '-p', $port, '-XAtc',


	root at hermes:/usr/share/perl5# pg_upgradecluster 9.6 main
	de_DE.UTF-8 / de_DE.UTF-8
	Error: could not get cluster locales

I also added a print statement:

    chomp $ctype;
    chomp $collate;
    print STDERR "$ctype / $collate\n";
    return ($ctype, $collate) unless $?;
    return (undef, undef);

which produces the 

	de_DE.UTF-8 / de_DE.UTF-8


What else can I do ?

GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

More information about the Pkg-postgresql-public mailing list