From: | armand pirvu <armand(dot)pirvu(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: authentication failure |
Date: | 2018-04-16 01:22:03 |
Message-ID: | 668C670E-2EEA-4D48-8B04-3D301FDACC13@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Apr 12, 2018, at 10:07 AM, armand pirvu <armand(dot)pirvu(at)gmail(dot)com> wrote:
>
>
>> On Apr 12, 2018, at 9:55 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> On 04/12/2018 07:50 AM, armand pirvu wrote:
>>
>>>> I would be inclined to raise the authentication_timeout first before setting the auth method to trust.
>>>>
>>>> I would also set the below.:
>>>>
>>>> https://www.postgresql.org/docs/10/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT <https://www.postgresql.org/docs/10/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT>
>>>>
>>>> log_connections (boolean)
>>>> Causes each attempted connection to the server to be logged, as well as successful completion of client authentication. Only superusers can change this parameter at session start, and it cannot be changed at all within a session. The default is off.
>>>>
>>>> log_disconnections (boolean)
>>>>
>>>> That will give you a better idea of what is going on connection wise.
>>>>
>>>>
>>>>
>>>> --
>>>> Adrian Klaver
>>>> adrian(dot)klaver(at)aklaver(dot)com
>>> Will do so and report back
>>
>> Also, in a previous post you mentioned:
>>
>> "Yes and worked fine until two days ago"
>>
>> Is the code under version control so you can see if anything changed two days ago?
>>
>> If not, any recollections of significant events from that time period?
>>
>>> Many thanks
>>> Armand
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
> No change in the code
> Only maybe the data volume and potentially the number of what we call events for which that runs
> There was a talk to add some more functionality but never went through
> However I will ask around to see if someone did not forget to say about a change put in place overnight (it happened before)
>
> Thanks
> Armand
>
>
Sorry for the late reply. In and out sll sorts of things which do distract me.
I raised the authentication_timeout and seems okay for now
Thank you for the help
Armand
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-04-16 04:08:53 | Re: authentication failure |
Previous Message | Ron | 2018-04-16 01:16:04 | Re: Password encryption |