Обсуждение: PostgreSQL on Korean Windows Server 2008 R2 Standard
SGkgVGVhbSwNCg0KVGhpcyBpcyBteSBmaXJzdCBldmVyIGludGVyYWN0aW9uIHdpdGggUG9zdGdy ZVNRTCB0ZWFtLiBQbGVhc2UgcG9pbnQgbWUgdG8gYXBwcm9wcmlhdGUgbWFpbGluZyBsaXN0IGlu IGNhc2UgSaGvbSBub3QgYXBwcm9hY2hpbmcgdGhlIGNvcnJlY3Qgb25lLg0KDQpBIGRlc2NyaXB0 aW9uIG9mIHdoYXQgeW91IGFyZSB0cnlpbmcgdG8gYWNoaWV2ZSBhbmQgd2hhdCByZXN1bHRzIHlv dSBleHBlY3QuOg0KSSBhbSBkZXZlbG9waW5nIGEgamF2YSBiYXNlZCBpbnN0YWxsZXIgd2hpY2gg aW50ZXJuYWxseSBpbnN0YWxscyBQb3N0Z3JlU1FMIGRhdGFiYXNlIGJpbmFyaWVzLiBXaXRoIFBv c3RncmVTUUwgOS4zIGluc3RhbGxhdGlvbiB1c2UgdG8gY29tcGxldGUgc3VjY2Vzc2Z1bGx5Lg0K U29tZXRpbWVzIGJhY2sgd2UgdXBncmFkZWQgdGhlIFBvc3RncmVTUUwgZGF0YWJhc2UgdG8gOS40 LjQgYW5kIG5vdyBpbnN0YWxsYXRpb24gaXMgcGFydGljdWxhcmx5IGZhaWxpbmcgb24gS29yZWFu IHN5c3RlbXMgd2l0aCBlcnJvciChsEZBVEFMOiAgY2Fubm90IHBlcmZvcm0gZW5jb2RpbmcgY29u dmVyc2lvbiBvdXRzaWRlIGEgdHJhbnNhY3Rpb26hsS4gVGhpcyBpcyBleGFjdGx5IGFzIG1lbnRp b25lZCBpbiByZXNwb25zZSB0byBCVUcgIzEzNDI3ICBodHRwOi8vd3d3LnBvc3RncmVzcWwub3Jn L21lc3NhZ2UtaWQvMjAxNTA4MTIwNTU3MTkuR0ExOTQ1MzMzQHRvcm5hZG8ubGVhZGJvYXQuY29t ICBObyBpc3N1ZXMgd2l0aCBMaW51eCBhbmQgRW5nbGlzaCBXaW5kb3dzIGxvY2FsZXMuDQoNCkZv ciBzb21lIHJlYXNvbnMgSSBhbSBib3VuZCB0byB1c2UgUG9zdGdyZVNRTCBkYXRhYmFzZSA5LjQu NCwgY2Fubm90IHVzZSBoaWdoZXIgdmVyc2lvbiBmb3Igbm93Lg0KVGhlIHByb2JsZW0gaXMgSSBh bSBuZXcgdG8gUG9zdGdyZXMgYW5kIEkgZG9uoa90IGtub3cgaG93IHRvIGFwcGx5IHRob3NlIHBh dGNoZXMuDQpDYW4gc29tZW9uZSBoZWxwIG1lIGluIGluc3RhbGxpbmcgUG9zdGdyZVNRTCBkYXRh YmFzZSB0byA5LjQuNCBvbiBLb3JlYW4gV2luZG93cyBtYWNoaW5lcy4NCklzIHRoZXJlIGFueSB3 b3JrYXJvdW5kIHRvIGF2b2lkIHRoZSBlcnJvciChsEZBVEFMOiAgY2Fubm90IHBlcmZvcm0gZW5j b2RpbmcgY29udmVyc2lvbiBvdXRzaWRlIGEgdHJhbnNhY3Rpb26hsQ0KDQpQb3N0Z3JlU1FMIHZl cnNpb24gbnVtYmVyIHlvdSBhcmUgcnVubmluZzogUG9zdGdyZVNRTCA5LjQuNCwgY29tcGlsZWQg YnkgVmlzdWFsIEMrKyBidWlsZCAxODAwLCA2NC1iaXQNCg0KSG93IHlvdSBpbnN0YWxsZWQgUG9z dGdyZVNRTDogQ29waWVkIHRoZSBQb3N0Z3JlU1FMIDkuNC40IHppcC4gRGVwbG95ZWQgYW5kIGNv bmZpZ3VyZWQgdGhlIGJpbmFyaWVzIHRocm91Z2ggbXkgaW5zdGFsbGVyLg0KDQpDaGFuZ2VzIG1h ZGUgdG8gdGhlIHNldHRpbmdzIGluIHRoZSBwb3N0Z3Jlc3FsLmNvbmYgZmlsZTogIENvdWxkIG5v dCBnZXQgdGhlIGRldGFpbHMuDQoNCk9wZXJhdGluZyBzeXN0ZW0gYW5kIHZlcnNpb246IFdpbmRv d3MgU2VydmVyIDIwMDggUjIgRW50ZXJwcmlzZSAgKDYuMS43NjAxIFNlcnZpY2UgUGFjayAxILr0 teUgNzYwMSkNCg0KV2hhdCBwcm9ncmFtIHlvdSdyZSB1c2luZyB0byBjb25uZWN0IHRvIFBvc3Rn cmVTUUw6IHBvc3RncmVzcWwtOS40LTEyMDEuamRiYzQxLmphcg0KDQpJcyB0aGVyZSBhbnl0aGlu ZyByZWxldmFudCBvciB1bnVzdWFsIGluIHRoZSBQb3N0Z3JlU1FMIHNlcnZlciBsb2dzPzoNCg0K Rm9yIHF1ZXN0aW9ucyBhYm91dCBhbnkga2luZCBvZiBlcnJvcjoNCg0KV2hhdCB5b3Ugd2VyZSBk b2luZyB3aGVuIHRoZSBlcnJvciBoYXBwZW5lZCAvIGhvdyB0byBjYXVzZSB0aGUgZXJyb3I6DQoN ClRoZSBFWEFDVCBURVhUIG9mIHRoZSBlcnJvciBtZXNzYWdlIHlvdSdyZSBnZXR0aW5nLCBpZiB0 aGVyZSBpcyBvbmU6DQpGb2xsb3dpbmcgYXJlIHRoZSBsb2dzIGdlbmVyYXRlZCAtLS0NCg0KVGh1 IEFwciAxNCAyMDo0Nzo1OSBLU1QgMjAxNj09PT09PT09PT09IGluaXRkYi5leGUgPT09PT09PT09 PT09PQ0KVGhlIGZpbGVzIGJlbG9uZ2luZyB0byB0aGlzIGRhdGFiYXNlIHN5c3RlbSB3aWxsIGJl IG93bmVkIGJ5IHVzZXIgIkFkbWluaXN0cmF0b3IiLg0KVGhpcyB1c2VyIG11c3QgYWxzbyBvd24g dGhlIHNlcnZlciBwcm9jZXNzLg0KDQpUaGUgZGF0YWJhc2UgY2x1c3RlciB3aWxsIGJlIGluaXRp YWxpemVkIHdpdGggbG9jYWxlICJLb3JlYW5fS29yZWEuOTQ5Ii4NCmluaXRkYjogY291bGQgbm90 IGZpbmQgc3VpdGFibGUgdGV4dCBzZWFyY2ggY29uZmlndXJhdGlvbiBmb3IgbG9jYWxlICJLb3Jl YW5fS29yZWEuOTQ5Ig0KVGhlIGRlZmF1bHQgdGV4dCBzZWFyY2ggY29uZmlndXJhdGlvbiB3aWxs IGJlIHNldCB0byAic2ltcGxlIi4NCg0KRGF0YSBwYWdlIGNoZWNrc3VtcyBhcmUgZGlzYWJsZWQu DQoNCmNyZWF0aW5nIGRpcmVjdG9yeSBDOi9Qcm9ncmFtIEZpbGVzL0JNQyBTb2Z0d2FyZS9UcnVl U2lnaHRQU2VydmVyL3RydWVzaWdodHBzZXJ2ZXIvZGF0YS9wZ3NxbCAuLi4gb2sNCmNyZWF0aW5n IGRpcmVjdG9yeSBDOi9Qcm9ncmFtIEZpbGVzL0JNQyBTb2Z0d2FyZS9UcnVlU2lnaHRQU2VydmVy L3RydWVzaWdodHBzZXJ2ZXIvZGF0YS9wZ3NxbF90eG5sb2cgLi4uIG9rDQpjcmVhdGluZyBzdWJk aXJlY3RvcmllcyAuLi4gb2sNCnNlbGVjdGluZyBkZWZhdWx0IG1heF9jb25uZWN0aW9ucyAuLi4g MTANCnNlbGVjdGluZyBkZWZhdWx0IHNoYXJlZF9idWZmZXJzIC4uLiA0MDBrQg0Kc2VsZWN0aW5n IGR5bmFtaWMgc2hhcmVkIG1lbW9yeSBpbXBsZW1lbnRhdGlvbiAuLi4gd2luZG93cw0KY3JlYXRp bmcgY29uZmlndXJhdGlvbiBmaWxlcyAuLi4gb2sNCmNyZWF0aW5nIHRlbXBsYXRlMSBkYXRhYmFz ZSBpbiBDOi9Qcm9ncmFtIEZpbGVzL0JNQyBTb2Z0d2FyZS9UcnVlU2lnaHRQU2VydmVyL3RydWVz aWdodHBzZXJ2ZXIvZGF0YS9wZ3NxbC9iYXNlLzEgLi4uIG9rDQppbml0aWFsaXppbmcgcGdfYXV0 aGlkIC4uLiBvaw0Kc2V0dGluZyBwYXNzd29yZCAuLi4gb2sNCmluaXRpYWxpemluZyBkZXBlbmRl bmNpZXMgLi4uIG9rDQpjcmVhdGluZyBzeXN0ZW0gdmlld3MgLi4uIG9rDQpsb2FkaW5nIHN5c3Rl bSBvYmplY3RzJyBkZXNjcmlwdGlvbnMgLi4uIG9rDQpjcmVhdGluZyBjb2xsYXRpb25zIC4uLiBu b3Qgc3VwcG9ydGVkIG9uIHRoaXMgcGxhdGZvcm0NCmNyZWF0aW5nIGNvbnZlcnNpb25zIC4uLiBv aw0KY3JlYXRpbmcgZGljdGlvbmFyaWVzIC4uLiBvaw0Kc2V0dGluZyBwcml2aWxlZ2VzIG9uIGJ1 aWx0LWluIG9iamVjdHMgLi4uIG9rDQpjcmVhdGluZyBpbmZvcm1hdGlvbiBzY2hlbWEgLi4uIG9r DQpsb2FkaW5nIFBML3BnU1FMIHNlcnZlci1zaWRlIGxhbmd1YWdlIC4uLiBvaw0KdmFjdXVtaW5n IGRhdGFiYXNlIHRlbXBsYXRlMSAuLi4gb2sNCmNvcHlpbmcgdGVtcGxhdGUxIHRvIHRlbXBsYXRl MCAuLi4gb2sNCmNvcHlpbmcgdGVtcGxhdGUxIHRvIHBvc3RncmVzIC4uLiBvaw0Kc3luY2luZyBk YXRhIHRvIGRpc2sgLi4uIG9rDQoNClN1Y2Nlc3MuIFlvdSBjYW4gbm93IHN0YXJ0IHRoZSBkYXRh YmFzZSBzZXJ2ZXIgdXNpbmc6DQoNCiAgIDEuICJDOlxQcm9ncmFtIEZpbGVzXEJNQyBTb2Z0d2Fy ZVxUcnVlU2lnaHRQU2VydmVyXHRydWVzaWdodHBzZXJ2ZXJcbW9kdWxlc1xwZ3NxbFxiaW5ccG9z dGdyZXMiIC1EICJDOlxQcm9ncmFtIEZpbGVzXEJNQyBTb2Z0d2FyZVxUcnVlU2lnaHRQU2VydmVy XHRydWVzaWdodHBzZXJ2ZXJcZGF0YVxwZ3NxbCINCm9yDQogICAyLiAiQzpcUHJvZ3JhbSBGaWxl c1xCTUMgU29mdHdhcmVcVHJ1ZVNpZ2h0UFNlcnZlclx0cnVlc2lnaHRwc2VydmVyXG1vZHVsZXNc cGdzcWxcYmluXHBnX2N0bCIgLUQgIkM6XFByb2dyYW0gRmlsZXNcQk1DIFNvZnR3YXJlXFRydWVT aWdodFBTZXJ2ZXJcdHJ1ZXNpZ2h0cHNlcnZlclxkYXRhXHBnc3FsIiAtbCBsb2dmaWxlIHN0YXJ0 DQoNClJlc3VsdHMgb2YgdGhlIDFzdCBjb21tYW5kOg0KQzpcVXNlcnNcQWRtaW5pc3RyYXRvcj4i QzpcUHJvZ3JhbSBGaWxlc1xCTUMgU29mdHdhcmVcVHJ1ZVNpZ2h0UFNlcnZlclx0cnVlc2lnaHQN CnBzZXJ2ZXJcbW9kdWxlc1xwZ3NxbFxiaW5ccG9zdGdyZXMiIC1EICJDOlxQcm9ncmFtIEZpbGVz XEJNQyBTb2Z0d2FyZVxUcnVlU2lnaHRQU2VydmVyXHRydWVzaWdodHBzZXJ2ZXJcZGF0YVxwZ3Nx bCINCkZBVEFMOiAgWFgwMDA6IGNhbm5vdCBwZXJmb3JtIGVuY29kaW5nIGNvbnZlcnNpb24gb3V0 c2lkZSBhIHRyYW5zYWN0aW9uDQpMT0NBVElPTjogIHBnX2RvX2VuY29kaW5nX2NvbnZlcnNpb24s IHNyY1xiYWNrZW5kXHV0aWxzXG1iXG1idXRpbHMuYzozNjANCg0KDQpUaGFua3MgaW4gYWR2YW5j ZSwgYW55IGhlbHAgaXMgcmVhbGx5IGFwcHJlY2lhdGVkLg0KUGxlYXNlIGxldCBtZSBrbm93IGlm IHlvdSBuZWVkIGFueSBmdXJ0aGVyIGluZm9ybWF0aW9uLg0KDQoNCkJlc3QgUmVnYXJkcywNClBy YXNoYW50DQo=
On Thu, Apr 14, 2016 at 01:58:06PM +0000, Zombade, Prashant wrote: > Sometimes back we upgraded the PostgreSQL database to 9.4.4 and now installation is particularly failing on Korean systemswith error ??FATAL: cannot perform encoding conversion outside a transaction??. This is exactly as mentioned in responseto BUG #13427 http://www.postgresql.org/message-id/20150812055719.GA1945333@tornado.leadboat.com No issues withLinux and English Windows locales. > > For some reasons I am bound to use PostgreSQL database 9.4.4, cannot use higher version for now. From http://www.postgresql.org/support/versioning/: Minor releases are numbered by increasing the third part of the version number, e.g. 9.2.3 to 9.2.4. The PostgreSQL team only adds bug fixes to minor releases. All users should upgrade to the most recent minor release as soon as possible. While upgrades always have some risk, PostgreSQL minor releases fix only frequently-encountered, security, and data corruption bugs to reduce the risk of upgrading. The community considers not upgrading to be riskier than upgrading. What blocks you from using 9.4.7? > The problem is I am new to Postgres and I don??t know how to apply those patches. > Can someone help me in installing PostgreSQL database to 9.4.4 on Korean Windows machines. Various providers in http://www.postgresql.org/support/professional_support/ could build for you a copy of PostgreSQL that is precisely 9.4.4 plus the patch that fixed this bug. You would miss other important bug fixes, so I recommend against this. An application may require a specific major version (here, 9.4.x), but it should not require a specific minor version. > Is there any workaround to avoid the error ??FATAL: cannot perform encoding conversion outside a transaction?? Apart from configuring a different locale, no.