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.klaver@xxxxxxxxxxx
