pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
lc_collate mess
2+ messages / 2 participants
[nested] [flat]

* lc_collate mess
@ 2020-11-22 13:31  Susanne & Udo Krause <su.krause@bluewin.ch>
  0 siblings, 1 reply; 2+ messages in thread

From: Susanne & Udo Krause @ 2020-11-22 13:31 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org

Hi there,


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.

Previous migration vom PostgreSQL 9 to PostgreSQL 12 was a messy 
nightmare, still not okay.


Thanks in advance

Udo.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: lc_collate mess
@ 2020-11-23 07:05  Heikki Linnakangas <hlinnaka@iki.fi>
  parent: Susanne & Udo Krause <su.krause@bluewin.ch>
  0 siblings, 0 replies; 2+ messages in thread

From: Heikki Linnakangas @ 2020-11-23 07:05 UTC (permalink / raw)
  To: Susanne & Udo Krause <su.krause@bluewin.ch>; pgsql-bugs@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-11-23 07:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-22 13:31 lc_collate mess Susanne & Udo Krause <su.krause@bluewin.ch>
2020-11-23 07:05 ` Heikki Linnakangas <hlinnaka@iki.fi>

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