Upgrade 8.4.22 to 9.2 - LC_Collate differs

From: Not A Scientist <notascientist0049(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Upgrade 8.4.22 to 9.2 - LC_Collate differs
Date: 2018-01-31 08:47:37
Message-ID: CAJ9OPxGtL90sYfk506RxAH0-T760QuMfL5v2oUnT3JXfPpPi9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I experienced an earlier reported 'bug' described in BUG #15038.
My DB upgrade cancels because lc_collate differs between the versions.

Unfortunately I cannot find a way to initialize a 8.4 DB with locale
"German_Germany.1252" and neither one to initialize a 9.2 DB with locale
"German, Germany".

I'm pretty new to postgreSQL and I ain't got a clue how to fix this issue
since it makes a clean DB upgrade impossible for me.

Does anyone have an idea how to fix this?

Cheers,

Browse pgsql-novice by date

  From Date Subject
Next Message David Rowley 2018-02-01 06:26:02 Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Previous Message David G. Johnston 2018-01-30 01:14:54 Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?