From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Susanne & Udo Krause <su.krause@bluewin.ch>
To: pgsql-bugs@lists.postgresql.org
Subject: Re: lc_collate mess
Date: Mon, 23 Nov 2020 09:05:51 +0200
Message-ID: <29d8f00e-eb74-db6e-e4c3-0a3b26689f3b@iki.fi> (raw)
In-Reply-To: <9120334a-61f8-b801-cbc2-0ccc92282973@bluewin.ch>
References: <9120334a-61f8-b801-cbc2-0ccc92282973@bluewin.ch>
On 22/11/2020 15:31, Susanne & Udo Krause wrote:
> the new PostgreSQL has been created from scratch by standard
> installation with German_Switzerland, then it does not know:
>
> ------------------------------------------------------------------------
>
> C:\Users\postgres\Documents>pg_upgrade.exe --old-datadir "C:/Program
> Files/PostgreSQL/12/data" --new-datadir "C:/Program
> Files/PostgreSQL/13/data" --old-bindir "C:/Program
> Files/PostgreSQL/12/bin" --new-bindir "C:/Program
> Files/PostgreSQL/13/bin" --check
> Führe Konsistenzprüfungen durch
> -------------------------------
> Checking cluster versions ok
> Checking database user is the install user ok
> Checking database connection settings ok
> Checking for prepared transactions ok
> Checking for reg* data types in user tables ok
> Checking for contrib/isn with bigint-passing mismatch ok
>
> lc_collate-Werte für Datenbank »postgres« stimmen nicht überein: alt
> »German_Switzerland.1252«, neu »German_Germany.1252«
> Fehlgeschlagen, Programm wird beendet
>
> C:\Users\postgres\Documents>
>
> ------------------------------------------------------------------------
>
>
> where is a hint how to fix that? New PostgreSQL did not yet start up, of
> course.
The error message suggests that the old database was initialized with
"German_Switzerland.1252" locale, and the new one with
"German_Germany.1252". The new database needs to initialized with the
same locale as the old one for pg_upgrade to work. Make sure you select
""German_Switzerland.1252" in the PostgreSQL 13 installer.
Or you can re-initialize the datadir after installing PostgreSQL with
something like:
initdb -D "C:/Program Files/PostgreSQL/13/data"
--locale="German_Switzerland.1252"
- Heikki
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: hlinnaka@iki.fi, su.krause@bluewin.ch, pgsql-bugs@lists.postgresql.org
Subject: Re: lc_collate mess
In-Reply-To: <29d8f00e-eb74-db6e-e4c3-0a3b26689f3b@iki.fi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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