Re: PgAdmin 4 Importing Servers with Error

Hi,

On Sat, Jul 17, 2021 at 12:56 AM Bo Guo <bo(dot)guo(at)gisticinc(dot)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.

You can log this issue at https://redmine.postgresql.org/projects/pgadmin4.

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(at)shaw(dot)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 85284www.gisticinc.comwww.youtube.com/linearbench
> Office: 480-656-9962
> Cell: 602-570-4697
>
>