Re: BUG #4785: Installation fails - Mailing list pgsql-bugs

From big col
Subject Re: BUG #4785: Installation fails
Date
Msg-id 27649038.post@talk.nabble.com
Whole thread Raw
In response to Re: BUG #4785: Installation fails  (goldenhawking <goldenhawking@hotmail.com>)
List pgsql-bugs
Please Note that this problem is caused even with an English version of
Windows.

I tried 3 different versions of PostGres (8.3.7.1 , 8.3.7.2,  and 8.4) and
they all gave this same, annoying problem.

The problem is caused by using the first (default) option for the Locale
(i.e. as prompted in the Postgres installation wizard). Selecting a diferent
Locale (e.g. English, Australian) would resolve the issue and the
PostgreSQL\8.*\data folder is now created with all the files.

Dave, perhaps the install script needs to be change, so as not to offer this
Default Locale option????



goldenhawking wrote:
>=20
> En, I have that damm problem sloved.
> Are you using a Non-English Version of Windows? for example, JPN, CHS?
> If you install your PSQL in an Asian-language windows, be sure that
> "locale" settings should be setted manualy to a supported language, I
> choosed "C" for it is the first item in the combo.
>=20
> this is the errmsg when you're using default local settings:
>=20
> Running the post-installation/upgrade actions:
> Delete the temporary scripts directory...
> Write the base directory to the ini file...
> Write the version number to the ini file...
> Initialising the database cluster (this may take a few minutes)...
> Executing cscript
> Script exit code: 0
>=20
> Script output:
>=20
> Ensuring we can write to the data directory (using cacls):
> =E6=95=B0=E6=8D=AE=E6=97=A0=E6=95=88=E3=80=82(Means data is unavaliable)
>=20
>=20
> The files belonging to this database system will be owned by user
> "XXXXXXXX".
> This user must also own the server process.
>=20
> The database cluster will be initialized with locale Chinese_XXXXXXX.936.
> initdb: could not find suitable text search configuration for locale
> Chinese_XXXXXXX.936
> The default text search configuration will be set to "simple".
>=20
> fixing permissions on existing directory D:/XXXXXX... ok
> creating subdirectories ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers ... 32MB
> creating configuration files ... ok
> creating template1 database in D:/XXXXXXX/base/1 ... ok
> initializing pg_authid ... FATAL:  database locale is incompatible with
> operating system
> DETAIL:  The database was initialized with LC_COLLATE
> "Chinese_XXXXXXXX.936",  which is not recognized by setlocale().
> HINT:  Recreate the database with another locale or install the missing
> locale.
> child process exited with exit code 1
> initdb: removing contents of data directory "D:/XXXXXX"
>=20
> Granting service account access to the data directory (using cacls):
> =E5=A4=84=E7=90=86=E7=9A=84=E7=9B=AE=E5=BD=95: D:\XXXXXXXXX(Processed fol=
der:D:\XXXXXXXXX)
>=20
> initcluster.vbs ran to completion
>=20
> Script stderr:
>=20
>=20
> Configuring database server startup...
> Executing cscript
> Script exit code: 0
>=20
> Script output:
> startupcfg.vbs ran to completion
>=20
> Script stderr:
>=20

--=20
View this message in context: http://old.nabble.com/BUG--4785%3A-Installati=
on-fails-tp23323059p27649038.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: Tim Bunce
Date:
Subject: Re: BUG #5334: Version 2.22 of Perl Safe module breaks UTF8 PostgreSQL 8.4
Next
From: "David E. Wheeler"
Date:
Subject: Re: [Tigerlead] BUG #5334: Version 2.22 of Perl Safe module breaks UTF8 PostgreSQL 8.4