<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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 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 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 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>
</body>
</html>