On 23-07-2020 02:07, 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).
>> 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?
>
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.
> Where is this Postgres log?
>
The path of the log is on
*<data_directory>\log\postgresql-%Y-%m-%d_%H%M%S.log*
Is there any config that I can change to get more verbose log
information to trace and debug the connection problem?
>>
>> 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
>>
>>
>
>