Hi, On Sat, Jul 17, 2021 at 12:56 AM Bo Guo <bo....@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. 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 <gwea...@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 85284www.gisticinc.comwww.youtube.com/linearbench > Office: 480-656-9962 > Cell: 602-570-4697 > >
