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

On 7/22/20 2:43 PM, Surya Widyanto wrote:
> On 23-07-2020 02:07, Adrian Klaver wrote:
>> On 7/22/20 10:24 AM, Surya Widyanto wrote:
>>> Hi,
>>>

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

Take a look here:

https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN

>>> Thanks in advance.
>>>
>>> Regards,
>>> Surya
>>>
>>>
>>
>>
>

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