Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10
Date
Msg-id 14654932-2859-ec62-e6fc-827ac7b5f15f@aklaver.com
Whole thread Raw
In response to Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10  (Surya Widyanto <ayrus02@gmail.com>)
Responses Re: [SOLUTION] Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10
List pgsql-general
On 7/22/20 4:49 PM, Surya Widyanto wrote:
> On 23-07-2020 06:12, Rob Sargent wrote:
>>
>>
>>> On Jul 22, 2020, at 4:58 PM, Surya Widyanto <ayrus02@gmail.com 
>>> <mailto:ayrus02@gmail.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.

I thought you said earlier you where only connecting to the database on 
your laptop at localhost?:

"The Database is on the same machine/laptop, I try to connect using 
localhost and 127.0.0.1, both have the same slow connection problem."

So Internet connection should not be of concern here or is there more to 
this story?



> 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@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@postgres] - 127.0.0.1(10191) - 
> [1724] (psql) DEBUG:  unexpected EOF on client connection
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adam Scott
Date:
Subject: ERROR: out of overflow pages in hash index
Next
From: Christophe Pettus
Date:
Subject: Row estimates for empty tables