Tuesday, March 27, 2018

Install pgadmin4 on Ubuntu

apt-get install virtualenv python-pip libpq-dev python-dev

wget whl file

mkdir pgadmin4

cd pgadmin4

virtualenv .

source bin/activate

pip install whlfile

echo "SERVER_MODE = False" >> lib/python2.7/site-packages/pgadmin4/config_local.py

sudo -s

mkdir /var/lib/pgadmin

mkdir /var/log/pgadmin

chmod gbsofts:gbsofts /var/lib/pgadmin

chmod gbsofts:gbsofts /var/log/pgadmin

exit


Create desktop icon
nano pgadmin4.desktop
#!/usr/bin/env xdg-open

[Desktop Entry]
Version=1.0
Type=Application
Terminal=false
Icon[en_US]=gnome-panel-launcher
Name[en_US]=PgAdmin4
Exec=bash /home/gbsofts/pgadmin4/pgadmin4.sh
Name=PgAdmin4
Icon=/home/gbsofts/pgadmin4/logo-128.png

chmod 755 pgadmin4.desktop

Create script
nano pgadmin4.sh
cd $HOME/pgadmin4
source bin/activate
python ./lib/python2.7/site-packages/pgadmin4/pgAdmin4.py  &
sleep 5; chromium-browser --app=http://localhost:5050