Re: [GENERAL] Windows installation - could not connect to server:Connection refused (0x0000274D/10061)
От | Thomas.Deboben.ext@rohde-schwarz.com |
---|---|
Тема | Re: [GENERAL] Windows installation - could not connect to server:Connection refused (0x0000274D/10061) |
Дата | |
Msg-id | OF385AE271.D85E4A6E-ONC125808B.00526061-C125808B.00528725@rohde-schwarz.com обсуждение исходный текст |
Ответ на | Re: [GENERAL] Windows installation - could not connect to server:Connection refused (0x0000274D/10061) (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: [GENERAL] Windows installation - could not connect to server:Connection refused (0x0000274D/10061)
(Adrian Klaver <adrian.klaver@aklaver.com>)
|
Список | pgsql-general |
>Von: Adrian Klaver <adrian.klaver@aklaver.com>
>An: Thomas.Deboben.ext@rohde-schwarz.com, pgsql-general@postgresql.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.Deboben.ext@rohde-schwarz.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.klaver@aklaver.com
Many thanks,
Thomas
>An: Thomas.Deboben.ext@rohde-schwarz.com, pgsql-general@postgresql.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.Deboben.ext@rohde-schwarz.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.klaver@aklaver.com
Many thanks,
Thomas
В списке pgsql-general по дате отправления: