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

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(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.

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

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