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

On my first post, I asked the person in charge of the firewall if 5432 was open and he told me it was. When I checked it myself later, I found out that it wasn't. Before I post to this list again, I'll check all assumptions myself.

"Only when I go to the IP address of the server with the Postgres database will the transaction complete, and it happens quickly."

My best guess is that when the IP address is also the address of the Postgres server, the firewall does not interfere.

Howard

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, August 25, 2019 4:55 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> On 8/25/19 2:59 PM, Howard Wells wrote:
>
> > I solved this problem. All four servers are behind a firewall, but port 5432 was not open on the firewall. When I opened 5432, the problem disappeared.
>
> Glad you solved. Confused as to how:
>
> 1. From first post:
> "All four are behind the same firewall, with port 5432 open."
>
> 2. A subsequent post:
>
> "Only when I go to the IP address of the server with the Postgres
> database will the transaction complete, and it happens quickly."
>
>
> > 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(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?
> > >
> > > >
>
> --
>
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com