Re: authentication failure

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

In response to

Responses

Browse pgsql-general by date

  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