Hi Tim,
Glad it worked. My tip was just to debug the problem.
You don't have to move your data. You just need to make sure the
postgresql daemon has access to that folder, on your file server.
Regards,
Jorge Gustavo
On 19/10/21 01:54, tim dunlevie wrote:
thanks Jorge !
So moving the image and loading it again from the Postgresql data
folder worked.
Is it good practise to move/reassign this data directory to a
different path?
Our imagery is stored on a file server, was hoping to simply 'point'
to this area.
thanks
On Mon, Oct 18, 2021 at 10:43 PM Jorge Gustavo Rocha
<[email protected]> wrote:
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
_______________________________________________
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
