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

  1. Unknown12 August 2016 at 03:05

    I've got a problem. Postgis depends on libgdal1i but it's not installable.

    ReplyDelete
    Replies
    1. andyarthur3 December 2016 at 12:40

      Try:

      apt-get remove libgal1i

      Then when that library is broken as you try to remove it, remove any other programs listed that are said to be broken. Then re-install piece by piece.

      Delete
  2. Unknown7 December 2016 at 02:12

    Hello,

    thanks a lot for this article.
    quick question; ive setup postgresql 9.6 with postgis 2.3 on an ubuntu 16 server. the exensions are all set. the problem is i keep getting this error
    around

    usr@host:~$ psql -h localhost -U usr_name db_name
    perl: warning: Setting locale failed.
    perl: warning: Please check that your locale settings:
    LANGUAGE = (unset),
    LC_ALL = (unset),
    LC_CTYPE = "UTF-8",
    LANG = "en_US.UTF-8"
    are supported and installed on your system.
    perl: warning: Falling back to a fallback locale ("en_US.UTF-8")

    does it affect functionality? im setting postgres+postgis for testing with mapinfo and see if migrating from mysql is justifiable.

    thanks again

    ReplyDelete
    Replies
    1. Blackdog17 February 2017 at 23:38

      command =>
      dpkg-reconfigure locales

      sorts this out

      Delete
  3. cere blanco22 May 2017 at 20:56

    Unable to successfully run this one:
    sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" DB_NAME

    I keep getting this error:

    ERROR: could not open extension control file "/usr/share/postgresql/9.3/extension/postgis.control": No such file or directory

    ReplyDelete
    Replies
    1. Davy20 July 2017 at 06:11

      You need to install the postgis related packages before running the command.

      $ sudo apt-get install postgis postgresql-9.5-postgis-2.1

      then

      $ sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" DATABASE_NAME_HERE

      Delete

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