Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save libracoder/5ca467caa1f730187b2a4fd9ee068150 to your computer and use it in GitHub Desktop.
Save libracoder/5ca467caa1f730187b2a4fd9ee068150 to your computer and use it in GitHub Desktop.
Install pgAdmin4 v2.0 with python3 on Ubuntu 16.04 DESKTOP mode

Install pgAdmin4 v2.0 with python3 on Ubuntu 16.04 DESKTOP mode

  1. Get Python Wheel pgAdmin4

     wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.0/pip/pgadmin4-2.0-py2.py3-none-any.whl
    
  2. Install pip3

     sudo apt install python3-pip
    
  3. Install virtualenv

     sudo pip3 install virtualenv
    
  4. Create virtualenv in dir ~/py3-venv-pgadmin

     virtualenv --system-site-packages --no-setuptools --python=python3.5 ~/py3-venv-pgadmin
    
  5. Activate virtualenv

     cd ~/py3-venv-pgadmin/bin
     source activate
    
  6. Check pip3

     which pip3
     ~/py3-venv-pgadmin/bin/pip3
    
  7. Install pgAdmin4

     pip3 install pgadmin4-2.0-py2.py3-none-any.whl
    
  8. For desktop deployment

     cd ~/py3-venv-pgadmin/lib/python3.5/site-packages/pgadmin4
     touch config_local.py
     nano config_local.py
    

    write:

     import os
     SERVER_MODE = False
     DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))
     LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')
     SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')
     SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
     STORAGE_DIR = os.path.join(DATA_DIR, 'storage')
    

    run:

     python3 ~/py3-venv-pgadmin/lib/python3.5/site-packages/pgadmin4/setup.py
    
  9. Run pgAdmin4

     python3 ~/py3-venv-pgadmin/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py
    
  10. Exit virtualenv

     deactivate
    
  11. For run pgadmin4 create script ~/py3-venv-pgadmin/pgadmin4.sh

     #!/usr/bin/env bash
     cd ~/py3-venv-pgadmin/bin
     source activate
     python3 ~/py3-venv-pgadmin/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py
    
  12. Create alias for bash

     nano ~/.bashrc
    

    write at the end of file:

     alias pgadmin4='~/py3-venv-pgadmin/pgadmin4.sh'
    

    reload bashrc

     source ~/.bashrc
    

    now you can run pgadmin

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