Re: [postgis-users] Help resolving raster2pgsql error

2021-06-23 Thread Ben Boughton
I tried a clean install - this time with the UbuntuGIS-Unstable and just did 'apt get install postgis' - I got postgis3 and postgresql12 and raster2pgsql working. Ben Boughton On Wed, 23 Jun 2021 at 11:19, Regina Obe wrote: > > On Wed, 23 Jun 2021 at 08:32, Ben Boughton wrote: > > > Process

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-23 Thread Ben Boughton
I did a fresh install on Ubuntu 20.04 of postgresql-13-postgis-3 followed by apt install postgis to get raster2pgsql I have the same problem. It appears that postgresql-13-postgis-3 depends on libproj15 > 6 and postgis depends on libproj15 > 4.9 - would this be the problem? If so, how do I go ab

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-23 Thread Ben Boughton
Thanks - sounds complicated. I am running a fair bit of different stuff on the one remote server - including an install of QGIS and POSTGIS. I might just spin up a tiny unique environment to get this job done, save messing up other things that rely on proj. Ben Boughton On Wed, 23 Jun 2021 at

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-22 Thread Regina Obe
> On Wed, 23 Jun 2021 at 08:32, Ben Boughton 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,

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-22 Thread Mike Taves
On Wed, 23 Jun 2021 at 08:32, Ben Boughton 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 F

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-22 Thread Komяpa
Your Proj installation seems broken. аў, 22 чэр 2021, 23:32 карыстальнік 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.ti