Postgres SQLSTATE[08006] [7] timeout expired

2019-08-24 Thread Howard Wells
I have three servers behind a load balancer and a fourth server solely for Postgres 10 database that is not behind the load balancer. All four are behind the same firewall, with port 5432 open. I have a simple browser-based html form to submit email addresses, usernames and passwords; the form

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

2019-08-25 Thread Howard Wells
browser-based PHP connection does not complete Howard ‐‐‐ Original Message ‐‐‐ On Sunday, August 25, 2019 9:36 AM, Condor wrote: > On 25-08-2019 02:54, Adrian Klaver wrote: > > > On 8/24/19 3:42 PM, Howard Wells wrote: > > > > > I have three servers behi

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

2019-08-25 Thread Howard Wells
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, R

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

2019-08-25 Thread Howard Wells
em 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 wrote: > Thanks for the replies. I am getting the information requested by Adrian > Klaver. Rob Sargent, I am going

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

2019-08-25 Thread Howard Wells
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. Thanks to Rob Sargent, Adrian Klaver and Condor for your help. Howard ‐‐‐ Original Message ‐‐‐ On Sunday, August 25, 2019 12:20 PM, R

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

2019-08-26 Thread Howard Wells
laver 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: &

How to access Postgres .pgpass file from php?

2019-09-07 Thread Howard Wells
I have my php files in the web root, and the Postgres 10 logon credentials are in the php file. I want to put them outside the web root for security, because a malicious robot could easily read the credentials. After research, I found the .pgpass file. That looks like the ideal solution, but