[postgis-tickets] [PostGIS] #4402: raster2pgsql debug methods needed, GEOTIFF stalling for hours on addrasterconstraints

[PostGIS]

#4402: raster2pgsql debug methods needed, GEOTIFF stalling for hours on
addrasterconstraints
----------------------+-----------------------------------------------
  Reporter:  osgeoap  |      Owner:  Bborie Park
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.4.8
 Component:  raster   |    Version:  2.4.x
Resolution:           |   Keywords:  addrasterconstraint, raster2pgsql
----------------------+-----------------------------------------------

Comment (by osgeoap):

 Paul:
 Yes, I tried the same command without'-C' and the image loads.
 Same number of rows, one image per table.
 I reviewed the postgres log and see that the last query issued is
 addrastercontraints.
 There is also a table showing the query running for hours, (typically
 takes <30 seconds)
 raster2pgsql-d -s 4326 -C -r -I -F -q -e -t 256x256 -M filename tablename
 | psql ....

 NOTE: I load the same image into QGIS and/or ArcGIS Pro and save it as a
 GeoTif
 and it loads fine with -C.

 ideally there would be flag to dump/log addrastercontraints detailed
 verbose progress.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4402#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.