Обсуждение: [GENERAL] Windows installation - could not connect to server: Connectionrefused (0x0000274D/10061)
[GENERAL] Windows installation - could not connect to server: Connectionrefused (0x0000274D/10061)
От
Thomas.Deboben.ext@rohde-schwarz.com
Дата:
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 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?
'
2016.08.02 14:59:09, Info , LaunchProcess(), 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' returned: '2'.
2016.08.02 14:59:09, Error , InstallContestDB(), Contestdb not restored -> create Contestdb and tables
2016.08.02 14:59:09, Info , LaunchProcess(), Launch 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' with ' -U postgres --file "C:\Program Files\PostgreSQL\9.5\Contest\CreateContestDB.sql"'.
2016.08.02 14:59:11, Info , LaunchProcess(), Standard output: ''
2016.08.02 14:59:11, 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?
'
2016.08.02 14:59:11, Info , LaunchProcess(), 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' returned: '2'.
2016.08.02 14:59:11, Info , LaunchProcess(), Launch 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' with ' -U postgres --dbname Contestdb --file "C:\Program Files\PostgreSQL\9.5\Contest\CreateContestDBTables.sql"'.
2016.08.02 14:59:13, Info , LaunchProcess(), Standard output: ''
2016.08.02 14:59:13, 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?
'
2016.08.02 14:59:13, Info , LaunchProcess(), 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' returned: '2'.
---
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.
All installations do run on Windows 7 Pro x64.
Best regards,
Thomas Deboben
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 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?
'
2016.08.02 14:59:09, Info , LaunchProcess(), 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' returned: '2'.
2016.08.02 14:59:09, Error , InstallContestDB(), Contestdb not restored -> create Contestdb and tables
2016.08.02 14:59:09, Info , LaunchProcess(), Launch 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' with ' -U postgres --file "C:\Program Files\PostgreSQL\9.5\Contest\CreateContestDB.sql"'.
2016.08.02 14:59:11, Info , LaunchProcess(), Standard output: ''
2016.08.02 14:59:11, 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?
'
2016.08.02 14:59:11, Info , LaunchProcess(), 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' returned: '2'.
2016.08.02 14:59:11, Info , LaunchProcess(), Launch 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' with ' -U postgres --dbname Contestdb --file "C:\Program Files\PostgreSQL\9.5\Contest\CreateContestDBTables.sql"'.
2016.08.02 14:59:13, Info , LaunchProcess(), Standard output: ''
2016.08.02 14:59:13, 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?
'
2016.08.02 14:59:13, Info , LaunchProcess(), 'C:\Program Files\PostgreSQL\9.5\bin\psql.exe' returned: '2'.
---
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.
All installations do run on Windows 7 Pro x64.
Best regards,
Thomas Deboben
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? > 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.klaver@aklaver.com
> PostgreSQL 9.5.0.1 Why 9.5.0 and not 9.5.5, which has a LOT of bug fixes ? not saying thats your problem here, it sounds more like sequencing as per Adrian's reply... -- john r pierce, recycling bits in santa cruz
Re: [GENERAL] Windows installation - could not connect to server:Connection refused (0x0000274D/10061)
От
Thomas.Deboben.ext@rohde-schwarz.com
Дата:
>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
On 12/16/2016 07:01 AM, Thomas.Deboben.ext@rohde-schwarz.com wrote: >>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) >> >>> 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 That is what you are using now but what where you using when, from first post: "This has worked for different version, but now we get sometimes trouble ..." >>> 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. Seems it would be helpful to put something in the script to check the server status and log it before trying to connect to it. >> >>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. To me indicates this is an order of execution issue. The script is running the connect/create scripts before the server is up and available for connections. > >> >>> All installations do run on Windows 7 Pro x64. >>> >>> Best regards, >>> Thomas Deboben >> >> >>-- >>Adrian Klaver >>adrian.klaver@aklaver.com > > Many thanks, > Thomas -- Adrian Klaver adrian.klaver@aklaver.com
Re: [GENERAL] Windows installation - could not connect to server:Connection refused (0x0000274D/10061)
От
Thomas.Deboben.ext@rohde-schwarz.com
Дата:
>Von: Adrian Klaver <adrian.klaver@aklaver.com>
>An: Thomas.Deboben.ext@rohde-schwarz.com, pgsql-general@postgresql.org
>Datum: 19.12.2016 19:05
>Betreff: Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)
>
>On 12/16/2016 07:01 AM, Thomas.Deboben.ext@rohde-schwarz.com wrote:
>>>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)
>>>
>
>>>> 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
>
>That is what you are using now but what where you using when, from first
>post:
>
>"This has worked for different version, but now we get sometimes trouble
>..."
>
I ment different versions fo our product.
But I had also installer including PostgreSQL 9.3.4.1, 9.3.6.1 and 9.4.4.3.
>>>> 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.
>
>Seems it would be helpful to put something in the script to check the
>server status and log it before trying to connect to it.
How can I check the server status?
Is this simply if the postgres service is running, or if some sql command can connect the postgres port?
>>>
>>>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.
>
>To me indicates this is an order of execution issue. The script is
>running the connect/create scripts before the server is up and available
>for connections.
>
But the first failing call is inside the original PostgreSQL installer package,
where I have no influence on.
So already here is the problem.
This is from bitrock_installer.log
...
[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
...
But the lines above seems to be fine
...
Starting the database server...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.5\installer\server\startserver.vbs" postgres
Script exit code: 0
Script output:
Starting postgres
Service postgres started successfully
startserver.vbs ran to completion
...
>>
>>>
>>>> All installations do run on Windows 7 Pro x64.
>>>>
>>>> Best regards,
>>>> Thomas Deboben
>>>
>>>
>>>--
>>>Adrian Klaver
>>>adrian.klaver@aklaver.com
>>
>> Many thanks,
>> Thomas
>--
>Adrian Klaver
>adrian.klaver@aklaver.com
Thanks,
Thomas
>An: Thomas.Deboben.ext@rohde-schwarz.com, pgsql-general@postgresql.org
>Datum: 19.12.2016 19:05
>Betreff: Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)
>
>On 12/16/2016 07:01 AM, Thomas.Deboben.ext@rohde-schwarz.com wrote:
>>>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)
>>>
>
>>>> 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
>
>That is what you are using now but what where you using when, from first
>post:
>
>"This has worked for different version, but now we get sometimes trouble
>..."
>
I ment different versions fo our product.
But I had also installer including PostgreSQL 9.3.4.1, 9.3.6.1 and 9.4.4.3.
>>>> 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.
>
>Seems it would be helpful to put something in the script to check the
>server status and log it before trying to connect to it.
How can I check the server status?
Is this simply if the postgres service is running, or if some sql command can connect the postgres port?
>>>
>>>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.
>
>To me indicates this is an order of execution issue. The script is
>running the connect/create scripts before the server is up and available
>for connections.
>
But the first failing call is inside the original PostgreSQL installer package,
where I have no influence on.
So already here is the problem.
This is from bitrock_installer.log
...
[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
...
But the lines above seems to be fine
...
Starting the database server...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.5\installer\server\startserver.vbs" postgres
Script exit code: 0
Script output:
Starting postgres
Service postgres started successfully
startserver.vbs ran to completion
...
>>
>>>
>>>> All installations do run on Windows 7 Pro x64.
>>>>
>>>> Best regards,
>>>> Thomas Deboben
>>>
>>>
>>>--
>>>Adrian Klaver
>>>adrian.klaver@aklaver.com
>>
>> Many thanks,
>> Thomas
>--
>Adrian Klaver
>adrian.klaver@aklaver.com
Thanks,
Thomas
On 12/26/2016 11:43 PM, Thomas.Deboben.ext@rohde-schwarz.com wrote: >>>>> 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 >> >>That is what you are using now but what where you using when, from first >>post: >> >>"This has worked for different version, but now we get sometimes trouble >>..." >> > I ment different versions fo our product. > But I had also installer including PostgreSQL 9.3.4.1, 9.3.6.1 and 9.4.4.3. So does the issue follow the change in your product version or the change in Postgres version? In other words do the Postgres 9.4- versions install correctly with the new version of your product? Also what changed with the new version of your product, in particular with the install process? > >>>>> 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. >> >>Seems it would be helpful to put something in the script to check the >>server status and log it before trying to connect to it. > > How can I check the server status? > Is this simply if the postgres service is running, or if some sql > command can connect the postgres port? Since the issues seem to be with connecting, I would say testing for a connection using psql would be the way to go. > >> >>To me indicates this is an order of execution issue. The script is >>running the connect/create scripts before the server is up and available >>for connections. >> > > But the first failing call is inside the original PostgreSQL installer > package, > where I have no influence on. > So already here is the problem. Yeah, I missed that earlier. > > This is from bitrock_installer.log > ... > [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 > ... > > But the lines above seems to be fine > ... > Starting the database server... > Executing cscript //NoLogo "C:\Program > Files\PostgreSQL\9.5\installer\server\startserver.vbs" postgres > Script exit code: 0 > > Script output: > Starting postgres > Service postgres started successfully > startserver.vbs ran to completion > ... I do not install on Windows so this is getting a bit out of my league. Is the above from the install log? If so can you show the entire install log? >>> >>>> >>>>> All installations do run on Windows 7 Pro x64. >>>>> >>>>> Best regards, >>>>> Thomas Deboben >>>> >>>> >>>>-- >>>>Adrian Klaver >>>>adrian.klaver@aklaver.com >>> >>> Many thanks, >>> Thomas >>-- >>Adrian Klaver >>adrian.klaver@aklaver.com > > Thanks, > Thomas -- Adrian Klaver adrian.klaver@aklaver.com