All drivers are disabled by default as a security precaution.
However if you are running PostgreSQL 9.4 or above, you should be able to set these with ALTER SYSTEM, which is cross-platform way of doing it. The link that Brian provided does have an example of ALTER SYSTEM - http://postgis.net/docs/postgis_gdal_enabled_drivers.html So if you run the below in psql or pgAdmin, you should be able to access all drivers permanently (since ALTER SYSTEM settings get stored in postgresql.auto.conf that gets loaded on each postgresq server startup) ALTER SYSTEM SET postgis.gdal_enabled_drivers TO 'ENABLE_ALL'; SELECT pg_reload_conf(); Then you can confirm it works by running this query: SELECT * FROM ST_GDALDrivers(); Hope that helps, Regina From: Live-demo [mailto:live-demo-boun...@lists.osgeo.org] On Behalf Of Brian M Hamlin Sent: Saturday, January 23, 2016 2:02 PM To: live-demo@lists.osgeo.org; Pieter du Plooy <pjdupl...@zpanelcp.com> Subject: Re: [Live-demo] Postgis questions 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 <pjdupl...@zpanelcp.com <mailto:pjdupl...@zpanelcp.com> > 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 <mapl...@light42.com <mailto:mapl...@light42.com> > 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 <pjdupl...@zpanelcp.com <mailto:pjdupl...@zpanelcp.com> > 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 Live-demo@lists.osgeo.org <mailto:Live-demo@lists.osgeo.org> 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 <http://blog.light42.com> -- Brian M Hamlin OSGeo California Chapter blog.light42.com
_______________________________________________ Live-demo mailing list Live-demo@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/live-demo http://live.osgeo.org http://wiki.osgeo.org/wiki/Live_GIS_Disc
