On 17/10/2019 15.24, Arni Kromić wrote:
On 17/10/2019 11.05, Khushboo Vashi wrote:
Hi Arni,
A question asked on the list reminded me of something... I've always
wondered if it's possible to prolong or prevent pgAdmin4 session
timeouts. This way if I leave the computer for a long time (especially
if it gets suspended), I have to refresh page, and login again. That
also means that any query/data tabs are lost.
Can i prevent the session from expiring so I can stay logged in? I don't
need this at all for security because both the database and the pgAdmin
service are on my development computer which only I use.
No, you can't prevent the session expiration completely but, you can increase the timeout limits.
Check the below configurations in config.py file.
MAX_SESSION_IDLE_TIME
SESSION_EXPIRATION_TIME
CHECK_SESSION_FILES_INTERVAL
You will get information regarding the parameters in the file itself, and can override above settings as per your requirement.
Thanks,
Khushboo
Thank you very much, I believe this is exactly what I need. I've tuned those parameters on my development machine to work more comfortably, I hope it will do the trick.
--
Kind Regards,
Arni Kromić
Unfortunately this didn't solve the problem. I've prolonged the first parameter from 1 hour to 24 and the other two from one day to three; but when I put the computer to sleep yesterday afternoon and woke it up this morning, it required relogin. Again I couldn't stop the work and continue.
I don't know if anything else is needed to apply the settings, I just restarted Apache and re-login to pgAdmin. I've also observed that the same session does continue normally if I leave the computer for a few hours and it also survives when I put the computer to sleep and wake it up after a short while. Why does it not listen to my changed configuration?
The file I edited is /usr/share/pgadmin4/web/config.py, which I suppose is the right one for my computer. The software was installed on Ubuntu from upstream (your) apt repository.
--
Kind Regards,
Arni Kromić