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

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