Re: Installation fails for postgresql-8.0.0-beta4 on Windo

Hi,

I and my colleagues are clearly able to install the beta 5 version on Windows 2000. But when the same procedure is
followedfor Windows XP Professional, it fails as is detailed my previous posts. We have tried it on 4-5 different
systemsand everywhere the result is the same.  

Can somebody who has installed on Windows XP Professional system which is in a domain please reply as to what steps
changeto get this working. 

Thanks & Regards,
Mehul

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org [mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Mehul Doshi-A20614
Sent: Monday, November 29, 2004 1:52 PM
To: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Installation fails for postgresql-8.0.0-beta4 on Windo


Hi,

A further clue that can help to resolve this bug:

I tried to install it on Windows 2000 & it works fine. So I think the issue might be only for Windows XP Professional
systems.

Regards,
Mehul

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org [mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Mehul Doshi-A20614
Sent: Thursday, November 25, 2004 2:31 PM
To: pgsql-bugs@postgresql.org
Subject: [BUGS] Installation fails for postgresql-8.0.0-beta4 on WindowsXP SP1



Hi,

I am trying to install the 8.0 beta4 version for Windows onto my system and facing an error which I can't fix.

System: Windows XP, Sevice Pack 1

I am an admin on my system, but a regular user on a domain. I have created a non-admin user named "postgres" which is a
memberof the "Users" group (Restricted Users). 

I have run the entire installation in exactly the same way as is given http://pginstaller.projects.postgresql.org/

However, this is the error message that I get.

Error Pop-up message:
"Failed to run initdb: 1! Please see the logfile in "C:\Program Files\PostgreSQL\8.0.0-beta4\tmp\initdb.log"
Note! You must read/copy this logifle before you click OK, or it will be automatically removed."


Please find the log (initdb.log) below
---------------------------------------------------------------------------------------------------------------------------The
filesbelonging to this database system will be owned by user "postgres". This user must also own the server process. 

The database cluster will be initialized with locale C.

fixing permissions on existing directory C:/Program Files/PostgreSQL/8.0.0-beta4/data ... ok creating directory
C:/ProgramFiles/PostgreSQL/8.0.0-beta4/data/global ... ok creating directory C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_xlog... ok creating directory C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_xlog/archive_status... ok creating directory C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_clog... ok creating directory C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_subtrans... ok creating directory C:/Program
Files/PostgreSQL/8.0.0-beta4/data/base... ok creating directory C:/Program Files/PostgreSQL/8.0.0-beta4/data/base/1 ...
okcreating directory C:/Program Files/PostgreSQL/8.0.0-beta4/data/pg_tblspc ... ok selecting default max_connections
...10 selecting default shared_buffers ... 50 creating configuration files ... ok creating template1 database in
C:/ProgramFiles/PostgreSQL/8.0.0-beta4/data/base/1 ... Execution of PostgreSQL by a user with admin! 
 !  istrative permissions is not permitted. The server must be started under an unprivileged user ID to prevent
possiblesystem security compromises.  See the documentation for more information on how to properly start the server.
childprocess was terminated by signal 1 
initdb: failed
initdb: removing contents of data directory "C:/Program Files/PostgreSQL/8.0.0-beta4/data"


---------------------------------------------------------------------------------------------------------------------------

It somehow recognizes the account as an admin, when it is definitely not. Just to check, I even tried with the admin
accountitself and it kicked me off right in Step 4 of the procedure. So if it goes past Step 4 it already recognizes
thatit is not admin account. 

I think this issue has been raised before
http://pgfoundry.org/tracker/index.php?func=detail&aid=1000088&group_id=1000007&atid=126

Please let me know if there is something that needs to be fixed by me before this installation goes through
successfully.

Regards,
Mehul

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend