Thanks for your response !
> could you provide the output of 'psql -l' for the old cluster?
Sure:
postgres@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@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
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
