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

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 admin!
! istrative 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

---------------------------(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

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

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 admin!
! istrative 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

---------------------------(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

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

-----Original Message-----
From: Mehul Doshi-A20614 [mailto:mehul@motorola.com]
Sent: Thursday, December 02, 2004 9:45 AM
To: Magnus Hagander; pgsql-bugs@postgresql.org
Subject: RE: [BUGS] Installation fails for
postgresql-8.0.0-beta4 on Windo

Hi,

Magnus, thanks for replying. We believe that we have followed
the given instructions all the way.
I have taken snapshots of entire installation and compiled
into a document (zipped ~ 500kb)which I wish to send across.
These contain the snapshots of the "postgres" user created
and it's properties.

However since the issue might not be relevant to all, I would
appreciate if I can send it to one person rather than to the
whole list. Magnus can I send it to you?

Thanks once again for your response. Awaiting a reply soon.

Thanks & Regards,
Mehul

-----Original Message-----
From: Magnus Hagander [mailto:mha@sollentuna.net]
Sent: Wednesday, December 01, 2004 3:51 PM
To: Mehul Doshi-A20614; pgsql-bugs@postgresql.org
Subject: RE: [BUGS] Installation fails for
postgresql-8.0.0-beta4 on Windo

Yes. I have done this at least 50 times with no issues. Using
a local service account.

Have you followed the instructions in questino 3.3 on
http://pginstaller.projects.postgresql.org/FAQ_windows.html ?

My guess is that you have some rule somewhere (be it local or
using Group Policy) that adds Users or Authenticated Users or
similar to the Power Users or Administrators group, perhaps
with indirection. Or some other evil along that line.

//Magnus

-----Original Message-----

Hi,

I and my colleagues are clearly able to install the beta 5
version on Windows 2000. But when the same procedure is
followed for Windows XP Professional, it fails as is detailed
my previous posts. We have tried it on 4-5 different systems
and 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
change to 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
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
--------------------------------------------------------------
-------------------------------------------------------------T

he 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 admin!
! istrative 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

---------------------------(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

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