From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Little help with the server export function
Date: Sun, 31 Jan 2021 20:10:39 +0100
Message-ID: <5cad8aa8-7929-1262-0ec7-c83e1f638c6d@jakobs.com> (raw)
In-Reply-To: <CALgz9fkTGwwRy5snUd2n9y5iYgpw9tjaUNuWXNuUYn8CcTHepg@mail.gmail.com>
References: <CALgz9fkTGwwRy5snUd2n9y5iYgpw9tjaUNuWXNuUYn8CcTHepg@mail.gmail.com>
Am 31.01.21 um 17:48 schrieb Ted Gulesserian:
> Consulted these links:
>
> https://www.pgadmin.org/docs/pgadmin4/latest/import_export_servers.html#importing-servers
> <https://www.pgadmin.org/docs/pgadmin4/latest/import_export_servers.html#importing-servers;
>
> https://stackoverflow.com/questions/47718815/import-server-list-between-pgadmin-4
> <https://stackoverflow.com/questions/47718815/import-server-list-between-pgadmin-4;
>
> https://packaging.python.org/guides/installing-using-pip-and-virtual-environments/
> <https://packaging.python.org/guides/installing-using-pip-and-virtual-environments/;
>
> And tried variations of it, but I can't seem to get it to work.
>
> For example the cygwin bash script provided below results in the
> following error.
>
> ----------
> Dumping servers with:
> User: pgadmin4@pgadmin.org <mailto:pgadmin4@pgadmin.org>
> SQLite pgAdmin config: pgadmin4.db
> ----------
> Specified SQLite database file is not valid.
>
> I tried using the venv but looks like a version of Python installed by
> Windows 10 is taking precedence even when I issues
> ./Script/activate.bat in the pgadmin venv folder.
>
> Any help will be much appreciated.
>
> Thanks,
> Ted
>
> export DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1
> && pwd )"
> echo Sctipt located in $DIR
> export winhome=$(cmd.exe /C echo c:%HOMEPATH%)
> export winhome=${winhome::-1}
> export pgAdminHome=$winhome\\AppData\\Roaming\\pgAdmin
> export cygPgAdminHome=$(cygpath ${pgAdminHome})
> export setupPath=$(cygpath -w "/cygdrive/c/Program Files/pgAdmin
> 4/v4/web/setup.py")
> echo $cygPgAdminHome
> cd $cygPgAdminHome
> installcommand="cmd /r pip install flask flask_babelex flask_login
> flask_mail flask_paranoid flask_security email_validator
> flask_sqlalchemy flask_migrate simplejson"
> echo $installcommand
> eval $installcommand
> pycommand="cmd /r python '$setupPath' --sqlite-path 'pgadmin4.db'
> --dump-servers pgadmin_bookmarks.json"
> echo $pycommand
> eval $pycommand
> cp pgadmin_bookmarks.json $DIR/pgadmin_bookmarks.json
None of these questions are related to this mailing list about
postgresql server.
Better try on a pgadmin4 mailing list.
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Little help with the server export function
In-Reply-To: <5cad8aa8-7929-1262-0ec7-c83e1f638c6d@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox