Re: Postgres SQLSTATE[08006] [7] timeout expired

From: Howard Wells <mr284(at)protonmail(dot)com>
To: Howard Wells <mr284(at)protonmail(dot)com>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Condor <condor(at)stz-bg(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres SQLSTATE[08006] [7] timeout expired
Date: 2019-08-25 20:00:33
Message-ID: AJn2uYkam0VV5B43FR2uCBr-gLyKWQVINWCbcxOYGcukbYeLvfWhVAXP0L3crHREMOwO8_RstBdlKBEyzPf_qIyxnFRdk7VlWY6RLxc0-TU=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I enabled "host all all 0.0.0.0/0 trust" in pg_hba.conf and restarted Postgres, but I still get the same behavior. It looks like password authentication is not the issue. I enabled MD5, but I didn't know I would have to do anything else; from this test, that doesn't seem to be the problem. I'm getting the load balancer info. Thanks again.

Howard

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, August 25, 2019 12:48 PM, Howard Wells <mr284(at)protonmail(dot)com> wrote:

> Thanks for the replies. I am getting the information requested by Adrian Klaver. Rob Sargent, I am going to temporary enable full trust because the password authentication could be the issue. Then I'll write back.
>
> Howard
>
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> On Sunday, August 25, 2019 12:20 PM, Rob Sargent robjsargent(at)gmail(dot)com wrote:
>
> > > > > > >
> >
> > > > > > > console.
> > > > > > > The pg_hba.conf has these lines enabled:
> > > > > > > pg_hba.conf:
> > > > > > > host all [username] 0.0.0.0/0 trust
> > > > > > > host all all 0.0.0.0/0 md5
> > > > > > > host all all ::/0 md5
> > > > > > > host all all all
> >
> > Who is encrypting the password?
> >
> > >

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wall 2019-08-25 20:12:30 Re: For SELECT statement (just a reading one, no 'FOR UPDATE'), is COMMIT or ROLLBACK preferred?
Previous Message Howard Wells 2019-08-25 19:48:06 Re: Postgres SQLSTATE[08006] [7] timeout expired