How to install Postgresql-9.3.5/9.4 and PostGIS-2.1 on Ubuntu 15.04 in six easy steps.

-

Install Ubuntu 15.04 (Vivid Vervet)


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:

psql (9.3.5)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

DATABASE_NAME_HERE=>

To exit type:-

\q

To add PostGIS-2.1 support to the database


5. sudo apt-get install -y postgis postgresql-9.4-postgis-2.1
# typing 'postgresql-9.3' instead of postgresql-9.4 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

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

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

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...Installation on Ubuntu 16.04 LTS

-
Image
Before we start it is always a good idea to remove and re-install apache2 web server so that we start from the same set up:- To remove Apache2:- $ sudo apt --purge remove apache2 $ sudo apt autoremove To re-install Apache2:- $ sudo apt install apache2 $ sudo /etc/init.d/apache2 restart # or $ sudo service apache2 restart 1. $ sudo apt install apache2 (if not installed already done so as above) 2. $ sudo apt install qgis-server libapache2-mod-fcgid 3. $ sudo a2enmod fcgid 4. $ sudo a2enconf serve-cgi-bin 5. $ sudo service apache2 restart 6. add the following code and don't forget to save the changes:- ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/ <Directory "/usr/lib/cgi-bin/"> Options ExecCGI FollowSymLinks Require all granted AddHandler fcgid-script .fcgi </Directory> into /etc/apache2/sites-available/ 000-default.conf $ sudo gedit /etc/apache2/sites-available/000-default.conf # so that it looks like this:- <VirtualHost *:80>   
Read more