Re: [GENERAL] Help! Access is Denied Installation on WinXP rolled

[Abe Burnett]

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:[EMAIL PROTECTED]
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

[GENERAL] Help! Access is Denied Installation on WinXP rolled back

[Abe Burnett]

Hi All!
I googled for a solution to my problem and then searched the PostgreSQL  
site for solutions and since neither produced an answer I thought I'd  
see if anyone else out there knows how to resolve my dilemna... Any  
assistance is appreciated! Essentially what happens is that I just  
attempt to install PostgreSQL 8.0.2 with the default options and it  
nearly completes the installation but then on the step where it  
initializes (or whatever it's called) the database it crashes and rolls  
back the install. When I check the 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.

MSI (s) (C0:74) [11:03:22:531]: Source for file 'user_lockstxt' is  
compressed 
InstallFiles: File: README.user_locks,  Directory: C:\Program  
Files\PostgreSQL\8.0\doc\contrib\,  Size: 2723 
MSI (s) (C0:74) [11:03:22:531]: Note: 1: 2318 2: C:\Program  
Files\PostgreSQL\8.0\doc\contrib\README.user_locks 
MSI (s) (C0:74) [11:03:22:531]: Executing op:  
FileCopy(SourceName=readm~1.vac|README.vacuumlo,SourceCabKey=vacuumlotxt,DestName=README.vacuumlo,Attributes=0,FileSize=1449,PerTick=32768,,VerifyMedia=1,CheckCRC=0,,,InstallMode=58982400,HashOptions=0,HashPart1=-1578222883,HashPart2=1022240769,HashPart3=1742458498,HashPart4=808312946,,) 
MSI (s) (C0:74) [11:03:22:531]: File: C:\Program  
Files\PostgreSQL\8.0\doc\contrib\README.vacuumlo;To be installed;
Won't patch;No existing file 
MSI (s) (C0:74) [11:03:22:531]: Source for file 'vacuumlotxt' is compressed 
InstallFiles: File: README.vacuumlo,  Directory: C:\Program  
Files\PostgreSQL\8.0\doc\contrib\,  Size: 1449 
MSI (s) (C0:74) [11:03:22:531]: Note: 1: 2318 2: C:\Program  
Files\PostgreSQL\8.0\doc\contrib\README.vacuumlo 
MSI (s) (C0:74) [11:03:22:531]: Executing op: CacheSizeFlush(,) 
MSI (s) (C0:74) [11:03:22:531]: Executing op:  
InstallProtectedFiles(AllowUI=1) 
MSI (s) (C0:74) [11:03:22:531]: Executing op:  
ActionStart(Name=SetPermissions,Description=Setting filesystem  
permissions...,) 
Action 11:03:22: SetPermissions. Setting filesystem permissions... 
MSI (s) (C0:74) [11:03:22:531]: Executing op:  
CustomActionSchedule(Action=SetPermissions,ActionType=1025,Source=BinaryData,[EMAIL PROTECTED],CustomActionData=1033;C:\Program  
Files\PostgreSQL\8.0\;C:\Program  
Files\PostgreSQL\8.0\data\;MYTHOS;postgres;u35351364) 
MSI (s) (C0:14) [11:03:22:546]: Invoking remote custom action. DLL:  
C:\WINDOWS\Installer\MSI100.tmp, Entrypoint: [EMAIL PROTECTED] 
MSI (s) (C0:74) [11:03:23:375]: Executing op:  
ActionStart(Name=RunInitdb,Description=Initializing database cluster  
(this may take a minute or two)...,) 
Action 11:03:23: RunInitdb. Initializing database cluster (this may take  
a minute or two)... 
MSI (s) (C0:74) [11:03:23:390]: Executing op:  
CustomActionSchedule(Action=RunInitdb,ActionType=1025,Source=BinaryData,[EMAIL PROTECTED],CustomActionData=1033;C:\Program  
Files\PostgreSQL\8.0\;C:\Program  
Files\PostgreSQL\8.0\data\;5432;1;C;SQL_ASCII;postgres;u35351364;MYTHOS;postgres;u35351364) 
MSI (s) (C0:14) [11:03:23:390]: Invoking remote custom action. DLL:  
C:\WINDOWS\Installer\MSI101.tmp, Entrypoint: [EMAIL PROTECTED] 
MSI (c) (04:34) [11:03:27:031]: Note: 1: 2205 2:  3: Error 
MSI (c) (04:34) [11:03:27:031]: Note: 1: 2228 2:  3: Error 4: SELECT  
`Message` FROM `Error` WHERE `Error` = 2867 
DEBUG: Error 2867:  The error dialog property is not set 
The installer has encountered an unexpected error installing this  
package. This may indicate a problem with this package. The error code  
is 2867. The arguments are: , , 
MSI (c) (04:34) [11:03:27:031]: Font created.  Charset: Req=0, Ret=0,  
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg 

Failed to run initdb: 1! 
Please see the logfile in 'C:\Program Files\PostgreSQL\8.0\tmp\initdb.log'. 
Note! You must read/copy this logfile before you click OK, or it will be  
automatically removed. 
MSI (s) (C0!3C) [11:03:32:093]: Note: 1: 2205 2:  3: Error 
MSI (s) (C0!3C) [11:03:32:093]: Note: 1: 2228 2:  3: Error 4: SELECT  
`Message` FROM `Error` WHERE `Error` = 1709 
MSI (s) (C0!3C) [11:03:32:093]: Product: PostgreSQL 8.0 -- Failed to run  
initdb: 1! 
Please see the logfile in 'C:\Program Files\PostgreSQL\8.0\tmp\initdb.log'. 
Note! You must read/copy this logfile before you click OK, or it will be  
automatically removed. 

Action ended 11:03:32: InstallFinalize. Return value 3. 
MSI (s) (C0:74) [11:03:32:109]: User policy value 'DisableRollback' is 0 
MSI (s) (C0:74) [11:03:32:109]: Machine policy value 'DisableRollback' is 0 
MSI (s) (C0:74) [11:03:32:531]: Executing op: