[postgis-users] Installing on Ubuntu via Postgresql APT repository

[Matthew Baker]

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
deb http://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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131001/27d95e59/attachment.html>