[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)
From:       Adrian Klaver <adrian.klaver () aklaver ! com>
Date:       2020-01-27 20:41:21
Message-ID: a8aa8ee1-2452-8c9e-d757-448605ac392c () aklaver ! com
[Download RAW message or body]

On 1/27/20 8:37 AM, Tanja Savic wrote:
> Hi,
> 
> I reset tcpip stack but didn't work, same error and behavior.

Next ideas:

1) Check the Windows system logs for any clues.

2) Did you recently upgrade pgAdmin?

3) How did you install pgAdmin?

> 
> 
> Tanja
> 
> -----Original Message-----
> From: Adrian Klaver <adrian.klaver@aklaver.com>
> Sent: Friday, January 24, 2020 5:30 PM
> To: Tanja Savic <tanja.savic@crossmasters.com>; pgsql-general@lists.postgresql.org
> Subject: Re: PostgresSQL 10 on remote server - Socket is not connected \
> (0x00002749/10057) 
> On 1/24/20 2:31 AM, Tanja Savic wrote:
> > Hi,
> > 
> > Thank you for your replies.
> > 
> > I can connect to remote server using psql and it works normally, I can do the \
> > select, function calls.. 
> > But in pgAdmin, even SELECT 1 doesn't work.
> > 
> > Also, the weirdest thing is that it actually worked for a brief moment, because I \
> > logged using pgAdmin and created some simple function  which I can call without a \
> > problem when I'm logged using psql. But to call it from pgAdmin, it gives me the \
> > error again (Socket is not connected (0x00002749/10057))
> 
> From the pgAdmin issue tracker(you will need Postgres community account to see \
> below): 
> https://redmine.postgresql.org/issues/4970
> 
> The relevant part:
> 
> "An error occured opening the socket after Windows Update from 17.09 to
> 19.09:
> 
> could not send data to server: Socket is not connected
> (0x00002749/10057) could not send startup packet. Socket is not connected \
> (0x00002749/10057) 
> "
> 
> "There is discussion here on this -
> https://answers.microsoft.com/en-us/windows/forum/windows_10-networking/some-programsapps-unable-to-connect-after-windows/689f7204-63fa-4f03-857a-3e4b0ff7d0ce
>  One of the solution was to reset tcpip stack. I would suggest you to try
> it once.
> Kindly let us know if it fixed for you."
> 
> There was no response from the issue submitter so I assume the above worked.
> 
> > 
> > BR,
> > Tanja
> > 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


[prev in list] [next in list] [prev in thread] [next in thread]