cancel
Showing results for 
Search instead for 
Did you mean: 

PostgreSQL install failing on Windows Server 2008 R2

Adventurer

PostgreSQL install failing on Windows Server 2008 R2

Hello,

I first tried to install postgresql-11.1-1-windows-x64.exe on Windows Server 2012 R2 and everything went fine.

Then I tried to install postgresql-10.6-1-windows-x64.exe on Windows Server 2008 R2 ( I also tried postgresql Version 9.x / postgresql version 11 doesn't support Windows Server 2008 R2 anymore)

I always get the same error message during initialising the database cluster :

Clipboard03.jpg

In the install-postgresql.log I found:

[15:46:07] Installing the adminpack module in the postgres database...
Executing C:\path\pgsql\bin\psql.exe -c "CREATE EXTENSION adminpack" -d postgres
Script exit code: 2

Script output:

Script stderr:
 psql: konnte nicht mit dem Server verbinden: Connection refused (0x0000274D/10061)
    Läuft der Server auf dem Host »localhost« (::1) und akzeptiert er
    TCP/IP-Verbindungen auf Port 5432?
konnte nicht mit dem Server verbinden: Connection refused (0x0000274D/10061)
    Läuft der Server auf dem Host »localhost« (127.0.0.1) und akzeptiert er
    TCP/IP-Verbindungen auf Port 5432?
Failed to load SQL modules into the database cluster.
[15:46:27] Write the data directory to the ini file...
[15:46:27] Write the port number, service ID, locale and superuser to the ini file...
[15:46:27] Write ServiceID(postgresql-x64-10) to registry/ini...
Problem running post-install step. Installation may not complete correctly
 Error reading file C:/path/pgsql/data/postgresql.conf
[15:46:27] Delete the temporary scripts directory...

I don't understand why the installation always aborts at this point.

localhost is running on this server (within WAMP) so several other web applications are running on this server.

I even opened the TCP/IP port 5432 in the windows firewall.

Does anyone know why the installation doesn't work?

Thank you in advance.

6 REPLIES 6
Moderator

Re: PostgreSQL install failing on Windows Server 2008 R2

Hi There, it seems there are issues while connection to internet to download the additional modules that are required. Can you try opening 'https://sbp.enterprisedb.com/applications.xml' (wihout quotes) from within the WAMP server installation. 

 

Also it would be interesting to know what options did you select during the installation? Can you try unchecking all and just select the database server and then try?

 

Thanks, Amit

Highlighted
Adventurer

Re: PostgreSQL install failing on Windows Server 2008 R2

Hello,

thank you for your response.

Do you mean to try to open the given URL via Webbrowser on the WAMP server?

When I tried to open it this way the XML file was shown.

At first I tried to install all four options.

Yes, I then tried to uncheck all installation options except from the installation of the database server but the installation aborted with the same result as before.

Thank you.

Moderator

Re: PostgreSQL install failing on Windows Server 2008 R2

Can you let us know if you were trying to install to a custom directory or the default folder locations given by the installer?

 

Additionally can you try installing to C:\Postgres folder as a test?

 

Amit

Adventurer

Re: PostgreSQL install failing on Windows Server 2008 R2

Hello,

I tried a custom directory to install PostgreSQL: C:\path\xampp2\pgsql respectively C:\path\xampp2\pgsql\data.

Now I tried the test installation into C:\Postgres and it finally worked.

But I don't understand why it's not possible to choose a custom directory?

 

EDB Team Member

Re: PostgreSQL install failing on Windows Server 2008 R2

Hi,

I tried the installation for postgres installation for postgresql-10.6-1-windows-x64.exe using default directory as well as custom directory. It is working fine with me.

Looks like there may be some permission issue on your machine for the custom path you are providing.

 

Ajinkya

Adventurer

Re: PostgreSQL install failing on Windows Server 2008 R2

Hello,

ok thank you for your response and your suggestions.

I'll check if there is any permission issue concerning our custom directory.