BUG #15038: Upgrade 8.4 to 9.2 - LC_Collate differs

Started by PG Bug reporting formabout 8 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 15038
Logged by: Dominic
Email address: d.huelsen@awo-dortmund.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!

#2Greg Clough
greg.clough@ipreo.com
In reply to: PG Bug reporting form (#1)
RE: BUG #15038: Upgrade 8.4 to 9.2 - LC_Collate differs

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.

Hi Dominic,

Support for PostgreSQL v9.2 ended in September 2017:

https://www.postgresql.org/support/versioning/

Also, it's listed with a warning icon on the Confluence Supported Platforms documentation, so they don't recommend it either:

https://confluence.atlassian.com/doc/supported-platforms-207488198.html

I would strongly recommend that you upgrade to PostgreSQL v9.6, which is the latest version supported by both the PostgreSQL community and Confluence.

Regards,
Greg Clough
Senior Technology Engineer
O | +44 (0) 20 7665 9787
M | +44 (0) 7803 142 292

Ipreo
Castle House | 37-35 Paul St | London EC2A 4LS