Trouble installing on XP home - Mailing list pgsql-admin

From Dave M
Subject Trouble installing on XP home
Date
Msg-id 20060115011849.5EDE483C0F@ws1-1.us4.outblaze.com
Whole thread Raw
List pgsql-admin
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:\PostgreSQL\), the remainder of the drive
beingof 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 "postgresusr".
    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 not 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=C --username=postgres -W -A md5 -E UNICODE -D f:\postgresql

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

Execution of PostgeSQL by a user with administrative permissions is not permitted.
The server must be started under an unpriviledged user ID to prevent possible system security compromises. See the
documentationfor 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 not 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


--
___________________________________________________
Play 100s of games for FREE! http://games.mail.com/


pgsql-admin by date:

Previous
From: Sean G
Date:
Subject: Why psql.exe does not work?
Next
From: Alfred
Date:
Subject: Transferring DATA directory