Обсуждение: browser disconnects from pgAdmin4 server
[ 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 <<<<<
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.
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 <<<<<
HTH!On Wed, Oct 30, 2019 at 8:14 AM Gabriel Sánchez <gabrielesanchez@gmail.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-3878Enova 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.