Hello,
when using the following command on PostgreSQL 9.6 on a SLES Linux
machine
pg_dump -h machine1 -C
the output contains this line
CREATE DATABASE db1 WITH TEMPLATE = template0 ENCODING = 'UTF8'
LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
which causes trouble on a PostgreSQL 10 or 11 on an Ubuntu 18.04 machine
ungültiger Locale-Name: »en_US.UTF-8« (meaning 'illegal locale name')
The command
select * from pg_collation;
shows (among many others of course)
en_US.utf8
But even removing the hyphen in 'en_US.UTF-8' and converting 'UTF' to
lower case doesn't remove the error.
How come there are encodings/collations/locales with and without hyphen?
Why does the Ubuntu machine not accept a locale which is present in
lc_collation?
Best Regards,
Holger
--
Holger Jakobs, 51469 Bergisch Gladbach
+49 178 9759012
