Hi Tim,
No problem here with rasters out of db.
Postgresql needs to know where the raster is and must have access to it
later, when you open it on QGIS.
Try moving the raster to Postgresql data folder. Run 'SHOW
data_directory;' to know where Postgresql stores the data. Copy the
raster to that folder and try again with the full absolute path.
Regards,
Jorge Gustavo
On 18/10/21 04:04, tim dunlevie wrote:
Hi all,
Was wondering if someone has a similar experience.
I'm testing storing raster data in my PostGIS db as an 'out-db' option.
It seems to work via the raster2pgsql command line.
The table is generated and I can see the table thru the QGIS
browser/DB Manager.
However, if I drag/drop onto the map I get nothing.
I can, however, zoom to the extents of the image....but I get no image
appearing.
The image is a geotiff.
In-database option works fine.
I'm using QGIS v3.20.3-Odense with Postgresql 13.4 windows.
Has anyone had success managing their raster data like this and
viewing in QGIS ?
My command to store out-db image is below:
|raster2pgsql -s 28350 -C -I -F “path\[image_name].tif"
[schema1].[tablename] -R | psql -h localhost -d spatialDB -U postgres
-p 5432|
thanks
_______________________________________________
Qgis-user mailing list
[email protected]
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
