Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kh5vI-0001fq-KP for pgsql-bugs@arkaria.postgresql.org; Mon, 23 Nov 2020 07:06:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kh5vF-0005Ji-5w for pgsql-bugs@arkaria.postgresql.org; Mon, 23 Nov 2020 07:06:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kh5vE-0005JP-SL for pgsql-bugs@lists.postgresql.org; Mon, 23 Nov 2020 07:06:01 +0000 Received: from meesny.iki.fi ([195.140.195.201]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kh5vA-0004NM-JD for pgsql-bugs@lists.postgresql.org; Mon, 23 Nov 2020 07:06:00 +0000 Received: from [192.168.1.113] (dsl-hkibng22-54faa4-119.dhcp.inet.fi [84.250.164.119]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by meesny.iki.fi (Postfix) with ESMTPSA id 138CE203AD; Mon, 23 Nov 2020 09:05:52 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1606115152; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=coCFYKMJ6gOcGlEjLgqLejsWd9qizYV+wQSL2AKpc1w=; b=wg/q0RPOqA8xt2AgQfcTPjW++hfal732vkdjRkMWE2m4Zy5FEg63b+H1spAl39lPlHR8AN HkHtDxWI5/LySRym0Qpwodoks0jqH9loyL+tOzC2ZsDu/OAKr9LN6liLOD4Jb9PEXBSQIB g1lEUnm9ntacJgPgIBB4z+HqvnUMWc8= Subject: Re: lc_collate mess To: Susanne & Udo Krause , pgsql-bugs@lists.postgresql.org References: <9120334a-61f8-b801-cbc2-0ccc92282973@bluewin.ch> From: Heikki Linnakangas Message-ID: <29d8f00e-eb74-db6e-e4c3-0a3b26689f3b@iki.fi> Date: Mon, 23 Nov 2020 09:05:51 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.4.0 MIME-Version: 1.0 In-Reply-To: <9120334a-61f8-b801-cbc2-0ccc92282973@bluewin.ch> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1606115152; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=coCFYKMJ6gOcGlEjLgqLejsWd9qizYV+wQSL2AKpc1w=; b=j5hSfyULXCca6cdksEUhwokgm/hpml+A/sv4FWqmyQI+2Qjv1xDai1ShjKI7VWR7+ly9Zv QtRvcVM0NNoC2Dl2hEO7j3yaWxIpFziWf1YeCMHCtoZyQke4+Ydj6BEhP510Pd8wOpkCpy +0FMBEcBw/VWkG5g8UsE6ibSqbZhUPU= ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Seal: i=1; s=meesny; d=iki.fi; t=1606115152; a=rsa-sha256; cv=none; b=S7uS0nv0z6emxlgSBUK74QLGs7vSNCTgf92W0WDA3Y7oo1nNTCp97ADOqldi6a+HY1r5Bo xccSwDZCqxbDJsqnEN6JObgchRfYLCJrcOZ0svd5oyEYo+HY4uMttzr0a96SipFG0pvdpx c7yvwzauD8rMN2Qvod9Mxl3ClsHWZFQ= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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