Just to clarify, I was wondering if this was indeed a valid installation
of PostGIS 2.1 and Postgresql 9.3
I had only seen a reference to the Postgresql APT repository as The
PostgreSQL build team is working on an APT repository
https://wiki.postgresql.org/wiki/Apt for PostgreSQL builds. They may
include PostGIS builds in the future. from http://postgis.net/install
Thanks,
-m
On 10/01/2013 10:06 AM, Matthew Baker wrote:
All,
Just for kicks yesterday I tried installing Postgresql 9.3 on Ubuntu
from their APT repository.
I also added a postgis flag in there and it seems to have all come in
very nicely!
Here's what I did based on instructions here:
http://wiki.postgresql.org/wiki/Apt
*
*run:*
/sudo gedit /etc/apt/sources.list/
*add to bottom:*
#postgresql9.3
debhttp://apt.postgresql.org/pub/repos/apt/ /precise/-pgdg main
*
run:*
wget --quiet -O -http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo
apt-key add -
sudo apt-get update
/sudo apt-get install postgresql-9.3-postgis pgadmin3/
*Create new PGSQL user:*
sudo su - postgres
createuser -d -E -i -l -P -r -s matthew_baker
**
Once logged in, all the extensions are available, including postgis,
postgis_topology, and postgis_tiger_geocoder...
Also, shp2pgsql-gui runs from terminal...(great!)
And when connected through QGIS 2.0, it works!
A version check yields:
POSTGIS=2.1.0 r11822 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.7.1, 23
September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8
LIBJSON=UNKNOWN RASTER
PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
So it seems I'm missing LIBJSON...?
Any thoughts appreciated! Hoping this fills a hole in the Ubuntu
installation...
-m
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users