Sample Header Ad - 728x90

Client application disconnects from database/s it is connected to after 10 minutes of inactivity

8 votes
2 answers
29814 views
When working with pgAdmin 4 (and actually, several other programs that act as clients to the database), the connection to the server disconnects after some 10 or 15 minutes of inactivity. One coffee and one phone call, and you get a message similar to "Sorry, connection to database is lost. Do you want me to try to reconnect?" And pgAdmin reconnects always need more than one trial, and the object-tree that was already expanded gets collapsed... So, it's a little bit annoying. pgAdmin doesn't seem to have any parameter related to that behaviour. (There seems to be ways to change some connection timeouts , but they're related to how pgAdmin behaves with regard to the server taking too long to connect). What can be done it to avoid pgAdmin from disconnecting from the database? --- Disclosure: This is actually a "pseudo-question". It is *spin-off* of another one , that ended up not being related to loss of connectivity... Given the fact I already had one answer in place, I (not very humbly) think it is worth "asking", in case the answer is helpful to someone.
Asked by joanolo (13677 rep)
Apr 4, 2017, 07:20 PM
Last activity: Sep 4, 2022, 07:49 AM