[postgis-users] Help resolving raster2pgsql error

[Ben Boughton]

I am having issues loading raster via raster2pgsql (RELEASE: 3.1.2
GDAL_VERSION=30 (cbe925d)); postgres (PostgreSQL) 13.3 (Ubuntu
13.3-1.pgdg20.04+1)

If I run:

raster2pgsql -C -R testr.tif testr > out.sql

Output:

Processing 1/1: testr.tif
ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name,
ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name,
prime_meridian_code, area_of_use_auth_name, area_of_use_code,
publication_date, deprecated FROM geodetic_datum WHERE auth_name = ? AND
code = ?: no such column: area_of_use_auth_name
ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name,
ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name,
prime_meridian_code, area_of_use_auth_name, area_of_use_code,
publication_date, deprecated FROM geodetic_datum WHERE auth_name = ? AND
code = ?: no such column: area_of_use_auth_name
ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name,
ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name,
prime_meridian_code, area_of_use_auth_name, area_of_use_code,
publication_date, deprecated FROM geodetic_datum WHERE auth_name = ? AND
code = ?: no such column: area_of_use_auth_name
free(): invalid pointer
Aborted (core dumped)


Even just running:

raster2pgsql

gives the version and options followed by:

free(): invalid pointer
Aborted (core dumped)


The out.sql file is incomplete and doesn't load into database.

Any pointers appreciated. Thanks


Ben Boughton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210623/91ed64da/attachment.html>