Re: PostgreSQL on Korean Windows Server 2008 R2 Standard

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 systems with error ??FATAL: cannot perform encoding conversion outside a transaction??. This is exactly as mentioned in response to BUG #13427 http://www.postgresql.org/message-id/20150812055719.GA1945333@tornado.leadboat.com No issues with Linux 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.