Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 12.2 \(3445.102.3\))
Subject: Re: Connection issue
From: Maximilian Tyrtania <maximilian.tyrtania@gmail.com>
In-Reply-To: <715197e9-84a1-d975-c29b-a3f054478c02@aklaver.com>
Date: Tue, 5 Feb 2019 16:18:05 +0100
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <FCD3C193-D9E9-4B94-BBC0-A919AE8775DF@gmail.com>
References: <4558AEAB-975E-495D-9001-409CD5A9E84E@gmail.com>
 <715197e9-84a1-d975-c29b-a3f054478c02@aklaver.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Precedence: bulk

Hi,

> On 5. Feb 2019, at 15:57, Adrian Klaver <adrian.klaver@aklaver.com> =
wrote:
>=20
> On 2/5/19 1:48 AM, Maximilian Tyrtania wrote:
>> For some reason I can't connect to my PG 10.6.1 Server (running on =
Ubuntu) from my Windows installation (run via Parallels on my Mac), no =
matter what app I use (tried psql, PGAdmin and my own app).
>=20
> Has it ever connected?

Yes, it connected without issues last week.

> Have you recently updated any of the involved software?

Well, sure, but after I saw I couldn't connect I downloaded the current =
version of PGAdmin and psql and couldn't connect with them either.

> More below.
>=20
>> When trying to connect from PGAdmin 4 the server logs say:
>> 2019-02-05 10:34:30.558 CET [31051] [unbekannt]@[unbekannt] LOG:  =
00000: Verbindung empfangen: =
Host=3Dip5b4054ce.dynamic.kabel-deutschland.de Port=3D50262
>> 2019-02-05 10:34:30.558 CET [31051] [unbekannt]@[unbekannt] ORT:  =
BackendInitialize, postmaster.c:4249
>> 2019-02-05 10:34:30.648 CET [31051] [unbekannt]@[unbekannt] LOG:  =
08006: konnte Daten vom Client nicht empfangen: Connection reset by peer
>> 2019-02-05 10:34:30.648 CET [31051] [unbekannt]@[unbekannt] ORT:  =
pq_recvbuf, pqcomm.c:978
>> ("konnte Daten vom Client nicht empfangen" means "couldn't receive =
data from client")
>> PGAdmin says the usual " Unable to connect to server:..."
>> No issue connecting from the Mac.
>> I see in the logfile that other windows users did connect =
successfully from their windows boxes so I am ready to believe that =
maybe my Parallels somehow disconnects the connection quickly or =
something.
>> Another strange thing is that if I try to connect from my Xojo app =
(which uses libpq internally) it says:SSL error: unknown protocol. I had =
no issue connecting last week from that installation so I am at my wits =
end...
>=20
> Where is the Xojo app running?
>=20
> Is the pg_hba.conf on the server set up to allow connections from the =
client machines?

Yes. Also the errormessage wouldn't be "Connection reset by peer" if it =
was a pga_hba.conf issue, would it? And anyway, I can connect just fine =
from my Mac with the same credentials. I wonder if this is maybe some =
Parallels issue.

Thanks,
Max=