[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

[Sandro Santilli]

On Tue, Oct 01, 2013 at 10:06:05AM -0600, Matthew Baker wrote:

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

[...]

> So it seems I'm missing LIBJSON...?

You don't, it's just that libjson didn't have a version
exposing function at time of writing the version retrival
function. You'd get no "LIBJSON" string in output if you
had it missing.

--strk;
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[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 for PostgreSQL builds. They may include PostGIS builds in the future." from http://postgis.net/install

Thanks,

-m