authentication failure

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 csv;","psql" 2018-04-12 00:10:48.765 CDT,"csi

Re: authentication failure

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 csv;",,,

Re: authentication failure

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

> 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 server manually? > Somethi

Re: authentication failure

> 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 list. >>> Yes and worked fine until two days ago >>> I

Re: authentication failure

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 process

Re: authentication failure

> 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 authnetication stops working f

Re: authentication failure

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 is almost like the authnetic

Re: authentication failure

> On Apr 12, 2018, at 9:48 AM, Adrian Klaver wrote: > > 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 #aut

Re: authentication failure

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

Re: authentication failure

> 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.: >>> >>> https://www.postgresql.org/docs/10

Table schema inhancement

Hi, I have these tables: price_per_occupation: id (integer), product_price_period_id(integer), occupation_type(integer), price (numeric) product_price_period; id(integer), product_id(integer), is_monday(boolean), is_tuesday(boolean), is_wednesday(boolean), is_thursday(boolean), is_friday(boolean),