Re: pgAdmin support: setup.py --dump-servers

Hi,

On Fri, Oct 23, 2020 at 6:09 PM Gavin Fleming <gavin(at)kartoza(dot)com> wrote:

> Thanks Yogesh, Aditya
>
> Both your methods run, but produce this error:
>
> ----------
> Dumping servers with:
> User: pgadmin4(at)pgadmin(dot)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(dot)toshniwal(at)enterprisedb(dot)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(dot)mahajan(at)enterprisedb(dot)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 <gavin(at)kartoza(dot)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"