pgAdmin 4 v1.0 released on 2016-09-29.
As I was asked about how to install that it can be easily launched like other programs from Ubuntu launcher,I decided to share this with you.
pgAdmin 4 runs with Python 2.
So make sure that you have Python 2 installed on your system. Also we will use pip and virtualenv and for package management and isolating the python environment required to run pgAdmin 4. Run the commands below to install the requirements.
#requirements_install.sh sudo apt-get install python2.7-dev virtualenv python-pip libpq-dev
Create a directory to init our isolated python environment there.
Let's pick up ~/apps/pgadmin4/ for instance.
#virtualenv_activation.sh mkdir -p ~/apps/pgadmin4/ cd ~/apps/pgadmin4 virtualenv venv -p /usr/bin/python2.7 source ./venv/bin/activate
Now that you have cloned the environment,you should download and install the wheel package of pgAdmin 4 from here .
#pgadmin4_install.sh wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.0/pip/pgadmin4-2.0-py2.py3-none-any.whl pip install pgadmin4-1.4-py2.py3-none-any.whl
pgAdmin4 needs config_local.py to run.
This file can be cloned from the existing config.py from current installation path.
#clone_config.sh cp ./venv/lib/python2.7/site-packages/pgadmin4/config.py \ ./venv/lib/python2.7/site-packages/pgadmin4/config_local.py
You can change the initial values for SECRET_KEY,SECURITY_PASSWORD_SALT and CSRF_SESSION_KEY manually in this file.
Test your installation by running:
#test_installation.sh python ./venv/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
You may be prompted to enter email and password for new user registeration.
Once you have provided the needed information,you can access the app by browsing http://127.0.0.1:5050/
Now that we are sure about the success in running pgAdmin 4 by calling the prevIoUs command,let's create an Ubuntu launcher for this application.
Create pgAdmin4.sh and pgAdmin4.desktop files:
#create_launcher.sh touch pgAdmin4.sh pgAdmin4.desktop chmod +x pgAdmin4.sh pgAdmin4.desktop
Put the contents below in pgAdmin4.sh:
pgAdmin4.sh #! /bin/bash source ~/apps/pgadmin4/venv/bin/activate python ~/apps/pgadmin4/venv/local/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py &
sleep 5; sensible-browser http://127.0.0.1:5050
Put the contents below in pgAdmin4.desktop:
#pgAdmin4.desktop [Desktop Entry] Name=pgAdmin 4 Exec=/home/user/apps/pgadmin4/pgAdmin4.sh Icon=/home/user/apps/pgadmin4/pgadmin.svg Type=Application Categories=Database; Terminal=false
Link pgAdmin4.desktop to ~/.local/share/applications/ that Ubuntu can autoload the launcher.
#link_launcher.sh ln -s ~/apps/pgadmin4/pgAdmin4.desktop ~/.local/share/applications/
Download pgAdmin icon . and save it to ~/apps/pagadmin4/ as pgadmin.svg.
You can also use the command below:
#download_svg_icon.sh wget http://kiahosseini.github.io/assets/image/pgadmin4_install/pgadmin.svg
That's all.
It should now open your browser[tab] loading http://127.0.0.1:5050.
You may see an error in loading the page. Try to refresh the page in this case. It may take longer to launch the server. Be patient!