Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10

On 23-07-2020 06:12, Rob Sargent wrote:
>
>
>> On Jul 22, 2020, at 4:58 PM, Surya Widyanto <ayrus02(at)gmail(dot)com
>> <mailto:ayrus02(at)gmail(dot)com>> wrote:
>>
>> On 23-07-2020 05:26, Adrian Klaver wrote:
>>> On 7/22/20 10:24 AM, Surya Widyanto wrote:
>>>> Hi,
>>>>
>>>> I have PostgreSQL v12.3 (x64) installed on my Laptop running
>>>> Windows 10 Home Single Language (64-bit).
>>>> In two or three times since I fresh install the PostgreSQL and
>>>> windows on 17-05-2020, 06:04:56 (GMT).
>>>
>>> Meant to ask earlier, where did you install Postgres from?
>>>
>> I've download the installer executable from
>> https://www.enterprisedb.com/downloads/postgres-postgresql-downloads,
>> the Windows x86-64 version.
>>
>> Then I've install it on my Windows with binaries path to *"C:\Program
>> Files\PostgreSQL\12\" *and for data path to *"H:\PostgreSQL\Data\12.x\"*.
>> Both *C:* and *H:* drive are partition on my NVMe PCIe Gen. 3 x 4 SSD
>> Drive mentioned earlier.
>>
>> For additional information, I've also install the *PostGIS v3.0
>> r15475 (x64)* for *PostgreSQL v12.*
>>
>>>> By two or three times I mean, if this slow connection problem
>>>> happen, than it wil occur in a view days in a row. Then it will
>>>> return to normal with fast login/connection process.
>>>>
>>>
>>>> Regards,
>>>> Surya
>>>>
>>>>
> Is there by any chance a correlation between your physical location
> and the slowness episodes?
> Any AV software in play?
>

Since this COVID-19 outbreak, I'm working from home. I've try to use
different internet connection to test, one with wired connection
internet provider on my house, and the other are 4G cellular connection
internet from my smartphone and both internet connection I use give the
same effect of slow and easy to drop/disconnect connection to PostgreSQL.
For additional information, I've also had this problem when connectiong
from PHP Application, so that total 4 apps I try to connect with
PostgreSQL (psql, pgAdmin, Navicat, PHP Application Connection)
I'm not installing any AntiVirus software, the only installed AntiVirus
software are WIndows Defender that came with Microsoft Windows.
(Currently I'm Disabling the real time scan on windows defender)

After I activate the DEBUG5 for *log_min_messages* and
*log_min_error_statement*, another line of log came up with the other
log line I mentioned earlier:
2020-07-22 23:31:29.065 +00 [postgres(at)postgres] - 127.0.0.1(10191) -
[1724] (psql) LOG:  could not receive data from client: An existing
connection was forcibly closed by the remote host.
2020-07-22 23:31:29.065 +00 [postgres(at)postgres] - 127.0.0.1(10191) -
[1724] (psql) DEBUG:  unexpected EOF on client connection