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

>Von: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
>An: Thomas(dot)Deboben(dot)ext(at)rohde-schwarz(dot)com, pgsql-general(at)postgresql(dot)org
>Datum: 09.12.2016 22:21
>Betreff: Re: [GENERAL] 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?
I'm working with PostgreSQL 9.5.0.1.
We download the Win x86-32 and Win x86-64 installation packages from
http://www.enterprisedb.com/products-services-training/pgdownload#windows

>
>> 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:
Yes we use the standard port 5432

>1) Do you know that the server is actually up and running at the point
>you run the scripts?
Atually I havn't really checked when the installer will start the service.
And as I said, I'm not able to get this error reproduced.
>
>2) Is the server listening on port 5432?
Yes.
>
>3) Is Windows properly mapping localhost?
Yes.

When I got remote access to these machines after some time
the service was running and I could lauch the sql script from pgAdmin
without any problem.

>
>> All installations do run on Windows 7 Pro x64.
>>
>> Best regards,
>> Thomas Deboben
>
>
>--
>Adrian Klaver
>adrian(dot)klaver(at)aklaver(dot)com

Many thanks,
Thomas