<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" data-hsystem="true"></head>
<body><style>p{margin: 0;padding: 0;}
</style>
<p>Hi Pieter --</p>
<p> </p>
<p> I have an a2 build running in a VM.</p>
<p> </p>
<p>user@live95a:~$ locate raster.tif <= there is an example
file for a QGis plugin called this</p>
<p>user@live95a:~$ gdalinfo /path/to/raster.tif</p>
<p> hmm non-trivial .. open qgis to let qgis do the work</p>
<p> qgis shows the projection is EPSG:32633</p>
<p> </p>
<p>user@live95a:~$ createdb raster_test</p>
<p>user@live95a:~$ psql -c 'create extension postgis' raster_test</p>
<p>user@live95a:~$ psql -c 'select postgis_full_version()' raster_test</p>
<p> yes, RASTER is enabled</p>
<p> use raster2pgsql to load a raster, as per PostGIS raster manual</p>
<p> </p>
<p>user@live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif raster_test
| less</p>
<p> inspect output, yes looks valid</p>
<p> </p>
<p>user@live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif raster_test
| psql raster_test</p>
<p>user@live95a:~$ psql -c '\d raster_test'</p>
<p> note rid, rast columns.. lots of other detail</p>
<p> better command line would name the tables, split into tiles,
etc...</p>
<p> </p>
<p> hth --Brian</p>
<p> </p>
<p><br><br>On Sat, 23 Jan 2016 16:45:50 +0200, Pieter du Plooy
<pjduplooy@zpanelcp.com> wrote:</p>
<blockquote style="border-left: 2px solid #000000; padding-right: 0px;
padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div id="html-message">
<div>
<div>
<div>I am struggling to enable postgis gdal drivers and outdb rasters on Ubuntu
(using postgis from the osgeolive nightly, so its for trusty.<br><br>How do I go
about enabling them in Ubuntu Trusty?<br><br>I have tried setting it in
.profile, as well as .bashrc systemwide etc..., but no luck.<br><br>Any
help?<br><br>
</div>
Regards<br><br>
</div>
Pieter</div>
</div>
<br><hr>
<br> _______________________________________________<br> Live-demo mailing
list<br> Live-demo@lists.osgeo.org<br><a href="../hwebmail/services/go.php?url=http%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Flive-demo" target="_blank">http://lists.osgeo.org/mailman/listinfo/live-demo</a><br><a href="../hwebmail/services/go.php?url=http%3A%2F%2Flive.osgeo.org" target="_blank">http://live.osgeo.org</a><br><a href="../hwebmail/services/go.php?url=http%3A%2F%2Fwiki.osgeo.org%2Fwiki%2FLive_GIS_Disc" target="_blank">http://wiki.osgeo.org/wiki/Live_GIS_Disc</a>
</blockquote>
<p><br><br></p>
<p><br> --<br>Brian M Hamlin<br> OSGeo California Chapter<br>
blog.light42.com<br></p>
<p> </p>
</body>
</html>