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

Bborie Park dustymugs at gmail.com
Tue Feb 10 05:08:16 PST 2015


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


More information about the postgis-users mailing list