[postgis-users] Can I change the path of an out-of-db raster?

[guido lemoine]

Oops, you CAN actually cache a bytea to raster, using encode(overlay(), 'hex')::raster. So my problem is solved. 
I can now address 15+ years of NDVI imagery in a single go! This is super efficient!

Guido

On 02/10/15, guido lemoine  <guido.lemoine at jrc.ec.europa.eu> wrote:
> 
> 
> Bborie,
> 
> In the meantime, I managed to use postgresql overlay to change the filename in the rast, but this results in a bytea which cannot be cached back to a raster.
> 
> I found a 2013 thread http://lists.osgeo.org/pipermail/postgis-users/2013-June/037163.html which asked for bytea -> raster conversion 
> (as a ST_AsBinary complement). If this exists in the meantime, it would likely solve my issue.
> 
> If not, I will file a ticket. 
> 
> GL 
> 
> On 02/10/15, Bborie Park  <dustymugs at gmail.com> wrote:
> > 
> > 
> > Hey Guido,
> > 
> > 
> > ST_SetBandPath doesn't exist but sounds like a worthwhile addition. Can you file a ticket for that?
> > 
> > 
> > http://trac.osgeo.org/postgis/
> > 
> > 
> > 
> > In the meantime, a workaround is to use symbolic links or mount points.
> > 
> > 
> > -bborie
> > 
> > 
> > On Tue, Feb 10, 2015 at 2:34 AM, guido lemoine <guido.lemoine at jrc.ec.europa.eu <guido.lemoine at jrc.ec.europa.eu>> wrote:
> > 
> > > 
> > > Hmm, any thoughts on this? Just to expand my use case: I have a time series of images that are all spatially aligned, i.e. same size, geo-location, pixel spacing, projection.
> > > Thus, raster2pgsql -R would always create the same tiled raster entries for each image where only the (binary) file name would be different. 
> > > If one would simply be able to change the filename, a single set of tile records would be needed. That would be a neat concept for time series (other than creating massive multi-band images).
> > > 
> > > Something like ST_SetBandPath(rast, filepath) could be useful, although only in the aligned context. 
> > > 
> > > GL
> > > 
> > > 
> > > 
> > > On 02/06/15, guido lemoine  <guido.lemoine at jrc.ec.europa.eu <guido.lemoine at jrc.ec.europa.eu>> wrote:
> > > > 
> > > > 
> > > > Dear List,
> > > > 
> > > > I have stored some rasters out-of-db (using raster2pgsql with the -R option). I have to move these rasters
> > > > to another disk and wonder if there is a simple way to update the BandPath to the new location, other
> > > > than dropping the tables and re-load with the new path. I see there is ST_BandPath, but not a corresponding
> > > > ST_SetBandPath(). 
> > > > 
> > > > Thanks!
> > > > 
> > > > Guido
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > 
> > > 
> > > _______________________________________________
> > > 
> > > postgis-users mailing list
> > > 
> > > postgis-users at lists.osgeo.org <postgis-users at lists.osgeo.org>
> > > 
> > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> > > 
> > 
> > 
> > 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150210/0b513ddf/attachment.html>