Обсуждение: pgAdmin 4 Connection to the server has been lost.

Поиск
Список
Период
Сортировка

pgAdmin 4 Connection to the server has been lost.

От
Boblitz John
Дата:

Hello,

 

I recently installed a new DB server (Linux Jessie, postgres 9.4) and wanted to connect via pgAdmin 3 (1.18) and got the message that it was not supported.  As I intend to upgrade the other servers in the near future, and knowing that it is recommended to move to pgAdmin4, I installed and set up my old servers (Debian Squeeze, postgres 9.1).  The configuration went well I could immediately connect.

 

I can navigate the tree on the left with no problem and when I select a DB I receive notification that it connects (green bars on the right)

 

However, when I drill down to a table, select it and select the properties or SQL tabs, I get “Connection to the server has been lost”.  Dashboard shows updated information statistics and dependencies are okay. 

 

On the new server, the properties and sql are shown correctly.

 

Is there any way to fix this?

 

 

Best Regards,

 

John Boblitz

 

 

 

 

 

Re: pgAdmin 4 Connection to the server has been lost.

От
Dave Page
Дата:
On Tue, Mar 28, 2017 at 8:55 AM, Boblitz John <john.boblitz@bertschi.com> wrote:
> Hello,
>
>
>
> I recently installed a new DB server (Linux Jessie, postgres 9.4) and wanted
> to connect via pgAdmin 3 (1.18) and got the message that it was not
> supported.  As I intend to upgrade the other servers in the near future, and
> knowing that it is recommended to move to pgAdmin4, I installed and set up
> my old servers (Debian Squeeze, postgres 9.1).  The configuration went well
> I could immediately connect.
>
>
>
> I can navigate the tree on the left with no problem and when I select a DB I
> receive notification that it connects (green bars on the right)
>
>
>
> However, when I drill down to a table, select it and select the properties
> or SQL tabs, I get “Connection to the server has been lost”.  Dashboard
> shows updated information statistics and dependencies are okay.
>
>
>
> On the new server, the properties and sql are shown correctly.
>
>
>
> Is there any way to fix this?

pgAdmin 4 doesn't support PostgreSQL 9.1.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



Re: pgAdmin 4 Connection to the server has been lost.

От
Murtuza Zabuawala
Дата:
Hi,

pgAdmin4 supports Postgres 9.2 and above, Can you try with newer version and check if you get same error?

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Tue, Mar 28, 2017 at 6:25 PM, Boblitz John <john.boblitz@bertschi.com> wrote:

Hello,

 

I recently installed a new DB server (Linux Jessie, postgres 9.4) and wanted to connect via pgAdmin 3 (1.18) and got the message that it was not supported.  As I intend to upgrade the other servers in the near future, and knowing that it is recommended to move to pgAdmin4, I installed and set up my old servers (Debian Squeeze, postgres 9.1).  The configuration went well I could immediately connect.

 

I can navigate the tree on the left with no problem and when I select a DB I receive notification that it connects (green bars on the right)

 

However, when I drill down to a table, select it and select the properties or SQL tabs, I get “Connection to the server has been lost”.  Dashboard shows updated information statistics and dependencies are okay. 

 

On the new server, the properties and sql are shown correctly.

 

Is there any way to fix this?

 

 

Best Regards,

 

John Boblitz

 

 

 

 

 


Re: pgAdmin 4 Connection to the server has beenlost.

От
Boblitz John
Дата:
Okay - short, sweet and to the point!

Thanks

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-
> owner@postgresql.org] On Behalf Of Dave Page
> Sent: Dienstag, 28. März 2017 2:58
> To: Boblitz John
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAdmin 4 Connection to the server has
> been lost.
> 
> On Tue, Mar 28, 2017 at 8:55 AM, Boblitz John <john.boblitz@bertschi.com>
> wrote:
> > Hello,
> >
> >
> >
> > I recently installed a new DB server (Linux Jessie, postgres 9.4) and
> > wanted to connect via pgAdmin 3 (1.18) and got the message that it was
> > not supported.  As I intend to upgrade the other servers in the near
> > future, and knowing that it is recommended to move to pgAdmin4, I
> > installed and set up my old servers (Debian Squeeze, postgres 9.1).
> > The configuration went well I could immediately connect.
> >
> >
> >
> > I can navigate the tree on the left with no problem and when I select
> > a DB I receive notification that it connects (green bars on the right)
> >
> >
> >
> > However, when I drill down to a table, select it and select the
> > properties or SQL tabs, I get “Connection to the server has been
> > lost”.  Dashboard shows updated information statistics and dependencies
> are okay.
> >
> >
> >
> > On the new server, the properties and sql are shown correctly.
> >
> >
> >
> > Is there any way to fix this?
> 
> pgAdmin 4 doesn't support PostgreSQL 9.1.
> 
> 
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
> 
> EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL
> Company
> 
> 
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To
> make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support