Re: Connect is not available, request timeout after 30000ms.

On 6/25/19 7:24 AM, Pawan Sharma wrote:
> In PostgreSQL logs it's showing select queries are running with duration 
> approx 37001.347ms
> 

Is this normal?

Did you run ANALYZE on the database after you restored it to the new 
Postgres 11 cluster?

If not do so.

Then run the query in psql or something similar with EXPALIN ANALYZE and 
see what the time is.


I cannot find the error message string in the Postgres source code, so I 
am guessing it came from somewhere else. Best guess is the app/driver 
has a timeout set.


-- 
Adrian Klaver
adrian.klaver@aklaver.com