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

Hi

On Fri, Nov 24, 2017 at 7:56 PM, F.Sluiter <fsluiter(at)gmail(dot)com> wrote:

> 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.
>

Yeah, the assumption was always that packagers would deal with that problem
with guidance from us, and end-users wouldn't have to. Unfortunately the
guys working on the Ubuntu/Debian packages haven't been able to complete
them yet.

> 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!
>

Thanks - I've added an item to my todo to improve that part of the docs.

>
> 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
>>
>>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company