Re: Windows installation - could not connect to server: Connection refused (0x0000274D/10061)

On 12/09/2016 12:43 AM, Thomas(dot)Deboben(dot)ext(at)rohde-schwarz(dot)com wrote:
> Hello,
>
> I need some help on an installation issue with PostgreSQL 9.5.0.1
> I have written a wix bootstrapper to install postgresql for our
> application.
> This has worked for different version, but now we get sometimes trouble

Which version did it work on?

> with the installer as some sql scripts can't be executed during install.
> From the logs I see an error 2 retunred from psql.exe
>
> This error is found in the bitrock_installer.log from your original
> installer
> ---
> [14:58:49] Installing the adminpack module in the postgres database...
> Executing C:\Program Files\PostgreSQL\9.5\bin\psql.exe -c "CREATE
> EXTENSION adminpack" -d postgres
> Script exit code: 2
> ---
>
> and as well in our log where we try to launch some more sql scripts to
> create a user, the database and the tables.
> ---
> 2016.08.02 14:59:07, Info , LaunchProcess(), Launch 'C:\Program
> Files\PostgreSQL\9.5\bin\psql.exe' with ' -U postgres --file "C:\Program
> Files\PostgreSQL\9.5\Contest\CreateContestUser.sql"'.
> 2016.08.02 14:59:09, Info , LaunchProcess(), Standard output: ''
> 2016.08.02 14:59:09, Info , LaunchProcess(), Standard error: '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?
> '

>
> So far I wasn't able to reproduce this error by my self, but I know from
> about 5 issues inside the last month.
> As I'm not able to reproduce I would appreciate any help from you to
> find out what causes this error.

The error is pretty straight forward the server cannot be found at
localhost on port 5432, so:

1) Do you know that the server is actually up and running at the point
you run the scripts?

2) Is the server listening on port 5432?

3) Is Windows properly mapping localhost?

> All installations do run on Windows 7 Pro x64.
>
> Best regards,
> Thomas Deboben

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com