Re: BUG #9531: Failed to install - Mailing list pgsql-bugs
| From | Yong Zhang |
|---|---|
| Subject | Re: BUG #9531: Failed to install |
| Date | |
| Msg-id | 29FE3458A4A2B6419D1558999668038F0149B845@usmail.trinitybiotech.com Whole thread Raw |
| In response to | Re: BUG #9531: Failed to install (Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>) |
| Responses |
Re: BUG #9531: Failed to install
(Dave Page <dpage@pgadmin.org>)
|
| List | pgsql-bugs |
Hello,
After I submitted the bug online yesterday I tried to install 9.1 with the data folder specified to a folder which is not in Program Files (x86). The result was a disaster – it changed the owner of my C:\ to postgres. So I had to go through lots trouble to restore my computer back to the working state.
I just tried to install 9.3 again with switch “–enable_acledit 1”. I didn’t use any other command line option. The log file is attached.
Is there a document of how to set up PostgreSQL server on Windows manually? I would like to extract the files on my machine and then manually set it up. It seems very dangerous to run the installer. I have two colleagues who had experienced the same issue – the installer changed the ownership of C:\. And it was really big deal for them to fix it. They are both running Windows 7 Ultimate SP1 64-bit, same as me.
Thanks,
Yong
From: Sandeep Thakkar [mailto:sandeep.thakkar@enterprisedb.com]
Sent: Wednesday, March 12, 2014 6:29 AM
To: Yong Zhang
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #9531: Failed to install
Hi
Any other command line option you are using? Could you please attach the log here.. The one which got produced with --enable_acledit 1 option.
On Tue, Mar 11, 2014 at 10:00 PM, <yzhang@trinityusa.com> wrote:
The following bug has been logged on the website:
Bug reference: 9531
Logged by: Yong Zhang
Email address: yzhang@trinityusa.com
PostgreSQL version: 9.3.3
Operating system: Windows 7 Ultimate SP1 64-bit
Description:
I failed to install 9.3.3.1, both 32-bit and 64-bit versions. I even tried
with switch "--enable_acledit 1". Got exactly the same result. I also tried
9.1 and 9.2. They are the same. In the log file I found:
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:6.1
MajorVersion:6
Ensuring we can write to the data directory (using icacls) to yzhang:
Executing batch file 'rad3DB60.bat'...
processed file: C:\Program Files (x86)\PostgreSQL\9.3\data
Successfully processed 1 files; Failed processing 0 files
Executing batch file 'rad3DB60.bat'...
The files belonging to this database system will be owned by user
"yzhang".
This user must also own the server process.
The database cluster will be initialized with locale "English_United
States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/Program Files
(x86)/PostgreSQL/9.3/data ... initdb: could not change permissions of
directory "C:/Program Files (x86)/PostgreSQL/9.3/data": Permission denied
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\Program Files
(x86)\PostgreSQL\9.3/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****" "C:\Program Files
(x86)\PostgreSQL\9.3" "C:\Program Files (x86)\PostgreSQL\9.3\data" 5432
"English, United States" 1 : Program ended with an error exit code
Problem running post-install step. Installation may not complete correctly
The database cluster initialisation failed.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
--
Sandeep Thakkar
Attachment
pgsql-bugs by date: