Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save ThomasG77/c0769593196ee387c77ed77bb8a3dbe2 to your computer and use it in GitHub Desktop.
Save ThomasG77/c0769593196ee387c77ed77bb8a3dbe2 to your computer and use it in GitHub Desktop.
5 minutes PgAdmin4 Desktop install guide

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

@bish0polis
Copy link

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.

@rkappagantu
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment