Postgres Pro
Downloads
Home   >   mailing lists

Re: PgAdmin 4 Importing Servers with Error - Mailing list pgadmin-support

From Khushboo Vashi
Subject Re: PgAdmin 4 Importing Servers with Error
Date
Msg-id CAFOhELfQMiprJnr9TBq2LU1EU=DgjTqpJSat-o_LOhsz9B9NZw@mail.gmail.com
Whole thread Raw
In response to PgAdmin 4 Importing Servers with Error  (Bo Guo <bo.guo@gisticinc.com>)
List pgadmin-support
Tree view
Hi,

On Sat, Jul 17, 2021 at 12:56 AM Bo Guo <bo.guo@gisticinc.com> wrote:

Hi there,

I was trying to transfer the servers setup (connection to various servers) from one install to another using this link https://www.pgadmin.org/docs/pgadmin4/development/import_export_servers.html

All is fine except when we import using

sudo python3 /usr/pgadmin4/web/setup.py --load-servers /srv/nas/Transfer/gisticservers.json

We got the following error msg:

Getting this error: The argument passed to Dialect.has_table() should be a <class 'sqlalchemy.engine.base.Connection'>, got <class 'sqlalchemy.engine.base.Engine'>. Additionally, the Dialect.has_table() method is for internal dialect use only; please use ``inspect(some_engine).has_table(<tablename>>)`` for public API use.

This issue is due to the new release of SQLAlchemy package which was released last Thursday.
pgAdmin uses Flask-SQLAlchemy to manage the pgAdmin users data which is dependent on SQLAlchemy package.


As a work around, you can do following steps:
> source /usr/pgadmin4/venv/bin/activate
> pip3 uninstall SQLAlchemy
> pip3 install SQLAlchemy==1.3.24

Thanks,
Khushboo


Please kindly advise if there is anything I might have done wrong in the process. 

Cheers,

Bo

On 3/29/21 1:20 AM, Dave Page wrote:
Hi

On Fri, Mar 26, 2021 at 2:13 PM George Weaver <gweaver@shaw.ca> wrote:

Good morning,

Is there still the option to start just the Server in v5? 

No. 

If so, how do I configure this?  There is no longer a tray icon...

Correct - the server is integrated into the application now, and runs as a traditional app would rather than a separate server with browser. 

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

EDB: http://www.enterprisedb.com

-- 
Regards,

Bo Guo, PhD, PE
President
Gistic Research, Inc.
2033 E Warner Rd Ste 105
Tempe, AZ 85284
www.gisticinc.com
www.youtube.com/linearbench
Office: 480-656-9962
Cell: 602-570-4697

pgadmin-support by date:

Previous
From: Bo Guo
Date:
Subject: PgAdmin 4 Importing Servers with Error
Next
From: Akshay Joshi
Date:
Subject: Re: New 'Resize by data?' Maximum Width Feature