[Live-demo] Postgis questions

[Pieter du Plooy]

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 <maplabs at light42.com> wrote:

> Hi Pieter --
>
>
>
>   I have an a2 build running in a VM.
>
>
>
> user at live95a:~$ locate raster.tif        <= there is an example file for
> a QGis plugin called this
>
> user at 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 at live95a:~$  createdb raster_test
>
> user at live95a:~$ psql -c 'create extension postgis' raster_test
>
> user at 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 at live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif
> raster_test | less
>
>     inspect output, yes looks valid
>
>
>
> user at live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif
> raster_test | psql raster_test
>
> user at 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 <
> pjduplooy at 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 at 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20160123/90dad030/attachment.html>