<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> oh, ok.. thats new to me..</p>
<p> according to the PostGIS docs page..</p>
<p> http://postgis.net/docs/postgis_gdal_enabled_drivers.html</p>
<p> </p>
<p> those variables can be set at all levels..</p>
<p> cluster-wide -> postgresql.conf</p>
<p> database-persistant -> ALTER DATABASE ...</p>
<p> database-temp, psql session temp -> set ....</p>
<p> </p>
<p>also apparently SHELL with bash-style environment vars, as in .bashrc</p>
<p> </p>
<p>I would think that all gdal drivers would be enabled by default, and that
really you</p>
<p>need raster out_db set... so I look here</p>
<p> http://postgis.net/docs/postgis_enable_outdb_rasters.html</p>
<p> </p>
<p>make sense ?</p>
<p> -Brian</p>
<p><br><br>On Sat, 23 Jan 2016 19:51:42 +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>Hi Brian<br><br>
</div>
Thx for the info, but what I really need is where to <br><pre class="">postgis.gdal_enabled_drivers = 'ENABLE_ALL'<br><br></pre>
<pre class="">and postgis.enable_outdb_rasters=1<br><br></pre>
<pre class="">in Ubuntu 14.04, and system wide<br><br></pre>
<pre class="">I did it previously in my .bashrc, but for some reason its not
working now.<br><br></pre>
<pre class="">Pieter</pre>
</div>
<div class="gmail_extra"><br><div class="gmail_quote">On Sat, Jan 23, 2016 at
6:58 PM, Brian M Hamlin <span><<a href="mailto:maplabs@light42.com" target="_blank">maplabs@light42.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0 0 0 .8ex; border-left: 1px #ccc solid;
padding-left: 1ex;">
<div>
<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>
<div>
<div class="h5">
<p> </p>
<p><br><br>On Sat, 23 Jan 2016 16:45:50 +0200, Pieter du Plooy <<a href="mailto:pjduplooy@zpanelcp.com" target="_blank">pjduplooy@zpanelcp.com</a>> wrote:</p>
</div>
</div>
<blockquote style="border-left: 2px solid #000000; padding-right: 0px;
padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div>
<div class="h5">
<div>
<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>
</div>
</div>
<hr>
<br> _______________________________________________<br> Live-demo mailing
list<br><a href="mailto:Live-demo@lists.osgeo.org" target="_blank">Live-demo@lists.osgeo.org</a><br><a href="http://../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="http://../hwebmail/services/go.php?url=http%3A%2F%2Flive.osgeo.org" target="_blank">http://live.osgeo.org</a><br><a href="http://../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><a href="http://blog.light42.com" target="_blank">blog.light42.com</a></p>
<p> </p>
</div>
</blockquote>
</div>
</div>
</div>
</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>