For QGIS, you need to use the PostGIS Raster plugin, not the PostGIS plugin.
-bborie On 07/30/2012 01:26 PM, Melpati, Muni wrote: > I cannot answer for that. If anyone had this problem and fixed it, I would > like to know how they have done it. > > Moreover, When I tries to store raster data outside the database, I could not > even add the layer from QGIS. When I tried to add the layer using postgis > plugin, I find raster layer related columns (pixel type, is extrernal file, > pixel size x, pixel size y in the "load potgis raster layer " interface, has > values none. I must have done something wrong. When I add this raster layer, > QGIS crashes. > > Here is the syntax I have used: > > raster2pgsql -I -R -e -Y -F -s 26986 -t 128x128 c:\PostGIS\raster\dowell.jpg > public.raster | psql -U postgres -d gisdb -h localhost -p 5432 > > > > Anything wrong with it. Thanks. > > > > > > > > Date: Mon, 30 Jul 2012 12:16:52 +0200 > > From: Paolo Cavallini <cavall...@faunalia.it<mailto:cavall...@faunalia.it>> > > Subject: Re: [postgis-users] view raster data and query performance > > To: > postgis-users@postgis.refractions.net<mailto:postgis-users@postgis.refractions.net> > > Message-ID: > <50165f14.6060...@faunalia.it<mailto:50165f14.6060...@faunalia.it>> > > Content-Type: text/plain; charset="iso-8859-1" > > > > Il 27/07/2012 23:22, Melpati, Muni ha scritto: > >> > >> I have also changed postgresql.config file to improve the performance > >> with no noticeble difference. Can anyone faced this problem or have > >> any suggestion to improve the performance? Thanks in advance. > >> > >> > > Agreed, it is so slow to be barely usable in real world. I suppose this is > due to the GDAL provider, right? > > All the best. > > > > -- > > Paolo Cavallini - Faunalia > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
