Thanks for helping Joshua!
While I do attempt to install PostgreSQL using my normal windows account
(which of course has administrative rights), I've installed PostgreSQL
before and never run into this problem. It appears that as long as you
establish a different user name which isn't an administrator to run the
service under then it should be ok. The problem with actually attempting
to do the entire install under a non-administrative account is that
naturally windows doesn't let it touch any system directories (i.e. the
Windows directory - which PostgreSQL needs access to) and won't let it
modify any permissions. Essentially, literally installing an application
with a non-administrative account is nearly impossible because that's
the whole purpose of having such things as non-administrative accounts.
I'm probably preaching to the choir here. Sorry about that. Here's the
contents of my init.db log if it helps...
>>>>>>>>>>>>>>>>>>>>>>>>>>
The files belonging to this database system will be owned by user
"Administrator".
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/data ... ok
creating directory C:/Program Files/PostgreSQL/8.0/data/global ... ok
creating directory C:/Program Files/PostgreSQL/8.0/data/pg_xlog ... ok
creating directory C:/Program
Files/PostgreSQL/8.0/data/pg_xlog/archive_status ... ok
creating directory C:/Program Files/PostgreSQL/8.0/data/pg_clog ... ok
creating directory C:/Program Files/PostgreSQL/8.0/data/pg_subtrans ... ok
creating directory C:/Program Files/PostgreSQL/8.0/data/base ... ok
creating directory C:/Program Files/PostgreSQL/8.0/data/base/1 ... ok
creating directory C:/Program Files/PostgreSQL/8.0/data/pg_tblspc ... ok
selecting default max_connections ... Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
10
selecting default shared_buffers ... Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
50
creating configuration files ... ok
creating template1 database in C:/Program
Files/PostgreSQL/8.0/data/base/1 ... ok
initializing pg_shadow ... Access is denied.
child process was terminated by signal 1
initdb: removing contents of data directory "C:/Program
Files/PostgreSQL/8.0/data"
Joshua D. Drake wrote:
log file it tells me to check before it deletes it in the rollback
it says repeatedly something about "access is denied". Below is the
actual install log (or a small portion of it, near the end where the
error occurs). Any ideas? Regards, Abe p.s. this is a repost from my
initial post on the novice list... which I've become aware is
relatively inactive.
Did you check the initdb.log that was referenced in your Windows error
message?
I do not "know" this to be your issue but I am guess that you tried to
install PostgreSQL with Administrator (or as an Administrator) rights.
PostgreSQL must be installed as a non Administrative user on Windows.
Sincerely,
Joshua D. Drake
begin:vcard
fn:Abe Burnett
n:Burnett;Abe
adr:;;4143 Rain Roper Drive;Bozeman;MT;59715;USA
email;internet:abe.burnett@xxxxxxxxx
tel;home:1-406-582-0870
x-mozilla-html:TRUE
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
