5 minutes PgAdmin4 Desktop install guide

five-minutes-pgadmin4-desktop-install-guide.md

5 minutes PgAdmin4 Desktop install guide

Done on Linux (Ubuntu tested)

Virtualenv & install of Python package & its deps

cd $HOME
virtualenv --python=/usr/bin/python2.7 pgadmin4
source pgadmin4/bin/activate
pip2.7 install https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.0/pip/pgadmin4-1.0-py2-none-any.whl

Add a default configuration

echo "# coding: utf-8
from config import *

SERVER_MODE = False

# Secret key for signing CSRF data. Override this in config_local.py if
# running on a web server
CSRF_SESSION_KEY = 'MyAlternateSuperSecret1'

# Secret key for signing cookies. Override this in config_local.py if
# running on a web server
SECRET_KEY = 'MyAlternateSuperSecret2'

# Salt used when hashing passwords. Override this in config_local.py if
# running on a web server
SECURITY_PASSWORD_SALT = 'MyAlternateSuperSecret3'
" > $(python -c "from distutils.sysconfig import get_python_lib; print(get_python_lib() + '/pgadmin4/config_local.py')")

Run for the first time the server

python $(python -c "from distutils.sysconfig import get_python_lib; print(get_python_lib() + '/pgadmin4/pgAdmin4.py')")

It should return the following

pgAdmin 4 - Application Initialisation

The configuration database - '/home/myuser/.pgadmin/pgadmin4.db' does not exist. Entering initial setup mode... NOTE: Configuring authentication for DESKTOP mode.

The configuration database has been created at /home/myuser/.pgadmin/pgadmin4.db Starting pgAdmin 4. Please navigate to http://localhost:5050 in your browser.

Open your browser at http://localhost:5050

Running when everything already installed

cd $HOME
source pgadmin4/bin/activate
python $(python -c "from distutils.sysconfig import get_python_lib; print(get_python_lib() + '/pgadmin4/pgAdmin4.py')")

Then, open your browser at http://localhost:5050

Note: you can use above code in a bash file to avoid boring copy&paste

Step by Step here without any error[ [How] to install pgAdmin 4 in desktop mode on Ubuntu 16.04](https://ravirajsinhv.blogspot.in/2018/02/postgresql-install-pgadmin-4-desktop.html)

I recommend @ravirajvaghela's step by step tutorial.

You can get the newest Python wheel from here (both links, in this gist as well as in rava's tutorial are outdated):
https://www.pgadmin.org/download/pgadmin-4-python-wheel/

With higher version (3.0) I had to manually create /var/lib/pgadmin directory and alter it's permissions:
https://stackoverflow.com/questions/46707935/oserror-errno-13-permission-denied-var-lib-pgadmin

Also python-psycopg2 and libpq-dev are required, see:
https://stackoverflow.com/a/28938258

Thanks, it was really helpful

its easier to get postgreSQL and pgadmin set up on unix by adding the official PGDG repository:

$ curl -s https://salsa.debian.org/postgresql/postgresql-common/raw/master/pgdg/apt.postgresql.org.sh | sudo bash

$ sudo apt-get update

$ sudo apt-get install postgresql-10 pgadmin4

// or

$ sudo apt-get install postgresql pgadmin4

pgadmin4 - v4.1

This works well for me: (Temporary solution)

cd $HOME
virtualenv --python=/usr/bin/python3.6 pgadmin4
source pgadmin4/bin/activate
pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.1/pip//pgadmin4-4.1-py2.py3-none-any.whl

Can you expand on the instructions? I had pgAdmin4 v3.6 installed. Couldn't figure out how to upgrade to pgAdmin4 v4.2. I then wanted to remove all traces of pgAdmin4 and couldn't figure out how to do that, either.

new wheel https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.3/pip/pgadmin4-4.3-py2.py3-none-any.whl

New wheel as of 2019-05-02: https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.6/pip/pgadmin4-4.6-py2.py3-none-any.whl

seems this is the kicker:

I then wanted to remove all traces of pgAdmin4 and couldn't figure out how to do that, either.

I'm not sure that wheels remove cleanly like, say, RPMs do, unless you vape the virtualenv.

Try that:

1. new virtualenv and new wheel
2. test app
3. vape old env

Ta-daa! But for the missing meta-info and visibility, it's like any other packaging setup. And the virtualenv does try to escape perl's "that week's release" problem at the expense of not tracking what was installed where for upgrades after day 2.

Step by Step here without any error [How] to install pgAdmin 4 in desktop mode on Ubuntu 16.04

I guess this site is not working