Installation fails for postgresql-8.0.0-beta4 on WindowsXP SP1

From: Mehul Doshi-A20614 <mehul(at)motorola(dot)com>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Installation fails for postgresql-8.0.0-beta4 on WindowsXP SP1
Date: 2004-11-25 09:00:52
Message-ID: 653138C25D8AD6118292000347080A370F9EDC7D@zin05exm02.corp.mot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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 member of 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 files belonging 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:/Program Files/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 ... ok
creating 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:/Program Files/PostgreSQL/8.0.0-beta4/data/base/1 ... Execution of PostgreSQL by a user with administrative permissions is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromises. See the documentation for
more information on how to properly start the server.
child process 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 account itself and it kicked me off right in Step 4 of the procedure. So if it goes past Step 4 it already recognizes that it 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Weiping 2004-11-25 10:32:27 Re: plpgsql lacks generic identifier for record in triggers...
Previous Message Andrzej Wojtaszek 2004-11-25 07:53:25 interval conversion bug