[postgis-users] Help resolving raster2pgsql error

[Darafei "Komяpa" Praliaskouski]

Your Proj installation seems broken.

аў, 22 чэр 2021, 23:32 карыстальнік Ben Boughton <bboughton at gmail.com>
напісаў:

> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210623/983719ff/attachment.html>