From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | d(dot)huelsen(at)awo-dortmund(dot)de |
Subject: | BUG #15038: Upgrade 8.4 to 9.2 - LC_Collate differs |
Date: | 2018-01-31 08:30:40 |
Message-ID: | 151738744070.1244.16944109485578506439@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15038
Logged by: Dominic
Email address: d(dot)huelsen(at)awo-dortmund(dot)de
PostgreSQL version: Unsupported/Unknown
Operating system: Windows Server 2016
Description:
Hi folks,
I need to upgrade an old Atlassian Confluence system which is using a
postgreSQL DB (8.4.22).
Since the newer version doesn't support v8.4.22 anymore, I need to upgrade
the database to 9.2.
I setup a test environment with the same DB version and got it running. If I
try to upgrade using pg_upgrade I experience an error, pointing towards
different lc_collate values.
In 8.4 it's "German, Germany" while in 9.2 the value says
"German_Germany.1252".
The bug is also described in BUG #14734.
I couldn't find any fixes for this.
I cannot create a 8.4 DB with "German_Germany.1252" and neither a 9.2 DB
with "German, Germany".
Anyone got a clue how to fix this?
Cheers!
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Clough | 2018-01-31 09:45:19 | RE: BUG #15038: Upgrade 8.4 to 9.2 - LC_Collate differs |
Previous Message | Michael Paquier | 2018-01-30 23:08:07 | Re: BUG #15035: scram-sha-256 blocks all logins |