RE: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

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))

BR,
Tanja

-----Original Message-----
From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Wednesday, January 22, 2020 5:15 PM
To: Tanja Savic <tanja(dot)savic(at)crossmasters(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

On 1/22/20 2:18 AM, Tanja Savic wrote:
> Hi,
>
> I'm running a pgAdmin from Windows 10 :
>
> pgAdmin Version: 4.17
>
> Python Version:**3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 21:26:53) [MSC
> v.1916 32 bit (Intel)]
>
> and I'm able to connect to the remote server. I can see schemas and
> tables, but when I want to run a query I get this error:
>
> could not send data to server: Socket is not connected
> (0x00002749/10057) could not send SSL negotiation packet: Socket is
> not connected (0x00002749/10057)

What are the connection settings?

What is the query that fails?

Can you connect to the remote using psql?

>
> Running queries on local DB instance is ok, error happens only when I
> connect to the remote server.
>
> DB Version : PostgresSQL 10.10
>
> I do not remember doing some changes that could cause this error. Is
> there any solution for this problem, cause I didn't googled out any?
>
> Thank you for you time.
>
> Best,
>
> Tanja
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com