Database locale is incompatible with operation system

From: Bjørn-Willy Arntzen <bwa(at)klp(dot)no>
To: "pgsql-in-general(at)postgresql(dot)org" <pgsql-in-general(at)postgresql(dot)org>
Subject: Database locale is incompatible with operation system
Date: 2015-08-06 14:49:20
Message-ID: 7a3d3c25f5aa46db8b41f94058ed5e6f@ExMail1KLP.klp.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-general

Hello all.

I upgraded my Windows 7 server til Windows 10 today, and ran into this message when trying to access my postgres 9.2 database

Database locale is incompatible with operation system.
DETAIL The database was initialized with LC_COLLATE "Norwegian (Bokmål)_Norway.1252", which is not recognized by setLocale()

My Windows 10 systeminfo is reporting:

System Locale: no;Norsk (bokmål)

So my locale is Norway, but somehow it's not recognized my postgres ?

How can I fix this ?
Med vennlig hilsen / Regards from

Bjørn-Willy Arntzen
Seniorkonsulent IT
Kommunal Landspensjonskasse gjensidig forsikringsselskap
Dronning Eufemias gate 10, 0191 Oslo, Pb 400, Sentrum, 0103 Oslo
Mob: +4797759007
www.klp.no<http://www.klp.no/>

Vennligst tenk på miljøet før du skriver ut denne e-posten

Browse pgsql-in-general by date

  From Date Subject
Next Message phiroc 2015-09-01 08:48:06 Making a column serial in pgAdmin III
Previous Message Michele Bosi 2015-04-16 10:12:29 Re: Result set stability in queries sorted by column with non-unique values