Paul Shapley's Open Source GIS Blog

Not strictly a GI post but i think 'Mosaico' is worth a mention if you are creating and sending email templates regularly reporting on the projects your working on or any other marketing material and you need to be sure they scale on all devices. Unlike 'MailChimp' or 'BeeFree' it's open source. Have a look.

https://mosaico.io/

Install Ubuntu 17.04 (Zesty Zapus)
1.check your Ubuntu version:-

lsb_release -a

Install Postgresql
2.On the server or your PC (Terminal):-

sudo apt-get update
sudo apt-get install -y postgresql postgresql-contrib

Create a database and a user for access
Replace DATABASE_NAME_HERE and USER_NAME_HERE with the values you want to use.
# this will prompt you for a database password...also note the capital letter 'O' not number '0' (zero) below:-

3.sudo -u postgres createuser -P USER_NAME_HERE
sudo -u postgres createdb -O USER_NAME_HERE DATABASE_NAME_HERE

Test Connection to Postgresql
4.psql -h localhost -U USER_NAME_HERE DATABASE_NAME_HERE

Postgresql will ask you for your password. Then you should see the following:

DATABASE_NAME_HERE=>

To exit type:-

\q

To add PostGIS-2.3 support to the database
5.sudo apt-get install -y postgis postgresql-9.6-postgis-2.3
# typing 'postgresql-9.5' instead of postgresql-9.6 above will fail.

sudo -u postgres psql -c "CREATE EXTENSION po…