I used the following command to import a bunch of raster to postgis out-db style (only pointers to the rasters are stored in the database):
raster2pgsql -s {srid} -c -R -I -C -F -t auto {file_name} public.{table} | psql -h {host} -p {port} -d {database} -U {user} --no-passwordNow I want to rename all those files that I previously imported. I already renamed them on the filesystem. Now when I try to retrieve them I get:
psycopg2.InternalError: rt_band_load_offline_data: Cannot open offline raster: /myfilepath/file_name.tifWhere in the Postgis db to I rename the files (edit the pointer path) so that I can access them again? I'm hoping I can do this without re-importing everything again using raster2psgsql.
أكثر...
raster2pgsql -s {srid} -c -R -I -C -F -t auto {file_name} public.{table} | psql -h {host} -p {port} -d {database} -U {user} --no-passwordNow I want to rename all those files that I previously imported. I already renamed them on the filesystem. Now when I try to retrieve them I get:
psycopg2.InternalError: rt_band_load_offline_data: Cannot open offline raster: /myfilepath/file_name.tifWhere in the Postgis db to I rename the files (edit the pointer path) so that I can access them again? I'm hoping I can do this without re-importing everything again using raster2psgsql.
أكثر...