Re: [GENERAL] (Might be a bug) locale issue while upgrading datadirectory from PostgreSQL 8.4 to 9.5

Поиск
Список
Период
Сортировка
От Mayank Agrawal
Тема Re: [GENERAL] (Might be a bug) locale issue while upgrading datadirectory from PostgreSQL 8.4 to 9.5
Дата
Msg-id CAHUTDK5TNkoD0fK5zGzapBBw+s=DsYmHC6a18_s_e4eqqYHkjA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] (Might be a bug) locale issue while upgrading datadirectory from PostgreSQL 8.4 to 9.5  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [GENERAL] (Might be a bug) locale issue while upgrading datadirectory from PostgreSQL 8.4 to 9.5
Список pgsql-general
Дерево обсуждения
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.klaver@aklaver.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.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] (Might be a bug) locale issue while upgrading datadirectory from PostgreSQL 8.4 to 9.5
Следующее
От: Osahon Oduware
Дата:
Сообщение: Re: [GENERAL] Renaming Raster Table