#1: Trouble installing on XP home
Posted on 2006-01-15 02:18:49 by Dave M
I'm trying to install postgresql on my laptop, windows XP home edition sp2.
can't install as a service: I either have too much permission or not enough=
....
Here are the steps I performed and the generated messages:
1)I ran the install program (postgresql-8.1)
the data directory chosen is a folder located in a NTFS logical drive (F:\P=
ostgreSQL\), the remainder of the drive being of FAT type.
error message: "Failed to run initdb: 1!"
the initdb log reads as follows:
------------------------------------------------------------ --------------=
----------------------
The files belonging to this database system will be owned by user "postgre=
susr".
This user must also own the server process.
The database cluster will be initialized with locale C.
fixing permissions on existing directory F:/PostgreSQL ... initdb: could n=
ot change permissions of directory "F:/PostgreSQL": Permission denied
------------------------------------------------------------ --------------=
----------------------
2) I ran the install again, but this time uncheck 'install as service'
I opened a Command Prompt and executed the following:
cd \program files\postgresql\8.1\bin
initdb --locale=3DC --username=3Dpostgres -W -A md5 -E UNICODE -D f:\postg=
resql
I get the following:
------------------------------------------------------------ ---------------=
---------
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 f:/postgresql ... ok
creating directory f:/postgresql/global ... ok
creating directory f:/postgresql/pg_xlog ... ok
creating directory f:/postgresql/pg_xlog/archive_status ... ok
creating directory f:/postgresql/pg_clog ... ok
creating directory f:/postgresql/pg_subtrans ... ok
creating directory f:/postgresql/pg_twophase ... ok
creating directory f:/postgresql/pg_multixact/members ... ok
creating directory f:/postgresql/pg_multixact/offsets ... ok
creating directory f:/postgresql/base ... ok
creating directory f:/postgresql/base/1 ... ok
creating directory f:/postgresql/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in f:/postgresql/base/1 ...=20
Execution of PostgeSQL by a user with administrative permissions is not per=
mitted.
The server must be started under an unpriviledged user ID to prevent possib=
le system security compromises. See the documentation for more information =
on how to properly start the server.
child process was terminated by signal 1
initdb: removing contents of data directory "f:/postgresql"
------------------------------------------------------------ ---------------=
------------
3)so I try the following command:
runas /user:postgres cmd
then run initdb again as previously and get the following:
------------------------------------------------------------ ---------------=
------------
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 f:/postgresql ... initdb: could no=
t change permissions of directory "F:/PostgreSQL": Permission denied'
------------------------------------------------------------ ---------------=
------------
I had no trouble installing on Win XP Pro on my desktop, but am stumped on =
XPhome.
Can anyone push me in the right direction?
Thanks for your time
:-)Dave
--=20
___________________________________________________
Play 100s of games for FREE! http://games.mail.com/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Report this message |
#2: Re: Trouble installing on XP home
Posted on 2006-01-24 12:44:30 by Magnus Hagander
> Here are the steps I performed and the generated messages:
>=20
> 1)I ran the install program (postgresql-8.1) the data=20
> directory chosen is a folder located in a NTFS logical drive=20
> (F:\PostgreSQL\), the remainder of the drive being of FAT type.
>=20
> error message: "Failed to run initdb: 1!"
> the initdb log reads as follows:
>=20
>
> ------------------------------------------------------------ --
> ----------------------------------
> The files belonging to this database system will be=20
> owned by user "postgresusr".
> This user must also own the server process.
>=20
> The database cluster will be initialized with locale C.
>=20
> fixing permissions on existing directory F:/PostgreSQL=20
> ... initdb: could not change permissions of directory=20
> "F:/PostgreSQL": Permission denied
>
> ------------------------------------------------------------ --
> ----------------------------------
This is your problem. The service account must have permissions on the
directory you install to. See the FAQ.
> 2) I ran the install again, but this time uncheck 'install as service'
> I opened a Command Prompt and executed the following:
>=20
> cd \program files\postgresql\8.1\bin
> initdb --locale=3DC --username=3Dpostgres -W -A md5 -E=20
> UNICODE -D f:\postgresql
>=20
> I get the following:
>=20
> ------------------------------------------------------------ --
> ----------------------
> The files belonging to this database system will be owned by=20
> user "postgres".
> This user must also own the server process.
>=20
> The database cluster will be initialized with locale C.
>=20
> fixing permissions on existing directory f:/postgresql ... ok=20
> creating directory f:/postgresql/global ... ok creating=20
> directory f:/postgresql/pg_xlog ... ok creating directory=20
> f:/postgresql/pg_xlog/archive_status ... ok creating=20
> directory f:/postgresql/pg_clog ... ok creating directory=20
> f:/postgresql/pg_subtrans ... ok creating directory=20
> f:/postgresql/pg_twophase ... ok creating directory=20
> f:/postgresql/pg_multixact/members ... ok creating directory=20
> f:/postgresql/pg_multixact/offsets ... ok creating directory=20
> f:/postgresql/base ... ok creating directory=20
> f:/postgresql/base/1 ... ok creating directory=20
> f:/postgresql/pg_tblspc ... ok selecting default=20
> max_connections ... 10 selecting default shared_buffers ...=20
> 50 creating configuration files ... ok creating template1=20
> database in f:/postgresql/base/1 ...=20
>=20
> Execution of PostgeSQL by a user with administrative=20
> permissions is not permitted.
> The server must be started under an unpriviledged user ID to=20
> prevent possible system security compromises. See the=20
> documentation for more information on how to properly start=20
> the server.
> child process was terminated by signal 1
> initdb: removing contents of data directory "f:/postgresql"
> ------------------------------------------------------------ --
> -------------------------
You need to run this as the service user, not as yourself. This user
must not be an admin. This is also in the FAQ.
> 3)so I try the following command:
>=20
> runas /user:postgres cmd
>=20
> then run initdb again as previously and get the following:
>=20
> ------------------------------------------------------------ --
> -------------------------
> The files belonging to this database system will be owned by=20
> user "postgres".
> This user must also own the server process.
>=20
> The database cluster will be initialized with locale C.
>=20
> fixing permissions on existing directory f:/postgresql ...=20
> initdb: could not change permissions of directory=20
> "F:/PostgreSQL": Permission denied'
> ------------------------------------------------------------ --
> -------------------------
And you're back at needing to grant permissions to the service account
on f:\postgresql. The FAQ lists the required permissions.
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Report this message |
