Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Select an option

  • Save saltyfireball/e7f1ab561bcbf94e00b9a3ac270ea14a to your computer and use it in GitHub Desktop.

Select an option

Save saltyfireball/e7f1ab561bcbf94e00b9a3ac270ea14a to your computer and use it in GitHub Desktop.
Install pgAdmin4 v3.6 on Ubuntu 18.04 w/python 3.6 using DESKTOP mode

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

  1. Get source code 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/pgadmin.sh'
    

    reload bashrc

     source ~/.bashrc
    

    now you can run pgadmin

     pgadmin4
    
@Nitish3793
Copy link

source ~/.zshrc
is giving error : bash: source: /home/nitish/: is a directory

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