Hello all,

I have just successfully completed the steps below to install the latest version of Postgres and pgAdmin4
My previous questions on MySQL caused my thoughts to fork after meditating on long term needs. Postgres, I feel, is to be the better fit.
If there was an easier way to do this or if there are any mistakes, feel free to point out.
Also, please know this is just the install and I have not tried to actually use the database yet. There is still much to learn but getting this far in last 48hrs has been educational..

################################

#Install Postgres and client
# 1.) sudo to root ( i.e. user@yourbox:~# )

sudo apt-get install postgresql-9.6 postgresql-client

################################

PGAdmin4 ver 1.5 - Install & run instructions 05292017

################################

# 2.) Install virtalenv and other required packages...

sudo apt-get install build-essential     #this may already be installed
sudo apt-get libssl-dev python-dev libgmp3-dev
sudo apt-get install virtualenv python-pip libpq-dev

#cd /opt
#mkdir enviornmentpy

#cd enviornmentpy
virtualenv pgadmin4

#cd pgadmin4
source bin/activate     #this will activate the virtual enviornmnet

#The next line should look like this...
      # " (pgadmin4) user@yourbox:/opt/environmentpy/pgadmin4# "

# 3.) Download and install PGAdmin4

wget https://ftp.postgresql.org/pub/pgadmin/ … ne-any.whl

pip install pgadmin4-1.5-py2.py3-none-any.whl

#cd lib/python2.7/site-packages/pgadmin4

#The next line should look like this...
      # " (pgadmin4) user@yourbox:/opt/environmentpy/pgadmin4/lib/python2.7/site-packages/pgadmin4# "

touch config_local.py

#4.) Configuration ## We need to write the SERVER_MODE = False to run in single user mode...

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

#5.) Run PGAdmin4

python pgAdmin4.py

#Initial setup message will prompt you to enter email address and a password
#Follow prompts correctly and should see " database has been created at /root/.pgadmin/pgadmin4.db  ..etc..etc "Please navigate to http://localhost:5050 in your   browser"

#Open your browser and gain access by pasting the following into browser
http://localhost:5050

#Enter login/password
#In the General tab, name the DB
#In the Conneciton tab enter host address and port 5432 and database username/pass

...DONE