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,Target=SetPermissions@4,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: SetPermissions@4 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,Target=RunInitdb@4,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: RunInitdb@4 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: Header(Signature=1397708873,Version=301,Timestamp=848320614,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1) MSI (s) (C0:74) [11:03:32:531]: Executing op: DialogInfo(Type=0,Argument=1033) MSI (s) (C0:74) [11:03:32:531]: Executing op: DialogInfo(Type=1,Argument=PostgreSQL 8.0) MSI (s) (C0:74) [11:03:32:531]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1]) Action 11:03:32: Rollback. Rolling back action:
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
