Re: Connection timeout error with Postgres

2022-04-24 Thread Antonis Christofides
Since PostgreSQL is listening on a different machine, then it is more or less clear from the error message that the traffic is being filtered. It's strange it works sometimes and other times it isn't working. Does it have a static IP address? Is the PostgreSQL server machine running something li

Re: Connection timeout error with Postgres

2022-04-24 Thread Disha Patel
Hi Antonis, Yes, the PostgreSQL server is on a difference machine than Django. I have noticed that initial connections are successful but it fails in the later connections mainly in long running jobs. Thanks, Disha On Friday, April 22, 2022 at 12:19:27 PM UTC+5:30 Antonis Christofides wrote

Re: Connection timeout error with Postgres

2022-04-21 Thread Antonis Christofides
Hi! I shall assume that PostgreSQL is listening on port 5432. "Connection timed out" means that the client (Django/psycopg2 in this case) is not getting any response—as if the PostgreSQL server machine did not exist. ("Connection refused", on the other hand, means that the PostgreSQL server ma

Connection timeout error with Postgres

2022-04-21 Thread Disha Patel
Hi, I am facing below connection timeout error while using Postgres as database for my Django application. "psycopg2.operationalerror: could not connect to server: connection timed out: Solutions tried: 1. increased timeout at server end. 2. added conn_max_age in the settings and tried multi