How to install Postgresql-9.6 and PostGIS-2.3 on Ubuntu 17.04 (Zesty Zapus) in six easy steps (updated 31-05-2017).

-

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 postgis; CREATE EXTENSION postgis_topology;" DATABASE_NAME_HERE

6. Finally... install PgAdmin3 and set your 'service' connections

 sudo apt-get install pgadmin3

My thanks to Jon Saints for his original post dated from 13th August 2014 (for Ubuntu 14.04)
http://www.saintsjd.com/2014/08/13/howto-install-postgis-on-ubuntu-trusty.html
http://www.github.com/saintsjd
http://facebook.com/saintsjd

Comments

Post a Comment

Popular posts from this blog

Install PostreSQL 14 and PostGIS 3 on Ubuntu 22.04 LTS

-
Image
I always get frustrated when I update my version of Ubuntu to the next LTS and want to do some development work with the latest stable releases of PostgreSQL and PostGIS.  I usually trawl a few web sites to find out what has changed but each time there are slightly different ways of doing the upgrade depending on where you land and who it is doing it. So...to (hopefully) help other people out wasting half a day or so here is my solution.  Hope this works for you too... To completely remove all previous installed versions of Postgresql/PostGIS libraries and docs if there is a previous version:-  :$ sudo apt --purge remove postgresql postgresql-*  :$ sudo apt autoremove  Remove old folders:-  :$ sudo rm -rf /var/lib/postgresql/  :$ sudo rm -rf /var/log/postgresql/  :$ sudo rm -rf /etc/postgresql/   Remove the old 'postgres' user:- :$ sudo deluser postgres    Restart System:-  :$ sudo shutdown -r now then:-  Update Syste...
Read more

Install QGIS 3.22 LTS with QGIS-SERVER-3.22 and Apache2 on Ubuntu 22.04 LTS

-
Image
Install QGIS-SERVER-3.22   (assuming 'qgis' and 'qgis-plugin-grass' already on Ubuntu 22.04 LTS) (if not) :~$ sudo apt install qgis qgis-plugin-grass (then) :~$ sudo apt install qgis-server [sudo] password for paul: Reading package lists... Done Building dependency tree... Done Reading state information... Done qgis-server is already the newest version (3.22.16+dfsg-1~jammy3). 0 to upgrade, 0 to newly install, 0 to remove and 19 not to upgrade. Check the version installed: :~$ /usr/lib/cgi-bin/qgis_mapserv.fcgi --version QGIS 3.22.16-Białowieża 'Białowieża' (exported) QGIS code branchRelease 3.22 Qt version 5.15.3 Python version 3.10.6 GDAL/OGR version 3.6.2 PROJ version 9.1.1 EPSG Registry database version v10.076 (2022-08-31) GEOS version 3.11.1-CAPI-1.17.1 SQLite version 3.37.2 OS Ubuntu 22.04.2 LTS Now Install Apache2 :~$ sudo apt install apache2 [sudo] password for paul:  Reading package lists... Done Building dependency tree... Done Reading state informati...
Read more

Qgis-server...Installing the QGIS Lizmap Plugin & Lizmap Web Client

-
Image
This post follows on from my previous three (most recent first in list) linked below. There is no doubt that in just a short time from now we will probably see a 'one-click' installer to by-pass the next steps but a least this method allows you to change 'in/out' the individual libraries if there is are updates using the usual ' sudo apt update && sudo apt upgrade '. http://www.paulshapley.com/2016/08/qgis-server-bringing-map-into-browser.html http://www.paulshapley.com/2016/07/how-to-install-qgis-server-on-ubuntu.html http://www.paulshapley.com/2016/04/how-to-install-postgresql-95-and.html 1.  Firstly...Create a new QGIS project, add your layers from PostGIS, Shapefiles or raster (geotiff), style and symbolise those layers, set the projection and ensure you've set up your 'OWS Server' in 'Project Properties'. 2.  Let's install the 'Lizmap' Plugin first by going into the 'Plugins' menu then 'Manage...
Read more