I added a raster to my PG database using the raster2pgsql and when I try to load it from QGIS it says that I need to specify it's geometry. Is that a common problem, and if so, how can I solve it?

The command that I used was

raster2pgsql -s 2100 -c C:\Users\user\Desktop\data\raster_2100.tif public.raster2 | psql -h localhost -U user1 -p

and SELECT * FROM raster_column prints this:

enter image description here

  • Did you import as an in- or out-of-database raster? Does it show as registered in the raster_columns catalog? – scabecks Sep 5 '17 at 9:37
  • The raster that I am referring to was at my local disk, so I imported in to my database at first and then out of my database into my QGIS session. Now, about that raster_columns are you referring to my database? Because I have no column named like that. – George Nostradamos Sep 5 '17 at 9:58
  • What does it return if you run 'SELECT * FROM raster_columns' ? – scabecks Sep 5 '17 at 10:14
  • @scabecks see my edit – George Nostradamos Sep 5 '17 at 10:24
  • From that you can tell it's not registering properly. Try re-importing the raster, adding the -C flag (-I to build an index too is a good idea often). – scabecks Sep 5 '17 at 10:46

When I first attempted to upload the raster to my database I was convinced that raster2psql was the best way to do that, but I decided to find another way through R, mainly from the library rpostgis, now I haven't solved it using raster2psql but because I am working with R as well, I have to say that the command pgWriteRast does the same work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.