>Von: Adrian Klaver <adrian.kla...@aklaver.com> >An: thomas.deboben....@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....@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.kla...@aklaver.com Many thanks, Thomas
