Re: Installing pgAdmin 4 in Runtime Mode (stand alone) in Linux

Hi Dave, thank you for all the work you put in, we use pgadmin as our daily
tool.
For us it wasn't immediately clear from the docs how to run pgadmin as a
real desktop application ornthat it can be run in 3 different ways (great
concept by the way). Because of our security policies, it is difficult to
install webservice type apps, so running in standalone mode is very
important in our case.
If you like, you may use our work (in part or whole) and add it to the
official documentation, so it will get the place were it should be. And
hopefully someone can create official .deb packages now the dependencies
are documented!

Kind regards
Floris Sluiter
Human Data Associates

On Nov 24, 2017 20:31, "Dave Page" <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> We don’t advise changing config.py as an upgrade will overwrite it.
> Instead, create a file called config_local.py in the same directory, and
> put the change in there. That file (if present) is read after config.py and
> can override the defaults.
>
> Thanks for the helpful blogs guys!
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK:http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On 24 Nov 2017, at 18:28, Richard Greenwood <richard(dot)greenwood(at)gmail(dot)com>
> wrote:
>
> All -
>
> Thanks for your replies. Following the revised instructions I still had
> one remaining error:
>
> ERROR pgadmin: The desktop user pgadmin4(at)pgadmin(dot)org was not found
> in the configuration database.
>
> I assume this is because I have previously setup the local web mode. So in
> ~/pgadmin4-2.0/web/config.py I changed DESKTOP_USER = '
> pgadmin4(at)pgadmin(dot)org' to the user that I had previously used in the
> standalone web interface.
>
> All good now. Thanks for all the help. I'm sure many others will find your
> instructions to be very helpful.
>
> Best regards,
> Rich
>
>
>
> On Fri, Nov 24, 2017 at 6:26 AM, Victor Milewski <victormilewski(at)gmail(dot)com
> > wrote:
>
>> Hi Rich,
>>
>> This was another error resulting as an after effect from the formatting
>> error on our blog. The python2 and python3 libraries got mixed up while
>> building pgAdmin 4. Can you try and redo the whole process again? First
>> make sure the virtual environment is not active and remove both the virtual
>> environment and the pgAdmin4 directories:
>>
>> deactivate
>> sudo rm -rf ~/virtualenvs/
>> sudo rm -rf ~/pgadmin4-2.0/
>> sudo rm -rf ~/.config/pgadmin/
>> sudo rm -rf ~/.pgadmin/
>>
>> now follow the steps at
>> https://humandata.associates/blog/data-engineering/installin
>> g-pgadmin-4-runtime-mode
>>
>> I hope everything will work now, please let us know!
>> Best,
>> Victor
>>
>> On Nov 24, 2017 02:01, "Richard Greenwood" <richard(dot)greenwood(at)gmail(dot)com>
>>> wrote:
>>>
>>> Thanks for the write up. I've been using "Local Mode" and look forward
>>> to trying the runtime. I ran into a couple problems following your
>>> instructions. They are probably quite minor, but I am not a Python guy so I
>>> have no clue as to how to fix the problems.
>>> virtualenv -p python3 gives error:
>>> Already using interpreter /usr/bin/python3
>>> You must provide a DEST_DIR
>>> So I tried virtualenv -p python3 ~/virtualenvs/ which at least doesn't
>>> throw an error but I have no idea if that's correct.
>>>
>>> And finally, the moment of truth:
>>> $~/pgadmin4-2.0/runtime/pgAdmin4
>>> Python path: "/home/rich/virtualenvs/pgadmi
>>> n4/lib/python3.5/site-packages/"
>>> Python Home: ""
>>> Webapp path: "/home/rich/pgadmin4-2.0/web/pgAdmin4.py"
>>> Traceback (most recent call last):
>>> File "/home/rich/pgadmin4-2.0/web/pgAdmin4.py", line 34, in <module>
>>> import config
>>> File "/home/rich/pgadmin4-2.0/web/config.py", line 30, in <module>
>>> from pgadmin.utils import env, IS_PY2, IS_WIN, fs_short_path
>>> File "/home/rich/pgadmin4-2.0/web/pgadmin/__init__.py", line 17, in
>>> <module>
>>> from flask import Flask, abort, request, current_app, session,
>>> url_for
>>> ImportError: No module named flask
>>>
>>> Rich
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Nov 23, 2017 at 5:46 AM, F.Sluiter <fsluiter(at)gmail(dot)com> wrote:
>>>
>>>> As it was not very clearly documented anywhere, we would like to share
>>>> how best to install PGadmin 4 on linux Mint and Ubuntu 16.04 in a virtual
>>>> environment as a stand alone desktop application (without the use of a
>>>> browser!).
>>>>
>>>> PgAdmin 4 can be run in three ways:
>>>>
>>>> - Server Mode in a web interface
>>>> - Local Mode in a web interface
>>>> - Local Mode in a standalone/runtime environment
>>>> The difference between the web interface and the runtime environment,
>>>> is that for the first you require to work from a browser. Whereas with the
>>>> runtime environments it runs as any other application on your desktop. This
>>>> is achieved by using Qt5, which creates a wrapper of the application. This
>>>> is a feature provided by the pgAdmin 4 team. However, on Ubuntu it wasn't
>>>> pre-build. Installing PgAdmin 4 for a runtime environment is a bit more
>>>> tricky than the other two, mostly because up until now it was not very well
>>>> documented. Especially it was unclear which dependencies it has on Ubuntu
>>>> and which options it needs at startup. After following this guide, you
>>>> will be able to run pgAdmin 4 in any of the three options on Ubuntu 16.04,
>>>> Linux Mint, or other Debian flavours.
>>>>
>>>> Please find the installation guide here:
>>>> https://humandata.associates/blog/data-engineering/installin
>>>> g-pgadmin-4-runtime-mode
>>>>
>>>> Hopefully someone can add the information to the pgadmin documentation
>>>> and even better turn this into one (or 3) debian packages...
>>>>
>>>>
>>>
>>>
>>> --
>>> Richard W. Greenwood, PLS
>>> www.greenwoodmap.com
>>>
>>>
>>>
>
>
> --
> Richard W. Greenwood, PLS
> www.greenwoodmap.com
>
>