Long running queries time out

From: "ldh(at)laurent-hasson(dot)com" <ldh(at)laurent-hasson(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Long running queries time out
Date: 2019-02-14 00:38:46
Message-ID: BN6PR15MB1185BBAFB11D4C48D6F0A2FA85670@BN6PR15MB1185.namprd15.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I recently migrated from Postgres 9.6 to 11 and with that moved from PGAdmin III to V4. I am experiencing an issue that i never experienced before.

I run a lot of queries against large databases which can take 3-4h to run. When i use PGAdmin 4, those queries time out. i.e., i get an error that the connection was lost and no results are returned. Some of those queries to updates and i can confirm afterwards that the query did complete and i cannot see in the backend anything suspect in the logs.

When i log into the backend and run queries via psql, all is good. So something between the server and PGAdmin is causing connections to time out, even thought the queries seem to complete properly.

Any insight as to how this may be happening, any setting i should check etc...? I have never experienced this before on 9.6/III so i am a bit at a loss.

Thank you,

Laurent.

Browse pgadmin-support by date

  From Date Subject
Next Message Azman Kudus 2019-02-15 02:17:51 pgAdmin startup error : Segmentation fault (core dumped)
Previous Message richard coleman 2019-02-13 17:58:06 Re: Either Find does not work or I don't know how to make it work