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:-
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:
To exit type:-
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)
I've got a problem. Postgis depends on libgdal1i but it's not installable.ReplyDelete
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.
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
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.
sorts this out
Unable to successfully run this one:ReplyDelete
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
You need to install the postgis related packages before running the command.Delete
$ sudo apt-get install postgis postgresql-9.5-postgis-2.1
$ sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" DATABASE_NAME_HERE