I could not reinstall PostgreSQL + PostGIS correctly on our virtual server.
When installing PostgreSQL, the following error occurs at the end of the process:
"A non-fatal error occurred while loading the database modules. For details, see the installation log in C: ... \ Temp."
Here is what the magazine says:
Loading additional SQL modules... Executing cscript //NoLogo "C:\Programme\PostgreSQL\9.0\installer\server\loadmodules.vbs" "postgres" "****" "C:\Programme\PostgreSQL\9.0" "C:\Programme\PostgreSQL\9.0\data" 5432 Script exit code: 2 Script output: Installing the adminpack module in the postgres database... Executing 'C:\DOKUME~1\Kiesow\LOKALE~1\Temp\rad3C00F.bat'... Couldn't find the output file... Failed to install the 'adminpack' module in the 'postgres' database loadmodules.vbs ran to completion Script stderr: Program ended with an error exit code Error running cscript //NoLogo "C:\Programme\PostgreSQL\9.0\installer\server\loadmodules.vbs" "postgres" "****" "C:\Programme\PostgreSQL\9.0" "C:\Programme\PostgreSQL\9.0\data" 5432 : Program ended with an error exit code
After installation is complete, I can start pgAdmin, log in and create new databases. Everything looks fine until I try to add PostGIS using the stack builder wizard. Installation is complete again when:
"Error creating database." "Want to view the error log?" Create_templatepostgis_db_error.txt ??
This error log does not exist. I can ignore the error and create the db template manually, which works. But I can’t use types like "geometry", so I think PostGIS is not used yet.
Maybe one of you has an idea of what I could have done wrong? Any hints? Can someone help me interpret the error log?
I am using Windows XP, PostgreSQL 9.0 32bit (same with 8.4), PostGIS 1.5.
Postgres 8.3 + PostGIS was previously installed on this system, but I deleted, deleted the data directory and let the installation wizard create a new window user with windows.
Also rebooted somewhat.
And I chose the locale instead of [Default locale] on the Postgres installation.
This is another part of the magazine that I suspect. This is at the very beginning. Perhaps this helps:
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Data Directory. Setting variable iDataDirectory to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Base Directory. Setting variable iBaseDirectory to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Service ID. Setting variable iServiceName to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Service Account. Setting variable iServiceAccount to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Super User. Setting variable iSuperuser to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Branding. Setting variable iBranding to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Version. Setting variable brandingVer to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 Shortcuts. Setting variable iShortcut to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.0 DisableStackBuilder. Setting variable iDisableStackBuilder to empty value [15:44:31] Existing base directory: [15:44:31] Existing data directory: [15:44:31] Using branding: PostgreSQL 9.0 [15:44:31] Using Super User: postgres and Service Account: postgres [15:44:31] Using Service Name: postgresql-9.0 Executing cscript //NoLogo "C:\Dokumente und Einstellungen\Kiesow\Lokale Einstellungen\Temp\prerun_checks.vbs" Script exit code: 0 Script output: The scripting host appears to be functional. Script stderr: Executing cscript //NoLogo "C:\Dokumente und Einstellungen\Kiesow\Lokale Einstellungen\Temp\postgresql_installer\installruntimes.vbs" "C:\Dokumente und Einstellungen\Kiesow\Lokale Einstellungen\Temp\postgresql_installer\vcredist_x86.exe" Script exit code: 3010 Script output: Executing the runtime installer: C:\Dokumente und Einstellungen\Kiesow\Lokale Einstellungen\Temp\postgresql_installer\vcredist_x86.exe The runtime package exited with error code: 3010
M. Kiesow
source share