[postgis-users] raster2pgsql build from source...

[Brian Fitzgerald]

"The rendering of the raster in QGIS is slow because the GDAL PostGIS
raster driver does not use pyramids in addition to several other
inefficiencies (one query per row)

Is this something can be worked around or is being worked on?




On Fri, Sep 7, 2012 at 12:47 PM, Bborie Park <bkpark at ucdavis.edu> wrote:

> Brian,
>
> You should have raster2pgsql already since you compiled PostGIS from
> source.  There is no option in the build process to not compile
> raster2pgsql.
>
> The rendering of the raster in QGIS is slow because the GDAL PostGIS
> raster driver does not use pyramids in addition to several other
> inefficiencies (one query per row).
>
> -bborie
>
> On 09/07/2012 09:09 AM, Brian Fitzgerald wrote:
> > I've finally manged to get the following stack working
> >
> > - Linux Mint 13 Mate
> > - Postgresql 9.1
> > - GDAL 1.9.1 built from source
> > - GEOS 3.3.5 built from source
> > - Postgis 2.0.1 built from source with GEOS and GDAL above
> > - QGIS nightlies for ubuntu
> >
> > - I imported a digital ortho raster tiff (in SRID 2273) into Postgis
> using
> > the Database -> PostGIS Raster -> Load function
> > - I then loaded this raster into QGIS using the Database -> Postgis
> Raster
> > -> Add function
> >
> > This works 'ok'... the 1mile x 1mile 1ft res image does finally display,
> > but it takes like 2 minutes (presumably because there are no pyramids?)
> >
> > So I wanted to try and load a raster using the raster2pgsql tool...
> > however, I've realized that I don't have it because I built from
> source...
> > so:
> >
> > Is there a place I can download the raster2pgsql tool source and also
> build
> > it from scratch?
> > Is there an alternative?
> > Is the reason the image is drawing sooooo slowly a lack of pyramids?
> >
> > Thanks!!!
> >
> > - Brian
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark at ucdavis.edu
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
--------------------------------------
Brian Fitzgerald, PMP, GISP
bkfitz at gmail.com
803.426.3469
---------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120907/9083c2ef/attachment.html>