Changes between Version 1 and Version 2 of UsersWikiPostGIS22UbuntuPGSQL95Apt

Timestamp:

Feb 11, 2016, 12:26:05 PM (8 years ago)

Author:

robe

Comment:

—

UsersWikiPostGIS22UbuntuPGSQL95Apt

@@ -57 +57 @@
 }}}
 
+Never install PostGIS in the postgres database, create a user database
 You can also enable the PostGIS extension here (or with the GUI as described below):
 
 {{{
+CREATE DATABASE gisdb;
+\connect gisdb;
+
 CREATE EXTENSION postgis;
-}}}
+SELECT postgis_full_version();
+}}}
+
+should give you output something like this:
+
+
+{{{
+                                                                         postgis_full_version
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ POSTGIS="2.2.1 r14555" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="0.11.99" RASTER
+(1 row)
+}}}
+
 
 Exit the psql console:
@@ -75 +91 @@
 
 {{{
-sudo nano /etc/postgresql/9.4/main/pg_hba.conf
+sudo nano /etc/postgresql/9.5/main/pg_hba.conf
 }}}