[postgis-users] Help resolving raster2pgsql error

[Mike Taves]

On Wed, 23 Jun 2021 at 08:32, Ben Boughton <bboughton at gmail.com> wrote:
> 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

You might have PROJ_LIB pointing to a different version of PROJ, as
the schema in proj.db has changed a few times between releases.

https://proj.org/usage/environmentvars.html#envvar-PROJ_LIB