Re: browser disconnects from pgAdmin4 server

From: Gabriel Sánchez <gabrielesanchez(at)gmail(dot)com>
To: "Strauch, Sheldon" <sstrauch(at)enova(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: browser disconnects from pgAdmin4 server
Date: 2019-10-30 16:20:16
Message-ID: CANHuRqEcUYCM0N0SU-3=5+=gpPo_oNCyV9x-Mk8vZE1YQJ2T0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Wed, Oct 30, 2019 at 11:58 AM Strauch, Sheldon <sstrauch(at)enova(dot)com>
wrote:

> Hello Gabriel!
>
> Are you using an Apple Mac as your laptop per chance? We encountered this
> issue at my workplace as well. it turns out that our infrastructure team
> needed to update our Ubuntu kernel to correct issues with the network
> stack. This didn't seem to bother our Windows users but regularly caused
> MacBook Pro running Mojave to drop network connections to the database
> server with great frequency:
>
> [ Ubuntu: 4.15.0-66.75 ]
> - tcp: fix tcp_ecn_withdraw_cwr() to clear TCP_ECN_QUEUE_CWR
> - tcp: Reset send_head when removing skb from write-queue <<<<<
> - tcp: Don't dequeue SYN/FIN-segments from write-queue <<<<<
>
>
>
I run Ubuntu 18.04 desktop on a Lenovo laptop, and it's up to date, but
perhaps it has the same issue. Still, this doesn't happen with other
websites, as far as I can tell.

> HTH!
>
> On Wed, Oct 30, 2019 at 8:14 AM Gabriel Sánchez <gabrielesanchez(at)gmail(dot)com>
> wrote:
>
>> Hi all,
>>
>> I have pgAdmin4 server running on Ubuntu 18.04 server with Apache, and I
>> connect to it from my laptop using Firefox, which works well. One
>> inconvenience is that my browser's session disconnects from the pgAdmin4
>> server after a long time, so usually if I leave work pending at night to be
>> continued the next day, when I resume work in the morning pgAdmin can't be
>> used because it is not connected (and it won't reconnect). My work-around
>> is to copy any open queries to a text editor, refresh the page, sign in to
>> pgAdmin, and open new tabs and copy the queries back from my text editor.
>> Of course, any temporary tables are lost and I must also recreate them.
>> Does anyone in the community know how to make sessions last longer?
>> Perhaps there is a setting in one of the pgAdmin config files or Apache?
>>
>> Thanks,
>> Gabriel
>>
>>
>
> --
>
> Look after your data, and your database will look after you. -- Simon Riggs
>
> Sheldon E. Strauch
> *Data Architect, Data Services *
> *O* 312-676-1556
> *M* 224-723-3878
>
> *Enova International, Inc.*
> *This transmission is confidential and may be privileged or proprietary.
> If you are not the intended recipient, you are not authorized to use the
> information in this transmission in any way. Please inform the sender
> immediately if you have received this transmission in error and permanently
> delete and destroy the original and any copies of the information.*
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Arni Kromić 2019-10-31 08:23:46 Re: Session timeout
Previous Message Strauch, Sheldon 2019-10-30 15:58:06 Re: browser disconnects from pgAdmin4 server