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.kla...@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.kla...@aklaver.com >
