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-12 15:07:29
Message-ID: 52B15D81-F467-4ACF-B23E-8760737BEF75@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Apr 12, 2018, at 9:55 AM, Adrian Klaver <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
>>>
>>> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message camarillo 2018-04-12 19:10:44 Re: pg_basebackup restore a single table
Previous Message Adrian Klaver 2018-04-12 14:55:19 Re: authentication failure