Re: authentication failure

2018-04-15 Thread Adrian Klaver
On 04/15/2018 06:22 PM, armand pirvu wrote: 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 I would take the 'for now' as a heads up that there is underlying issue that will need to be resolved

Re: authentication failure

2018-04-15 Thread armand pirvu
> On Apr 12, 2018, at 10:07 AM, armand pirvu wrote: > > >> On Apr 12, 2018, at 9:55 AM, Adrian Klaver > > wrote: >> >> On 04/12/2018 07:50 AM, armand pirvu wrote: >> I would be inclined to raise the

Re: authentication failure

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

Re: authentication failure

2018-04-12 Thread Adrian Klaver
On 04/12/2018 07:37 AM, armand pirvu wrote: On Apr 12, 2018, at 9:28 AM, Adrian Klaver wrote: On 04/12/2018 07:15 AM, armand pirvu wrote: Sorry for the double posting but could it be from #authentication_timeout = 1min# 1s-600s From you previous post: "It

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:28 AM, Adrian Klaver wrote: > > On 04/12/2018 07:15 AM, armand pirvu wrote: > >>> >>> >> Sorry for the double posting but could it be from >> #authentication_timeout = 1min# 1s-600s > > From you previous post: > > "It is almost like the

Re: authentication failure

2018-04-12 Thread Adrian Klaver
On 04/12/2018 07:15 AM, armand pirvu wrote: Sorry for the double posting but could it be from #authentication_timeout = 1min# 1s-600s From you previous post: "It is almost like the authnetication stops working for whatever reason" So to be clear the initial connections in the

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:12 AM, armand pirvu wrote: > > >> On Apr 12, 2018, at 9:08 AM, Adrian Klaver > > wrote: >> >> On 04/12/2018 06:59 AM, armand pirvu wrote: >> >> Please reply to list also. >> Ccing

Re: authentication failure

2018-04-12 Thread armand pirvu
> On Apr 12, 2018, at 9:08 AM, Adrian Klaver wrote: > > On 04/12/2018 06:59 AM, armand pirvu wrote: > > Please reply to list also. > Ccing list. >> Yes and worked fine until two days ago >> I use .pgpass > > So can you connect from wherever the process is run to the

Re: authentication failure

2018-04-12 Thread Adrian Klaver
On 04/12/2018 06:59 AM, armand pirvu wrote: Please reply to list also. Ccing list. Yes and worked fine until two days ago I use .pgpass So can you connect from wherever the process is run to the server manually? Something like: psql -d birstab -U csidba -h some_server I will also check

Re: authentication failure

2018-04-12 Thread Adrian Klaver
On 04/12/2018 06:51 AM, armand pirvu wrote: Hi there I have a process in place which runs several queries from one host to another one All of a sudden I started noticing authentication failures Like below .009 ms statement: COPY NACDS.tf_show_code_response_person FROM STDIN with