------------------------------------------<br/><br/>error info:<br/><br/>The files belonging to this database system will be owned by user "postgres".<br/>This user must also own the server process.<br/><br/>The database cluster will be initialized with locale "C".<br/>The default text search configuration will be set to "english".<br/><br/>Data page checksums are disabled.<br/><br/>fixing permissions on existing directory D:/pgsql942/data ... ok<br/>creating subdirectories ... ok<br/>selecting default max_connections ... 40<br/>selecting default shared_buffers ... 128MB<br/>selecting dynamic shared memory implementation ... windows<br/>creating configuration files ... ok<br/>creating template1 database in D:/pgsql942/data/base/1 ... <br/>FATAL: XX00: could not adopt C locale<br/>LOCATION: init_locale, src\backend\main\main.c:315<br/>child process exited with exit code 1<br/>initdb: removing contents of data directory "d:/pgsql942/data"<br/><br/>------------------------------------------<br/><br/>my env: <br/>windows 7 simple chinese edit (x86 and x64)<br/>pgsql 9.4.2 x86<br/><br/>------------------------------------------<br/><br/>install batch file 1 by admin:<br/><br/>@ECHO OFF<br/>@setlocal enableextensions<br/>cd /d %~dp0<br/>set PGHOME=%cd%<br/>set PGBIN=%cd%\bin<br/>set PGDATA=%cd%\data<br/>set password=123<br/><br/>net user postgres %password% /add /expires:never /passwordchg:no<br/>netuser postgres /pwnexp:y<br/>rem net localgroup users postgres /delete<br/>ntrights.exe -u postgres +r SeServiceLogonRight<br/><br/>cacls %PGHOME% /E /T /D postgres<br/>cacls %PGHOME% /E /T /G postgres:R<br/>cacls %PGHOME% /E /T /P postgres:R<br/>cacls %PGDATA% /E /T /P postgres:C<br/><br/>pause<br/><br/>------------------------------------------<br/><br/>install batch file 2 by postgres user:<br/><br/>@ECHO OFF<br/>@setlocal enableextensions<br/>chcp 65001<br/><br/>cd /d %~dp0<br/>set PGHOME=%cd%<br/>set PGBIN=%cd%\bin<br/>set PGDATA=%cd%\data<br/><br/>if not exist %PGDATA% md %PGDATA%<br/><br/>%PGBIN%\initdb -D %PGDATA% -E UTF8 --locale=C -W<br/><br/>pause<br/><br/>-----------------------<br/>Regards,<br/>Lin Pengcheng
At 2015-05-28 08:44:25, "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com> wrote:
>On Wed, May 27, 2015 at 10:53 PM, <lincpa(at)163(dot)com> wrote:
>> pgsql9.4.2 (x86) in win7 (including 32 and 64) for manual installation and
>> automatically instation, when you run initdb use --locale = C errors occur,
>> it's indeed a bug.
>> but I manually install pg9.3 and pg9 .4.0 not have this problem. otherwise
>> users win8 installed in pg9.4.2(x64) no problem with --locale = C.
>
>Could you provide more details about the error occurring as well as
>how you installed Postgres? I am afraid that I cannot reproduce this
>problem with an MSVC installation after initializing with initdb
>--locale=C on Win7:
>=# show lc_collate;
> lc_collate
>------------
> C
>(1 row)
>=# SELECT version();
> version
>-------------------------------------------------------------
> PostgreSQL 9.4.2, compiled by Visual C++ build 1600, 64-bit
>(1 row)
>
>Regards,
>--
>Michael