Hi Brian
In Ubuntu 14.04, set the last part of
/etc/postgresql/9.4/main/postgresql.conf (under the comment
# Add settings for extensions here
as such:
postgis.gdal_enabled_drivers 'ENABLE_ALL'
postgis.enable_outdb_rasters TRUE
restart postgres
In your postgis enabled db, do the following:
select long_name from st_gdaldrivers();
and you will see a lot of gdal enabled drivers
such as:
long_name
--------------------------------------------
Virtual Raster
GeoTIFF
National Imagery Transmission Format
Erdas Imagine Images (.img)
Arc/Info ASCII Grid
DTED Elevation Raster
Portable Network Graphics
JPEG JFIF
Graphics Interchange Format (.gif)
X11 PixMap Format
ILWIS Raster Map
SRTMHGT File Format
JPEG-2000 driver based on OpenJPEG library
FIT Image
JPEG-2000 part 1 (ISO/IEC 15444-1)
OGC Web Map Service
Idrisi Raster A.1
Intergraph Raster
Golden Software ASCII Grid (.grd)
Golden Software Binary Grid (.grd)
Golden Software 7 Binary Grid (.grd)
R Object Data Store
ESRI .hdr Labelled
FARSITE v.4 Landscape File (.lcp)
Azavea Raster Grid format
USGS Optional ASCII DEM (and CDED)
Epsilon wavelets
SAGA GIS Binary Grid (.sdat)
Kml Super Overlay
ASCII Gridded XYZ
HF2/HFZ heightfield raster
Geospatial PDF
WEBP
ZMap Plus Grid
(34 rows)
Regards
Pieter
On Sat, Jan 23, 2016 at 9:01 PM, Brian M Hamlin <[email protected]> wrote:
> Hi Pieter --
>
>
>
> oh, ok.. thats new to me..
>
> according to the PostGIS docs page..
>
> http://postgis.net/docs/postgis_gdal_enabled_drivers.html
>
>
>
> those variables can be set at all levels..
>
> cluster-wide -> postgresql.conf
>
> database-persistant -> ALTER DATABASE ...
>
> database-temp, psql session temp -> set ....
>
>
>
> also apparently SHELL with bash-style environment vars, as in .bashrc
>
>
>
> I would think that all gdal drivers would be enabled by default, and that
> really you
>
> need raster out_db set... so I look here
>
> http://postgis.net/docs/postgis_enable_outdb_rasters.html
>
>
>
> make sense ?
>
> -Brian
>
>
>
> On Sat, 23 Jan 2016 19:51:42 +0200, Pieter du Plooy <
> [email protected]> wrote:
>
> Hi Brian
>
> Thx for the info, but what I really need is where to
>
> postgis.gdal_enabled_drivers = 'ENABLE_ALL'
>
> and postgis.enable_outdb_rasters=1
>
> in Ubuntu 14.04, and system wide
>
> I did it previously in my .bashrc, but for some reason its not
> working now.
>
> Pieter
>
>
> On Sat, Jan 23, 2016 at 6:58 PM, Brian M Hamlin <[email protected]>
> wrote:
>
>> Hi Pieter --
>>
>>
>>
>> I have an a2 build running in a VM.
>>
>>
>>
>> user@live95a:~$ locate raster.tif <= there is an example file for
>> a QGis plugin called this
>>
>> user@live95a:~$ gdalinfo /path/to/raster.tif
>>
>> hmm non-trivial .. open qgis to let qgis do the work
>>
>> qgis shows the projection is EPSG:32633
>>
>>
>>
>> user@live95a:~$ createdb raster_test
>>
>> user@live95a:~$ psql -c 'create extension postgis' raster_test
>>
>> user@live95a:~$ psql -c 'select postgis_full_version()' raster_test
>>
>> yes, RASTER is enabled
>>
>> use raster2pgsql to load a raster, as per PostGIS raster manual
>>
>>
>>
>> user@live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif
>> raster_test | less
>>
>> inspect output, yes looks valid
>>
>>
>>
>> user@live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif
>> raster_test | psql raster_test
>>
>> user@live95a:~$ psql -c '\d raster_test'
>>
>> note rid, rast columns.. lots of other detail
>>
>> better command line would name the tables, split into tiles, etc...
>>
>>
>>
>> hth --Brian
>>
>>
>>
>>
>>
>> On Sat, 23 Jan 2016 16:45:50 +0200, Pieter du Plooy <
>> [email protected]> wrote:
>>
>> I am struggling to enable postgis gdal drivers and outdb rasters on
>> Ubuntu (using postgis from the osgeolive nightly, so its for trusty.
>>
>> How do I go about enabling them in Ubuntu Trusty?
>>
>> I have tried setting it in .profile, as well as .bashrc systemwide
>> etc..., but no luck.
>>
>> Any help?
>>
>> Regards
>>
>> Pieter
>> ------------------------------
>>
>> _______________________________________________
>> Live-demo mailing list
>> [email protected]
>> http://lists.osgeo.org/mailman/listinfo/live-demo
>> <http://../hwebmail/services/go.php?url=http%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Flive-demo>
>> http://live.osgeo.org
>> <http://../hwebmail/services/go.php?url=http%3A%2F%2Flive.osgeo.org>
>> http://wiki.osgeo.org/wiki/Live_GIS_Disc
>> <http://../hwebmail/services/go.php?url=http%3A%2F%2Fwiki.osgeo.org%2Fwiki%2FLive_GIS_Disc>
>>
>>
>>
>>
>> --
>> Brian M Hamlin
>> OSGeo California Chapter
>> blog.light42.com
>>
>>
>>
>
>
>
> --
> Brian M Hamlin
> OSGeo California Chapter
> blog.light42.com
>
>
>
_______________________________________________
Live-demo mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/live-demo
http://live.osgeo.org
http://wiki.osgeo.org/wiki/Live_GIS_Disc
