When attempting to upgrade PostgreSQL on Windows XP using the One-Click installer provided by EnterpriseDB I received the below error.
Error copying file from packed archive C:/downloads/postgresql-8.3.5-2-windows.exe to C:/Program Files/PostgreSQL/8.3/bin/comerr32.dll
After receiving this error I aborted the upgrade at which time Windows popped up the below error.
There has been an error
Unable to copy file
The application will exit now
After the application aborted I decided to switch to the pgInstaller provided on the PostgreSQL web site instead. To download the pgInstaller visit this URL, choose the version you want to upgrade to, choose the win32 sub directory inside the version directory, and then choose the postgresql zip file. Once downloaded unpack the zip file and then click on upgrade.bat. This will initiate an upgrade sequence instead of a fresh install.
The upgrade complained about cygwin being in my $PATH however I continued. I then received an error for another application I had open called SecureCRT. I closed this application and continued with the upgrade. I didn’t receive any other errors and my PostgreSQL is now upgraded to the latest version which at this point is PostgreSQL 8.3.5-2.
I assume the One-Click installer might have worked with SecureCRT closed but am not sure at this point.