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

[Bborie Park]

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