Hi Stefan, I personally don't use QGIS to visualize PostGIS rasters so I'm not of much help. I still use OpenJump to visualise vectorization of my rasters. It turns out to be always much more simple than figuring how to do it, with what, in QGIS.
There was a QGIS python plugin to display PostGIS raster. I don't think I tried it since QGIS 2.0 is out though. Apparently it is now broken :-( Anyway that plugin was, from my point of view, badly designed without a good understanding of the better way to exploit PostGIS Raster. I just gave a try to the recipe given in the post (using the DB Manager once a connection with PostGIS has been done) and it works when the raster was loaded with raster2pgsql and the constraints were set. Yes we need a SIMPLE way to deal with any PostGIS rasters in QGIS. Efforts should be concentrated on the "Add PostGIS Table" dialog. Maybe Boundless could help concentrating the efforts. Pierre > -----Original Message----- > From: Stefan Keller [mailto:[email protected]] > Sent: Sunday, June 08, 2014 2:53 AM > To: PostGIS Users Discussion > Cc: Pierre Racine > Subject: Re: [postgis-users] raster support > > Salut Pierre > > Can you help on how to display PostGIS Raster in QGIS 2.x exactly? > I've found this > http://postgis.17.x6.nabble.com/Problem-with-postgis-raster- > td5006344.html > > but it's not specific on how to achieve this. > > In addition, do you think QGIS needs a Python plugin (before it manages to > be adapted by QGIS core)? > > Yours, Stefan > > > > 2014-06-05 20:40 GMT+02:00 Pierre Racine <[email protected]>: > > > These variables are system variables, not PostgreSQL variables. to > know how to set them in your system search for "set environment variable > os x". > > Pierre > > > > -----Original Message----- > > From: [email protected] [mailto:postgis- > users- > > [email protected]] On Behalf Of John Payne > > Sent: Sunday, June 01, 2014 10:25 AM > > To: [email protected] > > Subject: [postgis-users] raster support > > > > I want to store raster data in PostGIS. I am using Postgresql 9.2.4 > with > > PostGIS 9.1.0 on a Mac Powerbook running OS X 10.8.5. I want to > use the > > command "raster2pgsql" but I get an error message saying that > the type > > "raster" was not recognized. > > > > I think the problem may be (from Chapter 2.1 of the PostGIS > manual): > > > > > > "As of PostGIS 2.1.3, out-of-db rasters and all raster drivers are > disabled by > > default. In order to re-enable these, you need to set the following > > environment variables:POSTGIS_GDAL_ENABLED_DRIVERS and > > POSTGIS_ENABLE_OUTDB_RASTERS in the server environment" > > > > > > I tried adding the following to the end of my postgresql.conf file: > > POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL > > POSTGIS_ENABLE_OUTDB_RASTERS=1 > > However, it generated an error message saying that the variables > weren't > > recognized. Can anyone tell me how to set them? > > > > Thanks, > > > > John > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
