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

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).
> 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.
>
> I've try to restart the laptop, restart the service but nothing give the
> sign to improve the slow login/connection process.
>
> I've also try to turn off the *log_hostname* config in *postgresql.conf*
> and try to turn off the *Windows Firewall, Windows Defender Real-Time
> Scanner* but nothing works to improve the slow login connection.
>
> I've also try to check the Postgres Log file but not much error shows in
> the log except for this error that appears a few time:
> 2020-07-22 14:43:22.312 +00 [13740] LOG:  could not receive data from
> client: An existing connection was forcibly closed by the remote host.

Is the database server you are connecting to on the laptop or some other
machine?

Where is this Postgres log?

>
> This problem happens with all of the application such as *psql*,
> *pgAdmin*, *Navicat*, all with the same symptoms of slow
> login/connection to my PostgreSQL v12.3 (x64) service and if connected,
> then it will be easy to disconnected.
>
> If needed my laptop specs are:
>
> * Intel Core i7-9750H
> * 16GB of RAM
> * Samsung SSD 970 EVO Plus 2TB
>
> Is database size can affect this connection time required to start a
> database session?

No, a connection does not read the entire database.

> FYI one of my database has size of 209GB, but currently I'm not using or
> connect to that database.
>
> Thanks in advance.
>
> Regards,
> Surya
>
>

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