Hi, On Fri, Oct 23, 2020 at 6:09 PM Gavin Fleming <ga...@kartoza.com> wrote:
> Thanks Yogesh, Aditya > > Both your methods run, but produce this error: > > ---------- > Dumping servers with: > User: pgadm...@pgadmin.org > SQLite pgAdmin config: /var/lib/pgadmin/pgadmin4.db > ---------- > SQLite database file "/var/lib/pgadmin/pgadmin4.db" does not exists. > We've added an option "--sqlite-path" where you can specify the pgadmin db file. Refer - https://www.pgadmin.org/docs/pgadmin4/4.27/import_export_servers.html#exporting-servers You're using desktop mode, so you're file should be in <USER HOME>/.pgadmin/pgadmin4.db. > > On 23 Sep 2020, at 09:37, Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> wrote: > > Hi Gavin, > > Alternatively, you could try below. Not the best of solutions but has > worked for few users. > 1) cd /Applications/pgAdmin\ 4.app/Contents/Resources/venv > 2) ./bin/python ../web/setup.py --dump-servers <path for > pgadmin_dump_servers.json> > > On Wed, Sep 23, 2020 at 12:59 PM Yogesh Mahajan < > yogesh.maha...@enterprisedb.com> wrote: > >> Hi Gavin, >> >> Please run below commands - >> >> export PYTHONHOME=/Applications/pgAdmin\ 4.app/Contents/Resources/venv >> >> /Applications/pgAdmin\ >> 4.app/Contents/Resources/venv/bin/python /Applications/pgAdmin\ >> 4.app/Contents/Resources/web/setup.py --dump-servers <path for >> pgadmin_dump_servers.json> >> >> Thanks, >> Yogesh Mahajan >> EnterpriseDB Corporation >> >> Phone: +91-9741705709 >> >> >> On Tue, Sep 22, 2020 at 8:59 PM Gavin Fleming <ga...@kartoza.com> wrote: >> >>> Hi >>> >>> I’m having no luck with setup.py —dump-servers on my Mac, any assistance >>> would be appreciated. >>> >>> MacOS 10.15.6 >>> pgAdmin4 v4.26 >>> >>> In /Applications/pgAdmin 4.app/Contents/Resources/web >>> >>> I ran source ../venv/bin/activate >>> >>> then tried these variations, all in the (venv): >>> >>> 1 >>> >>> python setup.py --dump-servers /Users/Shared/temp/pgadmin.json >>> >>> Traceback (most recent call last): >>> File "setup.py", line 17, in <module> >>> import builtins >>> ImportError: No module named builtins >>> >>> 2 >>> >>> python3 setup.py --dump-servers /Users/Shared/temp/pgadmin.json >>> >>> Traceback (most recent call last): >>> File "setup.py", line 18, in <module> >>> from pgadmin.model import db, User, Version, ServerGroup, Server, \ >>> File "/Applications/pgAdmin >>> 4.app/Contents/Resources/web/pgadmin/__init__.py", line 19, in <module> >>> from flask import Flask, abort, request, current_app, session, >>> url_for >>> ModuleNotFoundError: No module named ‘flask' >>> >>> 3 >>> >>> ./setup.py --dump-servers /Users/Shared/temp/pgadmin.json >>> >>> ./setup.py: line 11: Perform the initial setup of the application, by >>> creating the auth >>> and settings database.: command not found >>> ./setup.py: line 13: import: command not found >>> ./setup.py: line 14: import: command not found >>> ./setup.py: line 15: import: command not found >>> ./setup.py: line 16: import: command not found >>> ./setup.py: line 17: import: command not found >>> from: can't read /var/mail/pgadmin.model >>> ./setup.py: line 22: syntax error near unexpected token `(' >>> ./setup.py: line 22: `if 'SERVER_MODE' in globals():’ >>> >>> 4 >>> >>> pip install builtins >>> DEPRECATION: Python 2.7 will reach the end of its life on January 1st, >>> 2020. Please upgrade your Python as Python 2.7 won't be maintained after >>> that date. A future version of pip will drop support for Python 2.7. >>> Collecting builtins >>> ERROR: Could not find a version that satisfies the requirement >>> builtins (from versions: none) >>> ERROR: No matching distribution found for builtins >>> >>> > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* > <http://edbpostgres.com/> > "Don't Complain about Heat, Plant a TREE" > > > -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* <http://edbpostgres.com> "Don't Complain about Heat, Plant a TREE"
