Discussion :

[aandre2937]

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

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

[aandre2937]

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.