<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Just to clarify, I was wondering if this was indeed a valid
installation of PostGIS 2.1 and Postgresql 9.3<br>
<br>
I had only seen a reference to the Postgresql APT repository as "The
PostgreSQL build team is working on an <a
href="https://wiki.postgresql.org/wiki/Apt">APT repository</a> for
PostgreSQL builds. They may include PostGIS builds in the future."
from <a class="moz-txt-link-freetext" href="http://postgis.net/install">http://postgis.net/install</a><br>
<br>
Thanks,<br>
<br>
-m<br>
<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 10/01/2013 10:06 AM, Matthew Baker
wrote:<br>
</div>
<blockquote cite="mid:524AF2ED.507@gmail.com" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
All,<br>
<br>
Just for kicks yesterday I tried installing Postgresql 9.3 on
Ubuntu from their APT repository.<br>
<br>
I also added a postgis flag in there and it seems to have all come
in very nicely!<br>
<br>
Here's what I did based on instructions here:<br>
<br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://wiki.postgresql.org/wiki/Apt">http://wiki.postgresql.org/wiki/Apt</a><br>
<br>
*********<br>
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<p style="margin-bottom: 0.2in; font-style: normal"><font size="3"><b>run:</b></font></p>
<p style="margin-bottom: 0.2in; font-weight: normal"><font
size="3"><i>sudo
gedit /etc/apt/sources.list</i></font></p>
<pre class="western" style="margin-bottom: 0.2in"><font face="sans-serif" size="3"><b>add to bottom:</b></font><font face="sans-serif">
<font size="3">#postgresql9.3
deb <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://apt.postgresql.org/pub/repos/apt/">http://apt.postgresql.org/pub/repos/apt/</a> <i>precise</i>-pgdg main</font>
<font size="3"><b>
run: </b></font>
<font size="3">wget --quiet -O - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc">http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc</a> | sudo apt-key add -</font>
<font size="3">sudo apt-get update</font>
<font size="3"><i>sudo apt-get install postgresql-9.3-postgis pgadmin3</i></font></font></pre>
<p style="margin-bottom: 0in"><font size="3"><b>Create new PGSQL
user:</b></font></p>
<pre class="western"><font face="sans-serif" size="3">sudo su - postgres</font><font face="sans-serif">
<font size="3">createuser -d -E -i -l -P -r -s matthew_baker</font></font></pre>
<title></title>
<meta name="GENERATOR" content="LibreOffice 4.0.4.2 (Linux)">
<style type="text/css">
<!--
@page { margin: 0.79in }
PRE.cjk { font-family: "WenQuanYi Micro Hei", monospace }
PRE.ctl { font-family: "Lohit Hindi", monospace }
P { margin-bottom: 0.08in }
-->
</style>**********<br>
<br>
Once logged in, all the extensions are available, including
postgis, postgis_topology, and postgis_tiger_geocoder...<br>
<br>
Also, shp2pgsql-gui runs from terminal...(great!)<br>
<br>
And when connected through QGIS 2.0, it works!<br>
<br>
A version check yields:<br>
<br>
"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"<br>
<br>
"PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit"<br>
<br>
So it seems I'm missing LIBJSON...?<br>
<br>
Any thoughts appreciated! Hoping this fills a hole in the Ubuntu
installation...<br>
<br>
-m<br>
<br>
<br>
</blockquote>
<br>
</body>
</html>