Re: BUG #14285: Chinese locale and windows

--
David Rader
davidr@openscg.com

On Tue, Aug 9, 2016 at 10:23 AM, <nicolas.david@verosoftware.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      14285
> Logged by:          Nicolas David
> Email address:      nicolas.david@verosoftware.com
> PostgreSQL version: 9.2.5
> Operating system:   Windows 10
> Description:
>
> Dear All,
>
> we have a chinese customer that have migrated from Win7 to Win10. It seem=
s
> that the locale 'Chinese (Simplified)_People=E2=80=99s Republic of China.=
936' has
> been renamed to 'Chinese (Simplified)_China.936'.
>
> For this reason, the postgresql service could not start (invalid value fo=
r
> parameters lc_monetary / lc_numeric / lc_time in postgresql.conf).
>
> I changed the value in the postgresql.conf file to use the new locale.
>
> After that the service starts but I cannot get connected to my database. =
I
> get an error message that tell me that LC_COLLATE is 'Chinese
> (Simplified)_People=E2=80=99s Republic of China.936'. A HINT explains tha=
t I should
> re-install the database or add the locale.
>
> How can I manage this situation ?
>
> Because if I re-install, the customer data will be lost and I don't know
> how
> to add this locale.
>
> Thank you for your help.
>
> Best regards
>
>
>
>
This is not a bug, will move to the general mail list.