[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Help resolving raster2pgsql error
From: Ben Boughton <bboughton () gmail ! com>
Date: 2021-06-23 23:41:06
Message-ID: CAEi0wzL9Pcrr8pTsxn87SYJYCBgCiS2G_-Ph5ejxXjeLYTrkyg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 <lr@pcorp.us> wrote:
> > On Wed, 23 Jun 2021 at 08:32, Ben Boughton <bboughton@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
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> [Regina Obe]
>
> As Mike noted, proj.db has changed a number of times in proj releases.
> Last person I ran into with this particular problem was because they got
> their proj from main distro
> And they had installed QGIS/GDAL via UbuntuGIS which installed a newer
> version of proj. So they had two versions of proj, but the proj.db path was
> the newer.
>
> It was a mess to properly fix the install, so I ended up just giving him my
> copy of proj.db to overwrite his.
>
> Lesson: Don't mix distributions of GDAL/PROJ. Bad things happen.
>
> You can check which version of Proj your postgis is running with
>
> SELECT postgis_full_version();
>
> And whatever proj that says you should be using a proj.db that was built
> from that one.
> I've got a bunch of versions of proj hanging around, so I could give you my
> copy of proj.db for your version of Proj, if it comes to that.
>
> Hope that helps,
> Regina
>
>
>
>
[Attachment #5 (text/html)]
<div dir="ltr">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.<div><br clear="all"><div><div dir="ltr" class="gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Ben \
Boughton<div><br><br></div></div></div></div></div></div></div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 23 Jun 2021 at 11:19, \
Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> On Wed, 23 Jun \
2021 at 08:32, Ben Boughton <<a href="mailto:bboughton@gmail.com" \
target="_blank">bboughton@gmail.com</a>> wrote:<br> > > Processing 1/1: \
testr.tif<br> > > ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name,<br>
> > ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name,<br>
> > prime_meridian_code, area_of_use_auth_name, area_of_use_code,<br>
> > publication_date, deprecated FROM geodetic_datum WHERE auth_name = ?<br>
> > AND code = ?: no such column: area_of_use_auth_name<br>
> <br>
> You might have PROJ_LIB pointing to a different version of PROJ, as the<br>
schema<br>
> in proj.db has changed a few times between releases.<br>
> <br>
> <a href="https://proj.org/usage/environmentvars.html#envvar-PROJ_LIB" \
rel="noreferrer" target="_blank">https://proj.org/usage/environmentvars.html#envvar-PROJ_LIB</a><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> > <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> \
[Regina Obe] <br> <br>
As Mike noted, proj.db has changed a number of times in proj releases.<br>
Last person I ran into with this particular problem was because they got<br>
their proj from main distro<br>
And they had installed QGIS/GDAL via UbuntuGIS which installed a newer<br>
version of proj. So they had two versions of proj, but the proj.db path was<br>
the newer.<br>
<br>
It was a mess to properly fix the install, so I ended up just giving him my<br>
copy of proj.db to overwrite his.<br>
<br>
Lesson: Don't mix distributions of GDAL/PROJ. Bad things happen.<br>
<br>
You can check which version of Proj your postgis is running with <br>
<br>
SELECT postgis_full_version();<br>
<br>
And whatever proj that says you should be using a proj.db that was built<br>
from that one.<br>
I've got a bunch of versions of proj hanging around, so I could give you my<br>
copy of proj.db for your version of Proj, if it comes to that.<br>
<br>
Hope that helps,<br>
Regina<br>
<br>
<br>
<br>
</blockquote></div>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic