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

[guido lemoine]

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/d22ff737/attachment.html>