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

[Karsten Hilbert]

Thanks for your response !

> could you provide the output of 'psql -l' for the old cluster?

Sure:

	postgres at hermes:~$ psql -l
	Ausgabeformat ist »wrapped«.
	                                  Liste der Datenbanken
	    Name    | Eigentümer | Kodierung | Sortierfolge | Zeichentyp  |  Zugriffsprivilegien
	------------+------------+-----------+--------------+-------------+-----------------------
	 akonadi    | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |
	 gnumed_v20 | gm-dbo     | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |
	 gnumed_v21 | gm-dbo     | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |
	 gnumed_v22 | gm-dbo     | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |
	 orthanc_db | orthanc    | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |
	 postgres   | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |
	 template0  | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | =c/postgres          +
	            |            |           |              |             | postgres=CTc/postgres
	 template1  | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | postgres=CTc/postgres+
	            |            |           |              |             | =c/postgres
	(8 Zeilen)

> Also, please run
> 
>  SHOW lc_ctype;
>  SHOW lc_collate;
> 
> in the old cluster's template1 database.

	postgres at hermes:~$ psql -d template1
	Ausgabeformat ist »wrapped«.
	psql (10.0, Server 9.6.5)
	Geben Sie »help« für Hilfe ein.

	template1=# show lc_ctype;
	  lc_ctype
	-------------
	 de_DE.UTF-8
	(1 Zeile)

	template1=# show lc_collate;
	 lc_collate
	-------------
	 de_DE.UTF-8
	(1 Zeile)

HTH,
Karsten