Обсуждение: pgAdmin and Multiple connection problem (how to close session with closing query editor).

Hi,

On Mon, Oct 12, 2020 at 6:32 PM androxkentaki <androxkentaki@gmail.com> wrote:

I work a lot on pgAdmin.

 

My pgAdmin is configured to open query editor in new tab of Firefox.

Thad is working properly.

But my problem is with closing it.

When I close tab with query window pgAdmin still remain Session in database for it.

So after few hours I don’t have any free socket to connect into DB. (on attached screen my IP I 192.168.20.20 and I have reserved over 35 sessions (but currently I am using only one: for Dashboard)

How to force pgAdmin to close session connection with closing a query window?

pgAdmin closes the session on closing the query window.  Which version of pgAdmin are you using?

Thanks,

Khushboo

 

 

--

Z wyrazami szacunku
Andrzej Gerasimuk

On Tue, Oct 13, 2020 at 11:40 AM androxkentaki <androxkentaki@gmail.com> wrote:

Hi Khushboo

I am using latest pgAdmin (when i receive notice of new version i am updating it)

Currently it is v4.26 x86 on Windows 10 (64bit) and Firefox Browser 81.0.1 (64 bit)

And it works like that since i have start to use postgres 11 (at beginning of 2020) at all of the versions of pgAdmin.

I didn't see that behaviour on pg v3 and postgres 9.3

Looks like you are opening a query tool in the complete new window rather than a new tab.

Can you try to open a query tool in a new browser tab rather than a new window?

For that, you need to enable the Firefox setting. (Open links in tabs instead of new windows).

Thanks,

Khushboo

wt., 13 paź 2020 o 06:11 Khushboo Vashi <khushboo.vashi@enterprisedb.com> napisał(a):

Hi,

On Mon, Oct 12, 2020 at 6:32 PM androxkentaki <androxkentaki@gmail.com> wrote:

I work a lot on pgAdmin.

 

My pgAdmin is configured to open query editor in new tab of Firefox.

Thad is working properly.

But my problem is with closing it.

When I close tab with query window pgAdmin still remain Session in database for it.

So after few hours I don’t have any free socket to connect into DB. (on attached screen my IP I 192.168.20.20 and I have reserved over 35 sessions (but currently I am using only one: for Dashboard)

How to force pgAdmin to close session connection with closing a query window?

pgAdmin closes the session on closing the query window.  Which version of pgAdmin are you using?

Thanks,

Khushboo

 

 

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Z wyrazami szacunku
Andrzej Gerasimuk

Hi,

On Tue, Oct 13, 2020 at 12:07 PM androxkentaki <androxkentaki@gmail.com> wrote:

Unfortunately i don't think that this is it.

in FF i have active option to  open links in tabs (only difference is that i don't have active an Ctrl+TAB option)

Ctrl + Tab is my local browser option and isn't related to this. :)

After the above setting (As I can't read this language I hope it's saying "open links in tabs instead of window"), are you still facing the issue? If yes, please log the issue @ https://redmine.postgresql.org/projects/pgadmin4/issues

And here are my pgA config for Query Tool Display

This is correct.

Thanks,

Khushboo 

wt., 13 paź 2020 o 08:30 Khushboo Vashi <khushboo.vashi@enterprisedb.com> napisał(a):

On Tue, Oct 13, 2020 at 11:40 AM androxkentaki <androxkentaki@gmail.com> wrote:

Hi Khushboo

I am using latest pgAdmin (when i receive notice of new version i am updating it)

Currently it is v4.26 x86 on Windows 10 (64bit) and Firefox Browser 81.0.1 (64 bit)

And it works like that since i have start to use postgres 11 (at beginning of 2020) at all of the versions of pgAdmin.

I didn't see that behaviour on pg v3 and postgres 9.3

Looks like you are opening a query tool in the complete new window rather than a new tab.

Can you try to open a query tool in a new browser tab rather than a new window?

For that, you need to enable the Firefox setting. (Open links in tabs instead of new windows).

Thanks,

Khushboo

wt., 13 paź 2020 o 06:11 Khushboo Vashi <khushboo.vashi@enterprisedb.com> napisał(a):

Hi,

On Mon, Oct 12, 2020 at 6:32 PM androxkentaki <androxkentaki@gmail.com> wrote:

I work a lot on pgAdmin.

 

My pgAdmin is configured to open query editor in new tab of Firefox.

Thad is working properly.

But my problem is with closing it.

When I close tab with query window pgAdmin still remain Session in database for it.

So after few hours I don’t have any free socket to connect into DB. (on attached screen my IP I 192.168.20.20 and I have reserved over 35 sessions (but currently I am using only one: for Dashboard)

How to force pgAdmin to close session connection with closing a query window?

pgAdmin closes the session on closing the query window.  Which version of pgAdmin are you using?

Thanks,

Khushboo

 

 

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Z wyrazami szacunku
Andrzej Gerasimuk