PostgreSQL installed with errors

PostgreSQL 9.1 asks less questions during install than SQL Server 2008. That sure makes it seem easier, but it’s academic if it installs with errors:

Error dialog one said:

A non-fatal error occurred whilst loading database modules.
Please check the installation log in C:UsersScoAppDataLocalTemp

Error dialog two immediately followed to say:

Problem running post-install step. Installation may not complete correctly
Error reading file C:/Program Files/PostgreSQL/9.1/data/postgresql.conf

The text of each was not copyable or clickable.

There are two files in the Temp directory: bitrock_installer.log and install-postgresql.log. They appear to be identical to each other.

According to the files, the PostgreSQL service started successfully:

Script output:
 Starting postgresql-9.1
Service postgresql-9.1 started successfully
startserver.vbs ran to completion

In Windows Services there is a new service called postgres-9.1, startup type Automatic, logging on as .postgres.

Appartently the install script failed to load some additional SQL modules:

Loading additional SQL modules...
Executing cscript //NoLogo "C:Program FilesPostgreSQL9.1installerserverloadmodules.vbs" "postgres" "****" "C:Program FilesPostgreSQL9.1" "C:Program FilesPostgreSQL9.1data" 5432
Script exit code: 2

Script output:
 Installing the adminpack module in the postgres database...
    Executing 'C:UsersScoAppDataLocalTempradA7A3D.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 FilesPostgreSQL9.1installerserverloadmodules.vbs" "postgres" "****" "C:Program FilesPostgreSQL9.1" "C:Program FilesPostgreSQL9.1data" 5432 : Program ended with an error exit code

And there was an error to read what looks like a configuration file:

Problem running post-install step. Installation may not complete correctly
 Error reading file C:/Program Files/PostgreSQL/9.1/data/postgresql.conf

When I attempt to connect to the new instance using the command line client psql, my connection is refused:

C:Program FilesPostgreSQL9.1bin>psql
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?

It’s late, so I’m going to sleep on it. My suspicion is that I should have run the installer under an Administrator account rather than just running the exe straight out of Opera. If Administrator rights are required for successful installation, this should be made clear at the beginning of the installation process.

Whatever the cause of failure, the error dialogs could be more helpful, by showing me the text of the error directly instead of making me type out a directory name into Explorer to look for an unspecified log file.

Advertisements

One thought on “PostgreSQL installed with errors

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s