Re: PgAdmin 4 Importing Servers with Error
От | Khushboo Vashi |
---|---|
Тема | Re: PgAdmin 4 Importing Servers with Error |
Дата | |
Msg-id | CAFOhELfQMiprJnr9TBq2LU1EU=DgjTqpJSat-o_LOhsz9B9NZw@mail.gmail.com обсуждение исходный текст |
Ответ на | PgAdmin 4 Importing Servers with Error (Bo Guo <bo.guo@gisticinc.com>) |
Список | pgadmin-support |
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.
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,BoOn 3/29/21 1:20 AM, Dave Page wrote:HiOn 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.---- 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 по дате отправления: