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

[Matthew Baker]

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
>
>

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