<div dir="ltr"><div><div><div><div><div><div><div><div>Hi Brian<br><br></div>In Ubuntu 14.04, set the last part of /etc/postgresql/9.4/main/postgresql.conf (under the comment <br># Add settings for extensions here<br><br><br></div>as such:<br><br>postgis.gdal_enabled_drivers 'ENABLE_ALL'<br>postgis.enable_outdb_rasters TRUE<br><br></div>restart postgres<br><br></div>In your postgis enabled db, do the following:<br>select long_name from st_gdaldrivers();<br><br></div>and you will see a lot of gdal enabled drivers<br><br></div>such as:<br><br> long_name <br>--------------------------------------------<br> Virtual Raster<br> GeoTIFF<br> National Imagery Transmission Format<br> Erdas Imagine Images (.img)<br> Arc/Info ASCII Grid<br> DTED Elevation Raster<br> Portable Network Graphics<br> JPEG JFIF<br> Graphics Interchange Format (.gif)<br> X11 PixMap Format<br> ILWIS Raster Map<br> SRTMHGT File Format<br> JPEG-2000 driver based on OpenJPEG library<br> FIT Image<br> JPEG-2000 part 1 (ISO/IEC 15444-1)<br> OGC Web Map Service<br> Idrisi Raster A.1<br> Intergraph Raster<br> Golden Software ASCII Grid (.grd)<br> Golden Software Binary Grid (.grd)<br> Golden Software 7 Binary Grid (.grd)<br> R Object Data Store<br> ESRI .hdr Labelled<br> FARSITE v.4 Landscape File (.lcp)<br> Azavea Raster Grid format<br> USGS Optional ASCII DEM (and CDED)<br> Epsilon wavelets<br> SAGA GIS Binary Grid (.sdat)<br> Kml Super Overlay<br> ASCII Gridded XYZ<br> HF2/HFZ heightfield raster<br> Geospatial PDF<br> WEBP<br> ZMap Plus Grid<br>(34 rows)<br><br></div>Regards<br><br></div>Pieter<br><div><div><div><div><div><br></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Jan 23, 2016 at 9:01 PM, Brian M Hamlin <span dir="ltr"><<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> oh, ok.. thats new to me..</p>
<p> according to the PostGIS docs page..</p>
<p> <a href="http://postgis.net/docs/postgis_gdal_enabled_drivers.html" target="_blank">http://postgis.net/docs/postgis_gdal_enabled_drivers.html</a></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> <a href="http://postgis.net/docs/postgis_enable_outdb_rasters.html" target="_blank">http://postgis.net/docs/postgis_enable_outdb_rasters.html</a></p>
<p> </p>
<p>make sense ?</p><span class="HOEnZb"><font color="#888888">
<p> -Brian</p></font></span><div><div class="h5">
<p><br><br>On Sat, 23 Jan 2016 19:51:42 +0200, Pieter du Plooy
<<a href="mailto:pjduplooy@zpanelcp.com" target="_blank">pjduplooy@zpanelcp.com</a>> wrote:</p>
<blockquote style="border-left:2px solid #000000;padding-right:0px;padding-left:5px;margin-left:5px;margin-right:0px">
<div>
<div>
<div>Hi Brian<br><br>
</div>
Thx for the info, but what I really need is where to <br><pre>postgis.gdal_enabled_drivers = 'ENABLE_ALL'<br><br></pre>
<pre>and postgis.enable_outdb_rasters=1<br><br></pre>
<pre>in Ubuntu 14.04, and system wide<br><br></pre>
<pre>I did it previously in my .bashrc, but for some reason its not
working now.<br><br></pre>
<pre>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>
<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>
<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>
<a href="http://blog.light42.com" target="_blank">blog.light42.com</a><br></p>
<p> </p>
</div></div></div>
</blockquote></div><br></div>