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@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
