Re: Session timeout

On 17/10/2019 11.05, Khushboo Vashi wrote:

Hi Arni,

On Thu, Oct 17, 2019 at 1:41 PM Arni Kromić <arni.kromic@bios-ict.hr> wrote:

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ć