Re: Postgres SQLSTATE[08006] [7] timeout expired - Mailing list pgsql-general

From Howard Wells
Subject Re: Postgres SQLSTATE[08006] [7] timeout expired
Date
Msg-id NejU1rf6oEolnfmonxKZXVlxZ85kAklRpOCF469uv55IbqWQ6t8Rnrb8dImn_d0_nwI4qQt0tviV_dSSKUQ4AHPOyb-JyEutIEn7kpaWZSs=@protonmail.com
Whole thread Raw
In response to Re: Postgres SQLSTATE[08006] [7] timeout expired  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Postgres SQLSTATE[08006] [7] timeout expired  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
I solved this problem.  All four servers are behind a firewall, but port 5432 was not open on the firewall.  When I
opened5432, the problem disappeared. 

Thanks to Rob Sargent, Adrian Klaver and Condor for your help.

Howard

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, August 25, 2019 12:20 PM, Rob Sargent <robjsargent@gmail.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?
>
> >





pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: For SELECT statement (just a reading one, no 'FOR UPDATE'), is COMMIT or ROLLBACK preferred?
Next
From: Adrian Klaver
Date:
Subject: Re: Postgres SQLSTATE[08006] [7] timeout expired