Problems connecting to remote database with recent pgAdmin versions

From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Problems connecting to remote database with recent pgAdmin versions
Date: 2018-11-27 11:52:12
Message-ID: CAPB4dVj4sJaWY7R2Bb-Ytu15e_BiSFZJ0n-4i-ubWJOdi-7jgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I've been experiencing problems viewing tables and running scripts on a
remote database (accessed using pgremote) with version 3.4 and 3.5 - I
never had similar problems with earlier versions on the same remote server
database. When e.g. selecting "view/edit last 100 records" for a table, or
when opening a query tool window, I get a small red "disconnect" symbol but
no error message of any kind.

It is erratic, though - in periods everything works fine, then it starts
failing again. During failure periods, I've also noticed that retrieving
meta-data (properties, SQL) is very sluggish (but usually working, so the
db IS connected)

I suspect this is related to some change in a timeout configuration, but I
don't know which and/or whether this behaviour need to be addressed through
a pgadmin configuration setting or a configuration setting on the server
side (the latter has not changed, but I obviously cannot rule out that
there are changes in overall internet connectivity speed/bandwidth)

Any thoughts on how to resolve this?

Regards
Calle

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Igor Neyman 2018-11-27 19:13:51 RE: Problems connecting to remote database with recent pgAdmin versions
Previous Message Anne Marie Harm 2018-11-26 21:07:06 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL