Skip to main content

I am attempting to write a raster file to a PostGIS DB held on AWS. There is a schema set up to write to and the PostGIS Raster extension has been enabled in the DB. I've added the connection into FME and can successfully connect to it

Running the writer gives the following error message;

 

"Writer failed to create table 'tif.test' because requested schema '\\\\gis\\GIS\\Qgis\\Data\\Raster\\Open Map Local Raster\\SP56SE' does not exist. Please specify an existing schema

POSTGIS_RASTER writer: Writer failed in write() call"

 

Can someone advise me why this is failing and how to resolve it.

Hi @simonhume​: would it be possible for you to share your workspace, or screenshots of your Writer Feature Type parameters (of both the Parameters and User Attributes tabs)? I'm curious to know how you set up your schema definition for this writer feature type.

 

Could you please let us know what version and build of FME you are using? Thanks.


From my experience and your error message I think "\\\\gis\\GIS\\Qgis\\Data\\Raster\\Open Map Local Raster\\SP56SE" is set in the Table Qualifier of the writer.

Postgres Raster SchemaLeave blank if your connection is set directly to the schema or enter just the schema name otherwise.

I this is not the case please give us more detais.


Hi @simonhume​: would it be possible for you to share your workspace, or screenshots of your Writer Feature Type parameters (of both the Parameters and User Attributes tabs)? I'm curious to know how you set up your schema definition for this writer feature type.

 

Could you please let us know what version and build of FME you are using? Thanks.

hi @nampreetatsafe

 

Thanks for your reply.

 

I am using FME 2021.1.3.0 Build 21631

 

When I attach an Inspector to the Reader (the single GeoTIFF) it displays okay; clicking on the image displays co-ordinate information

 

The DB connection to the PostGIS AWS schema (ordnance_survey_raster) works fine

 

The PostGIS raster writer confirguration is shown in the following screenshot;

 

 

Running this works fine and the image is uploaded into the DB, but the image isn't visible in QGIS, with no coordinate information attached.


sorry @nampreetatsafe

images weren't attached


Reply