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

From Adrian Klaver
Subject Re: Postgres SQLSTATE[08006] [7] timeout expired
Date
Msg-id 5a2935c8-8a3b-4592-5751-3b4a49b7c4ca@aklaver.com
Whole thread Raw
In response to Re: Postgres SQLSTATE[08006] [7] timeout expired  (Howard Wells <mr284@protonmail.com>)
Responses Re: Postgres SQLSTATE[08006] [7] timeout expired  (Howard Wells <mr284@protonmail.com>)
List pgsql-general
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
opened5432, 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@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?
>>
>>>
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Howard Wells
Date:
Subject: Re: Postgres SQLSTATE[08006] [7] timeout expired
Next
From: Andreas Kretschmer
Date:
Subject: Re: BDR: moving a node