Re: (Might be a bug) locale issue while upgrading data directory from PostgreSQL 8.4 to 9.5

No, windows has not been upgraded (Windows 7). Moreover, I think it is not
related to windows version, because I tried the scenarios from scratch on a
same machine and on a some windows version.

While working on this issue I notices something. Details are as follows:

On Windows7, I installed the PostgreSQL 8.4 with following *--locale* values

1.

*--locale "English_United States.1252"*

Installation fails, gives same error: 'Locale specified is not
supported.'
2.

*--locale "English, United States"*

Successful Installation, value of '*Show lc_collate*': *English, United
States*
3.

No Value (i.e. parameter *--locale* is not provided during installation)

Successful Installation, value of '*Show lc_collate*': *English_United
States.1252*

If you notice point 1. and 3., locale value can be stored as *English_United
States.1252* but can not be given as a value of parameter *--locale* during
installation. This seems to me as a bug.

In my case, *--locale* parameter was not provided during PostgreSQL 8.4
installation [scenario 3].
Thanks and Regards,
Mayank Agrawal

.

On Fri, Jul 7, 2017 at 4:56 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 07/04/2017 10:23 PM, Mayank Agrawal wrote:
>
>> Hello,
>>
>> I am upgrading PostgreSQL 8.4 to 9.5 on Windows. There is some issue
>> related to locale. Details are as follows:
>>
>> The steps that I am following are:
>>
>> 1. Install PostgreSQL 9.5 (8.4 is already installed).
>>
>> 2. Migrate data from 8.4's data dir to 9.5's data dir using pg_upgrade
>> utility.
>>
>> 3. After successful upgrade, uninstall PostgreSQL 8.4
>>
>> Here the issue is that PostgreSQL 8.4 could be installed with any locale
>> (English or French etc.) and to have successful data directory upgrade,
>> PostgreSQL 9.5 must be installed with the same locale as that of 8.4.
>>
>> Supplying the output of query 'Show lc_collate' (executed on PostgreSQL
>> 8.4) to PostgreSQL 9.5 installation leads to failed installation. It
>> generates the error 'specified locale is not supported'.
>>
>
> Has the Windows version been upgraded between the install of 8.4 and the
> upgrade to 9.5?
>
>
>> Here is the example:
>>
>> Output (PostgreSQL 8.4) of query 'SHOW LC_COLLATE': English_United
>> States.1252
>>
>> A. --locale "English_United States.1252"
>>
>> While installing PostgreSQL 9.5, If we pass locale option as above,
>> installer aborts with an error 'specified locale is not supported'.
>>
>> B. --locale "English, United States"
>>
>> If we pass locale option as above, installation is successful and cluster
>> locale is set to 'English, United States'.
>>
>> *Given that one has access to PostgreSQL 8.4, how would one know what
>> value to pass to the parameter --locale while installing PostgreSQL 9.5?*
>>
>> Thanks and Regards,
>>
>> Mayank Agrawal
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>