>Von: Adrian
Klaver <adrian.klaver@xxxxxxxxxxx>
>An: Thomas.Deboben.ext@xxxxxxxxxxxxxxxxx,
pgsql-general@xxxxxxxxxxxxxx
>Datum: 09.12.2016
22:21
>Betreff: Re:
Windows installation - could not connect to server: Connection
refused (0x0000274D/10061)
>
>On 12/09/2016 12:43 AM, Thomas.Deboben.ext@xxxxxxxxxxxxxxxxx
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.klaver@xxxxxxxxxxx
Many thanks,
Thomas
