PostGIS raster2pgsql problem

Question

I ran into this problem in PostGIS:

raster2pgsql -c -I -C -s 4326  -N -9999  -M -Y  -F ./test2/*.tif  rdem2 > rdem2.sql

Processing 84/84: ./test2/dem2_4326_06_14.tif

ERROR: diff_rastinfo: Could not run raster alignment test

Does someone have any ideas about possible reasons for this problem ?

Could you explain a bit more about what data you are trying to import? There could be known issues with known sources of data which can help shed light on your challenges. — ragnvald, Commented Apr 21, 2015 at 12:55
Do you see the error if you do not request to apply constraints? Remove -C and try without it. — mloskot, Commented Sep 22, 2017 at 6:46

mloskot · Accepted Answer · 2017-09-22 06:44:56Z

1

I think that error might happen if your proj files used by GDAL can not be found. Alignment relies on that as I recall.

What does:

SELECT postgis_full_version();

return. If it returns GDAL_DATA can not be found, then that's the problem. Since that is where it looks for the coordinate reference files.

mloskot

2292 silver badges7 bronze badges

answered Apr 21, 2015 at 16:27

Regina Obe

10.6k1 gold badge23 silver badges28 bronze badges

I should add, if that is the problem, you need to set the environment variable -- GDAL_DATA and it should point at the folder installed by gdal that contains files like compdcs.csv, gcs.csv. On linux I think its in share/gdal and on windows it gets installed in PostgreSQL install folder in a folder called gdal-data
– Regina Obe
Commented Apr 21, 2015 at 17:00

Add a comment |

1 Answer 1