Désinstallation/Installation Postgresql 9.2.4
Bonjour,
J'ai fait de nombreuses tentatives d'installation de PostgreSQL 9.2.4, toutes infructueuses. A chaque fois je m'efforce d'effacer les traces de la précédente tentative, mais manifestement quelque chose doit m'échapper.
Voici le contenu du log d'installation (allégé) install-postgresql.log
Citation:
Log started 09/14/2013 at 08:40:09
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Executing C:\Users\skipper\AppData\Local\Temp/postgresql_installer_37a4a79185/temp_check_comspec.bat
Script exit code: 0
Script output:
"test ok"
Script stderr:
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Data Directory. Setting variable
iDataDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Base Directory. Setting variable
iBaseDirectory to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Service ID. Setting variable iServiceName to
empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Service Account. Setting variable
iServiceAccount to empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Super User. Setting variable iSuperuser to
empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Branding. Setting variable iBranding to
empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Version. Setting variable brandingVer to
empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 Shortcuts. Setting variable iShortcut to
empty value
Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-9.2 DisableStackBuilder. Setting variable
iDisableStackBuilder to empty value
[08:40:14] Existing base directory:
[08:40:14] Existing data directory:
[08:40:14] Using branding: PostgreSQL 9.2
[08:40:14] Using Super User: postgres and Service Account: NT AUTHORITY\NetworkService
[08:40:14] Using Service Name: postgresql-x64-9.2
Executing cscript //NoLogo "C:\Users\skipper\AppData\Local\Temp\postgresql_installer_37a4a79185\prerun_checks.vbs"
Script exit code: 0
Script output:
The scripting host appears to be functional.
Script stderr:
Executing C:\Users\skipper\AppData\Local\Temp\postgresql_installer_37a4a79185\vcredist_x64.exe /passive /norestart
Script exit code: 0
Script output:
Script stderr:
Executing C:\Users\skipper\AppData\Local\Temp\postgresql_installer_37a4a79185\getlocales.exe
Script exit code: 0
........Des lignes de dépaquetage et création de fichiers et répertoires
Unpacking C:\Program Files\PostgreSQL\9.2\symbols\zic.pdb
[08:41:57] Running the post-installation/upgrade actions:
[08:41:57] Write the base directory to the ini file...
[08:41:57] Write the version number to the ini file...
Initialising the database cluster (this may take a few minutes)...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.2/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****"
"C:\Program Files\PostgreSQL\9.2" "C:\Program Files\PostgreSQL\9.2\data" 5432 "English, United States"
Script exit code: 0
Script output:
WScript.Shell Initialized...
Scripting.FileSystemObject initialized...
Called CreateDirectory(C:\Program Files\PostgreSQL\9.2\data)...
Called CreateDirectory(C:\Program Files\PostgreSQL\9.2)...
WScript.Network initialized...
Called IsVistaOrNewer()...
..........
Configuring database server startup...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.2\installer\server\startupcfg.vbs" 9.2 "NT AUTHORITY\NetworkService" "****" "C:
\Program Files\PostgreSQL\9.2" "C:\Program Files\PostgreSQL\9.2\data" "postgresql-x64-9.2"
Script exit code: 0
Script output:
startupcfg.vbs ran to completion
Script stderr:
Creating menu shortcuts...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.2\installer\server\createshortcuts.vbs" 9.2 "postgres" 5432 "PostgreSQL 9.2" "C:
\Program Files\PostgreSQL\9.2" "C:\Program Files\PostgreSQL\9.2\data" "postgresql-x64-9.2"
Script exit code: 0
Script output:
Start FixupFile(C:\Program Files\PostgreSQL\9.2\scripts\serverctl.vbs)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
Start FixupFile(C:\Program Files\PostgreSQL\9.2\scripts\runpsql.bat)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
createshortcuts.vbs ran to completion
Script stderr:
Starting the database server...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.2\installer\server\startserver.vbs" postgresql-x64-9.2
Script exit code: 0
Script output:
Starting postgresql-x64-9.2
Service postgresql-x64-9.2 started successfully
startserver.vbs ran to completion
Script stderr:
Loading additional SQL modules...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files\PostgreSQL
\9.2" "C:\Program Files\PostgreSQL\9.2\data" 5432
Script exit code: 2
Script output:
Installing the adminpack module in the postgres database...
Executing 'C:\Users\skipper\AppData\Local\Temp\rad8A885.bat'...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
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:\Program Files\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files
\PostgreSQL\9.2" "C:\Program Files\PostgreSQL\9.2\data" 5432 : Program ended with an error exit code
[08:42:33] Write the data directory to the ini file...
[08:42:33] Write the port number, service ID, locale and superuser to the ini file...
[08:42:33] Write ServiceID(postgresql-x64-9.2) to registry/ini...
Problem running post-install step. Installation may not complete correctly
Error reading file C:/Program Files/PostgreSQL/9.2/data/postgresql.conf
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 09/14/2013 at 08:42:42
Il est vrai que je ne trouve pas de fichier postgresql.conf dans le répertoire /data
Quelqu'un aurait-il (elle) une idée du problème rencontré, des traces que j'aurais pu laisser, qui provoquerait ce capotage? En particulier, je ne comprends pas cette absence d'entrée dans la base de registres.
Merci d'avance pour votre aide.
Sincères salutations
-----------------------------------------------
OS: Windows 7 Ultimate x64
RAM: 6 GB
Désinstallation/Réinstallation PostgreSQL9.2.4
Bonjour,
Puisque le fichier install-postgresql.log indique que la clef de registre HKLM/PostgreSQL/Installations/postgresql-x64-9.2 n'existait pas, et bien que je ne maîtrise pas bien le bidouillage de la base de registres, j'ai décidé de faire la tentative de créer cette clef, sans valeur initiale.
Cela a fonctionné et PostgreSQL 9.2.4 s'est installé normalement.
J'en ai profité pour créer la clef pour Postgresql 9.3, pour le jour où...
Pourtant je reste perplexe, car je n'aime pas ne pas comprendre totalement: pourquoi l'installateur sous Windows ne crée-t-il pas cette clef? Dans le cas d'une primo installation, il n'y a aucune raison que cette clef existe. Comment ont-alors procédé tous ceux qui se disent enchantés de PostgreSQL?
Merci de votre attention, et toutes mes salutations.