[Qgis-user] QGIS and PostGIS raster (out-db)

[Jorge Gustavo Rocha]

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 
> <jgr at geomaster.pt> 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
>>     Qgis-user at lists.osgeo.org
>>     List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
>>     Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20211019/a773af9b/attachment.html>