Обсуждение: BUG #14285: Chinese locale and windows
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI4NQpMb2dnZWQgYnk6ICAg ICAgICAgIE5pY29sYXMgRGF2aWQKRW1haWwgYWRkcmVzczogICAgICBuaWNv bGFzLmRhdmlkQHZlcm9zb2Z0d2FyZS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiA5LjIuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgMTAKRGVzY3Jp cHRpb246ICAgICAgICAKCkRlYXIgQWxsLA0KDQp3ZSBoYXZlIGEgY2hpbmVz ZSBjdXN0b21lciB0aGF0IGhhdmUgbWlncmF0ZWQgZnJvbSBXaW43IHRvIFdp bjEwLiBJdCBzZWVtcwp0aGF0IHRoZSBsb2NhbGUgJ0NoaW5lc2UgKFNpbXBs aWZpZWQpX1Blb3BsZeKAmXMgUmVwdWJsaWMgb2YgQ2hpbmEuOTM2JyBoYXMK YmVlbiByZW5hbWVkIHRvICdDaGluZXNlIChTaW1wbGlmaWVkKV9DaGluYS45 MzYnLg0KDQpGb3IgdGhpcyByZWFzb24sIHRoZSBwb3N0Z3Jlc3FsIHNlcnZp Y2UgY291bGQgbm90IHN0YXJ0IChpbnZhbGlkIHZhbHVlIGZvcgpwYXJhbWV0 ZXJzIGxjX21vbmV0YXJ5IC8gbGNfbnVtZXJpYyAvIGxjX3RpbWUgaW4gcG9z dGdyZXNxbC5jb25mKS4NCg0KSSBjaGFuZ2VkIHRoZSB2YWx1ZSBpbiB0aGUg cG9zdGdyZXNxbC5jb25mIGZpbGUgdG8gdXNlIHRoZSBuZXcgbG9jYWxlLiAN Cg0KQWZ0ZXIgdGhhdCB0aGUgc2VydmljZSBzdGFydHMgYnV0IEkgY2Fubm90 IGdldCBjb25uZWN0ZWQgdG8gbXkgZGF0YWJhc2UuIEkKZ2V0IGFuIGVycm9y IG1lc3NhZ2UgdGhhdCB0ZWxsIG1lIHRoYXQgTENfQ09MTEFURSBpcyAnQ2hp bmVzZQooU2ltcGxpZmllZClfUGVvcGxl4oCZcyBSZXB1YmxpYyBvZiBDaGlu YS45MzYnLiBBIEhJTlQgZXhwbGFpbnMgdGhhdCBJIHNob3VsZApyZS1pbnN0 YWxsIHRoZSBkYXRhYmFzZSBvciBhZGQgdGhlIGxvY2FsZS4gDQoNCkhvdyBj YW4gSSBtYW5hZ2UgdGhpcyBzaXR1YXRpb24gPw0KDQpCZWNhdXNlIGlmIEkg cmUtaW5zdGFsbCwgdGhlIGN1c3RvbWVyIGRhdGEgd2lsbCBiZSBsb3N0IGFu ZCBJIGRvbid0IGtub3cgaG93CnRvIGFkZCB0aGlzIGxvY2FsZS4NCg0KVGhh bmsgeW91IGZvciB5b3VyIGhlbHAuDQoNCkJlc3QgcmVnYXJkcw0KICAgICAg ICAgICAgDQogICAgICAgICAgICAgICANCg0KCgo=
-- 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.