pgAdmin 4 -> 3.1 -> Auto-reconnect

From: Andrew Pratt <andrewmpratt(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 -> 3.1 -> Auto-reconnect
Date: 2018-07-03 04:36:21
Message-ID: CAD-Yeo9Xp-2nYRWy-4DVkDiLVoTA7CeMpjZUXQM+rJ3cZ8dLng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I really appreciate the huge effort that went into converting to a HTML
based UI for pgAdmin, we are working on similar projects for our products.

I was just wondering whether you can review the handling of postgres server
connections within 4.3.1.

Ideally, in my opinion, pgAdmin should always automatically re-establish a
lost connection.
There were a few issues related to this in 3.0 but they seem to have gotten
worse in 3.1 with items in the tree now not working if a connection is lost
and no re-connect dialog displays.

I really fail to understand a good real world use case where anyone would
want the 'default' setting when they request something to happen to be
'don't re-connect unless I tell you to'

I also don't know why the connector to postgres that you are using takes so
long to recognise that the connection has dropped.

We use Devart's Postgres connectors in our work and we perform a ping to
check a connection is still valid if it hasn't been used from the pool in a
while, which fails fast, allowing us to then re-connect the connection
quickly. Perhaps you could do something similar. At present it takes 10-30
seconds to realise its disconnected, then a dialog sometimes appears to
reconnect and then you have to wait for it connect again which all seems
very slow compared to the metrics we achieve with devarts connectors.

Thanks for considering!!
Andrew

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Cory Nemelka 2018-07-03 18:19:52 Re: pgAdmin4 ssh tunnel configuration
Previous Message Colin Beckingham 2018-07-02 10:07:47 Re: Bytea as "Binary Data"