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.