Обсуждение: BUG #4785: Installation fails
The following bug has been logged online: Bug reference: 4785 Logged by: Roger Krimstock Email address: rik@avaya.com PostgreSQL version: 8.3.7-1 Operating system: Windows XP Description: Installation fails Details: Installation fails with complaint about accessing data\postgresql.conf I've added user "postgres" to administrator and superuser groups with the same result. Also tried the 8.4 version.
On Wed, Apr 29, 2009 at 2:49 AM, Roger Krimstock <rik@avaya.com> wrote: > > The following bug has been logged online: > > Bug reference: =A0 =A0 =A04785 > Logged by: =A0 =A0 =A0 =A0 =A0Roger Krimstock > Email address: =A0 =A0 =A0rik@avaya.com > PostgreSQL version: 8.3.7-1 > Operating system: =A0 Windows XP > Description: =A0 =A0 =A0 =A0Installation fails > Details: > > Installation fails with complaint about accessing data\postgresql.conf > > I've added user "postgres" to administrator and superuser groups with the > same result. > > Also tried the 8.4 version. Which installer - the MSI or one-click? What was the error message exactly? --=20 Dave Page EnterpriseDB UK: http://www.enterprisedb.com
The one click from downloads on www.postgres.org. Both the 8.3.7 and 8.4 v= ersions. The error message: =20 --------------------------- Warning --------------------------- Problem running post-install step. Installation may not complete correctly Error reading file C:/Program Files/PostgreSQL/8.4/data/postgresql.conf --------------------------- OK=20=20=20 --------------------------- I've tried to direct data to a different directory. Looked at permissions,= etc. It just seems that this file is not created during installation/conf= iguration. Thanks! Roger Krimstock -----Original Message----- From: Dave Page [mailto:dpage@pgadmin.org]=20 Sent: Friday, May 01, 2009 3:40 AM To: Krimstock, Roger I (Roger) Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4785: Installation fails On Wed, Apr 29, 2009 at 2:49 AM, Roger Krimstock <rik@avaya.com> wrote: > > The following bug has been logged online: > > Bug reference: =A0 =A0 =A04785 > Logged by: =A0 =A0 =A0 =A0 =A0Roger Krimstock > Email address: =A0 =A0 =A0rik@avaya.com > PostgreSQL version: 8.3.7-1 > Operating system: =A0 Windows XP > Description: =A0 =A0 =A0 =A0Installation fails > Details: > > Installation fails with complaint about accessing data\postgresql.conf > > I've added user "postgres" to administrator and superuser groups with=20 > the same result. > > Also tried the 8.4 version. Which installer - the MSI or one-click? What was the error message exactly? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Tue, May 5, 2009 at 7:56 PM, Krimstock, Roger I (Roger) <rik@avaya.com> wrote: > > The one click from downloads on www.postgres.org. =A0Both the 8.3.7 and 8= .4 versions. =A0The error message: > > --------------------------- > Warning > --------------------------- > Problem running post-install step. Installation may not complete correctly > =A0Error reading file C:/Program Files/PostgreSQL/8.4/data/postgresql.conf > --------------------------- > OK > --------------------------- > > I've tried to direct data to a different directory. =A0Looked at permissi= ons, etc. =A0It just seems that this file is not created during installatio= n/configuration. The files is created during the initdb phase of the installation, which if it fails *should* cause the installation to abort earlier on. Can you dig out the log file and send it to me please (mask out any instances of your chosen password first). You should be able to find it in %TEMP%. Regards, Dave. --=20 Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Wed, May 6, 2009 at 4:41 PM, Krimstock, Roger I (Roger)
<rik@avaya.com> wrote:
>
> Hopefully, this is the file that will provide the information. =A0It does=
reference postgresql.conf.
Yep, it is the right file. The pertinent bit is this:
---
Ensuring we can write to the data directory (using cacls):
Are you sure (Y/N)?processed dir: C:\Program Files\PostgreSQL\8.4\data
Access is denied.
----
The command that seems to be failing appears to be:
echo y|cacls "C:\Program Files\PostgreSQL\8.4\data" /T /G "<username>":F
where <username> is your current username as returned by a scripting
object. Can you try running the command in a command prompt please,
and see if it works interactively (using your username)?
Also, please put the following in a file (test.vbs) and run it with:
cscript test.vbs
on the commandline. Don't include the dashes in the file:
-----
Set objNetwork =3D CreateObject("WScript.Network")
WScript.Echo objNetwork.Username
-----
Thanks.
--=20
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
[Please keep the list CC'd] On Thu, May 7, 2009 at 3:14 AM, Krimstock, Roger I (Roger) <rik@avaya.com> wrote: > > The command that seems to be failing appears to be: > > echo y|cacls "C:\Program Files\PostgreSQL\8.4\data" /T /G "<username>":F > > where <username> is your current username as returned by a scripting object. Can you try running the command in a commandprompt please, and see if it works interactively (using your username)? >>>>>>[RIK] for both users, "rik" and "postgres", the response is: "Access is denied" OK, so the basic question is, why can't you set permissions on that directory? The installer obviously thinks you have some admin privileges, otherwise it would have aborted at startup. Can you answer the following please and we can try to figure out the issue? - Is your computer on a domain? - Is your user account a domain or local account? - Are you a local administrator, domain administrator or member of the power users group (or anything similar?) - Do you have permissions to write to each directory in the path C:\Program Files\PostgreSQL\8.4\data ? - Is this an NTFS filesystem? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Dave, Should the installer be the user "postgres"? I've installed both as "rik" (global domain) and "postgres" (local domain). Each time installation fails to write the "conf" file in /data. See below for answers to your questions. Thanks! Roger P.S. OS is XP -----Original Message----- From: Dave Page [mailto:dpage@pgadmin.org]=20 Sent: Thursday, May 07, 2009 2:31 AM To: Krimstock, Roger I (Roger); Pg Bugs Subject: Re: [BUGS] BUG #4785: Installation fails [Please keep the list CC'd] On Thu, May 7, 2009 at 3:14 AM, Krimstock, Roger I (Roger) <rik@avaya.com> wrote: > > The command that seems to be failing appears to be: > > echo y|cacls "C:\Program Files\PostgreSQL\8.4\data" /T /G=20 > "<username>":F > > where <username> is your current username as returned by a scripting object. Can you try running the command in a command prompt please, and see if it works interactively (using your username)? >>>>>>[RIK] for both users, "rik" and "postgres", the response is: "Access is denied" OK, so the basic question is, why can't you set permissions on that directory? The installer obviously thinks you have some admin privileges, otherwise it would have aborted at startup. Can you answer the following please and we can try to figure out the issue? - Is your computer on a domain? Yes - Is your user account a domain or local account? Domain account - Are you a local administrator, domain administrator or member of the power users group (or anything similar?) Local administrator and I added myself to power users. - Do you have permissions to write to each directory in the path C:\Program Files\PostgreSQL\8.4\data ? Yes - Is this an NTFS filesystem? Yes -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Tue, May 12, 2009 at 2:17 AM, Krimstock, Roger I (Roger) <rik@avaya.com> wrote: > > Dave, > Should the installer be the user "postgres"? =A0I've installed both as > "rik" (global domain) and "postgres" (local domain). =A0Each time > installation fails to write the "conf" file in /data. =A0See below for > answers to your questions. No - the postgres user is created by the installer so you can't use it to run the installer on the first installation. It also doesn't have any administrative permissions which are required. > - Is your computer on a domain? > Yes > - Is your user account a domain or local account? > Domain account > - Are you a local administrator, domain administrator or member of the > power users group (or anything similar?) > Local administrator and I added myself to power users. > - Do you have permissions to write to each directory in the path > C:\Program Files\PostgreSQL\8.4\data ? > Yes > - Is this an NTFS filesystem? > Yes So you have permission to write to those directories, but cacls fails if you try to change the permissions on them. Weird. Magnus; any ideas on what could cause this? I must admit, my Windows management-fu is somewhat rusty these days. --=20 Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Magnus? Ping? On Tue, May 12, 2009 at 8:56 AM, Dave Page <dpage@pgadmin.org> wrote: > On Tue, May 12, 2009 at 2:17 AM, Krimstock, Roger I (Roger) > <rik@avaya.com> wrote: >> >> Dave, >> Should the installer be the user "postgres"? =A0I've installed both as >> "rik" (global domain) and "postgres" (local domain). =A0Each time >> installation fails to write the "conf" file in /data. =A0See below for >> answers to your questions. > > No - the postgres user is created by the installer so you can't use it > to run the installer on the first installation. It also doesn't have > any administrative permissions which are required. > >> - Is your computer on a domain? >> Yes >> - Is your user account a domain or local account? >> Domain account >> - Are you a local administrator, domain administrator or member of the >> power users group (or anything similar?) >> Local administrator and I added myself to power users. >> - Do you have permissions to write to each directory in the path >> C:\Program Files\PostgreSQL\8.4\data ? >> Yes >> - Is this an NTFS filesystem? >> Yes > > So you have permission to write to those directories, but cacls fails > if you try to change the permissions on them. Weird. > > Magnus; any ideas on what could cause this? I must admit, my Windows > management-fu is somewhat rusty these days. > > > -- > Dave Page > EnterpriseDB UK: =A0 http://www.enterprisedb.com > --=20 Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Sat, Jun 20, 2009 at 2:17 PM, Krimstock, Roger I (Roger)<rik@avaya.com> wrote: > > Noone's answered this. =A0I'd really like to install Postgres on my work = station. I'm sorry - I thought I did, but I can't find it in my sent items folder. Please try this update: http://uploads.enterprisedb.com/download.php?file=3Dfd66bbc24b3b7105a22f54b= 11447eeea --=20 Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Noone's answered this. I'd really like to install Postgres on my work stat= ion.=20=20=20 -----Original Message----- From: Dave Page [mailto:dpage@pgadmin.org]=20 Sent: Friday, May 15, 2009 5:00 AM To: Krimstock, Roger I (Roger) Cc: Pg Bugs; Magnus Hagander Subject: Re: [BUGS] BUG #4785: Installation fails Magnus? Ping? On Tue, May 12, 2009 at 8:56 AM, Dave Page <dpage@pgadmin.org> wrote: > On Tue, May 12, 2009 at 2:17 AM, Krimstock, Roger I (Roger)=20 > <rik@avaya.com> wrote: >> >> Dave, >> Should the installer be the user "postgres"? =A0I've installed both as= =20 >> "rik" (global domain) and "postgres" (local domain). =A0Each time=20 >> installation fails to write the "conf" file in /data. =A0See below for= =20 >> answers to your questions. > > No - the postgres user is created by the installer so you can't use it=20 > to run the installer on the first installation. It also doesn't have=20 > any administrative permissions which are required. > >> - Is your computer on a domain? >> Yes >> - Is your user account a domain or local account? >> Domain account >> - Are you a local administrator, domain administrator or member of=20 >> the power users group (or anything similar?) Local administrator and=20 >> I added myself to power users. >> - Do you have permissions to write to each directory in the path=20 >> C:\Program Files\PostgreSQL\8.4\data ? >> Yes >> - Is this an NTFS filesystem? >> Yes > > So you have permission to write to those directories, but cacls fails=20 > if you try to change the permissions on them. Weird. > > Magnus; any ideas on what could cause this? I must admit, my Windows=20 > management-fu is somewhat rusty these days. > > > -- > Dave Page > EnterpriseDB UK: =A0 http://www.enterprisedb.com > -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
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 "local" settings should be setted manualy to a supported language, English-USA is good. this is the errmsg when you're using default local settings: 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 Script output: 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 The files belonging to this database system will be owned by user "GoldenHawk". This user must also own the server process. The database cluster will be initialized with locale Chinese_People's Republic of China.936. initdb: could not find suitable text search configuration for locale Chinese_People's Republic of China.936 The default text search configuration will be set to "simple". fixing permissions on existing directory D:/PSQLDATA ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 32MB creating configuration files ... ok creating template1 database in D:/PSQLDATA/base/1 ... ok initializing pg_authid ... FATAL: database locale is incompatible with operating system DETAIL: The database was initialized with LC_COLLATE "Chinese_Peoples Republic of China.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:/PSQLDATA" 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:\PSQLDATA initcluster.vbs ran to completion Script stderr: Configuring database server startup... Executing cscript Script exit code: 0 Script output: startupcfg.vbs ran to completion Script stderr: --=20 View this message in context: http://www.nabble.com/BUG--4785%3A-Installati= on-fails-tp23323059p24456184.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
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.