Обсуждение: PostgreSQL on Korean Windows Server 2008 R2 Standard

Поиск
Список
Период
Сортировка

PostgreSQL on Korean Windows Server 2008 R2 Standard

От
"Zombade, Prashant"
Дата:
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=

Re: PostgreSQL on Korean Windows Server 2008 R2 Standard

От
Noah Misch
Дата:
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.