Subject: Re: Little help with the server export function
To: pgsql-admin@lists.postgresql.org
References: 
 <CALgz9fkTGwwRy5snUd2n9y5iYgpw9tjaUNuWXNuUYn8CcTHepg@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <5cad8aa8-7929-1262-0ec7-c83e1f638c6d@jakobs.com>
Date: Sun, 31 Jan 2021 20:10:39 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.0
MIME-Version: 1.0
In-Reply-To: 
 <CALgz9fkTGwwRy5snUd2n9y5iYgpw9tjaUNuWXNuUYn8CcTHepg@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="E5kIdtcNzXh95KLjKLmJPFQuUn5ze8ZjM"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--E5kIdtcNzXh95KLjKLmJPFQuUn5ze8ZjM
Content-Type: multipart/mixed; boundary="btUf97RmHP9FWwcXJYLYXIzDtLXjF6zt3";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <5cad8aa8-7929-1262-0ec7-c83e1f638c6d@jakobs.com>
Subject: Re: Little help with the server export function
References: <CALgz9fkTGwwRy5snUd2n9y5iYgpw9tjaUNuWXNuUYn8CcTHepg@mail.gmail.com>
In-Reply-To: <CALgz9fkTGwwRy5snUd2n9y5iYgpw9tjaUNuWXNuUYn8CcTHepg@mail.gmail.com>

--btUf97RmHP9FWwcXJYLYXIzDtLXjF6zt3
Content-Type: multipart/alternative;
 boundary="------------FB59AEF4CBCDF106ECBAC493"
Content-Language: de-DE

This is a multi-part message in MIME format.
--------------FB59AEF4CBCDF106ECBAC493
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable


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=20
> <https://www.pgadmin.org/docs/pgadmin4/latest/import_export_servers.htm=
l#importing-servers>
>
> https://stackoverflow.com/questions/47718815/import-server-list-between=
-pgadmin-4=20
> <https://stackoverflow.com/questions/47718815/import-server-list-betwee=
n-pgadmin-4>
>
> https://packaging.python.org/guides/installing-using-pip-and-virtual-en=
vironments/=20
> <https://packaging.python.org/guides/installing-using-pip-and-virtual-e=
nvironments/>
>
> 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=20
> 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=20
> ./Script/activate.bat in the pgadmin venv folder.
>
> Any help will be much appreciated.
>
> Thanks,
> Ted
>
> export DIR=3D"$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 =

> && pwd )"
> echo Sctipt located in $DIR
> export winhome=3D$(cmd.exe /C echo c:%HOMEPATH%)
> export winhome=3D${winhome::-1}
> export pgAdminHome=3D$winhome\\AppData\\Roaming\\pgAdmin
> export cygPgAdminHome=3D$(cygpath ${pgAdminHome})
> export setupPath=3D$(cygpath -w "/cygdrive/c/Program Files/pgAdmin=20
> 4/v4/web/setup.py")
> echo $cygPgAdminHome
> cd $cygPgAdminHome
> installcommand=3D"cmd /r pip install flask flask_babelex flask_login=20
> flask_mail flask_paranoid flask_security email_validator=20
> flask_sqlalchemy flask_migrate simplejson"
> echo $installcommand
> eval $installcommand
> pycommand=3D"cmd /r python '$setupPath' --sqlite-path 'pgadmin4.db'=20
> --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=20
postgresql server.

Better try on a pgadmin4 mailing list.


--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


--------------FB59AEF4CBCDF106ECBAC493
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p><br>
    </p>
    <div class=3D"moz-cite-prefix">Am 31.01.21 um 17:48 schrieb Ted
      Gulesserian:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CALgz9fkTGwwRy5snUd2n9y5iYgpw9tjaUNuWXNuUYn8CcTHepg@mail.gmai=
l.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Consulted these links:=C2=A0
        <div><br>
        </div>
        <div><a
href=3D"https://www.pgadmin.org/docs/pgadmin4/latest/import_export_server=
s.html#importing-servers"
            moz-do-not-send=3D"true">https://www.pgadmin.org/docs/pgadmin=
4/latest/import_export_servers.html#importing-servers</a><br>
        </div>
        <div><br>
        </div>
        <div><a
href=3D"https://stackoverflow.com/questions/47718815/import-server-list-b=
etween-pgadmin-4"
            moz-do-not-send=3D"true">https://stackoverflow.com/questions/=
47718815/import-server-list-between-pgadmin-4</a><br>
        </div>
        <div><br>
        </div>
        <div><a
href=3D"https://packaging.python.org/guides/installing-using-pip-and-virt=
ual-environments/"
            moz-do-not-send=3D"true">https://packaging.python.org/guides/=
installing-using-pip-and-virtual-environments/</a><br>
        </div>
        <div><br>
        </div>
        <div>And tried variations of it, but I can't seem to get it to
          work.=C2=A0</div>
        <div><br>
        </div>
        <div>For example the cygwin bash script provided below results
          in the following error.=C2=A0</div>
        <div><br>
        </div>
        <div>----------<br>
          Dumping servers with:<br>
          User: <a href=3D"mailto:pgadmin4@pgadmin.org"
            moz-do-not-send=3D"true">pgadmin4@pgadmin.org</a><br>
          SQLite pgAdmin config: pgadmin4.db<br>
          ----------<br>
          Specified SQLite database file is not valid.<br>
        </div>
        <div><br>
        </div>
        <div>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.=C2=A0=C2=
=A0</div>
        <div><br>
        </div>
        <div>Any help will be much appreciated.=C2=A0</div>
        <div><br>
        </div>
        <div>Thanks,=C2=A0</div>
        <div>Ted</div>
        <div><br>
        </div>
        <div>export DIR=3D"$( cd "$( dirname "${BASH_SOURCE[0]}" )"
          &gt;/dev/null 2&gt;&amp;1 &amp;&amp; pwd )"<br>
          echo Sctipt located in $DIR<br>
          export winhome=3D$(cmd.exe /C echo c:%HOMEPATH%)<br>
          export winhome=3D${winhome::-1}<br>
          export pgAdminHome=3D$winhome\\AppData\\Roaming\\pgAdmin<br>
          export cygPgAdminHome=3D$(cygpath ${pgAdminHome})<br>
          export setupPath=3D$(cygpath -w "/cygdrive/c/Program
          Files/pgAdmin 4/v4/web/setup.py")<br>
          echo $cygPgAdminHome<br>
          cd $cygPgAdminHome<br>
          installcommand=3D"cmd /r pip install flask flask_babelex
          flask_login flask_mail flask_paranoid flask_security
          email_validator flask_sqlalchemy flask_migrate simplejson"<br>
          echo $installcommand<br>
          eval $installcommand<br>
          pycommand=3D"cmd /r python '$setupPath' --sqlite-path
          'pgadmin4.db' --dump-servers pgadmin_bookmarks.json"<br>
          echo $pycommand<br>
          eval $pycommand<br>
          cp pgadmin_bookmarks.json $DIR/pgadmin_bookmarks.json<br>
        </div>
      </div>
    </blockquote>
    <p><br>
    </p>
    <p>None of these questions are related to this mailing list about
      postgresql server.</p>
    <p>Better try on a pgadmin4 mailing list.</p>
    <p><br>
    </p>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------FB59AEF4CBCDF106ECBAC493--

--btUf97RmHP9FWwcXJYLYXIzDtLXjF6zt3--

--E5kIdtcNzXh95KLjKLmJPFQuUn5ze8ZjM
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYBcArwUDAAAAAAAKCRCKV5yTsxlhulsc
AKCE8tDqZXNE3dSKmjFMwa/3A0uVFACfUDmtee5RkjEYh3WjoLEc0UMrDQY=
=dZKY
-----END PGP SIGNATURE-----

--E5kIdtcNzXh95KLjKLmJPFQuUn5ze8ZjM--