[postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not form projection

[Richard Greenwood]

On Tue, Oct 19, 2021 at 1:34 PM karsten <karsten at terragis.net> wrote:

> Is anyone out there that happens to know
> how can I make PostgreSQL use the new proj lib version I have installed?
>

I imagine that you would need to build postgis from source to get it to use
the newer proj version (and install the corresponding libproj-dev,
libgeos-dev, etc.). But before you go to that trouble you should explore
other options. Why not just comment out the offending line and put the
index in later? I did a quick test creating a table with
geometry(MultiPolygon,2263) and then
   CREATE INDEX test_geohash ON test USING btree
(st_geohash(st_transform(wkb_geometry, 4326)));
and go no errors. I'm on Ubuntu 20.02, postgres 13, postgis 3.1 installed
from the postgresql.org repo (not the native Ubuntu repo).

Try firing up a clean AWS instance and starting clean. I can't imagine that
you really need proj > 6.

Rich




> -----Original Message-----
> From: karsten [mailto:karsten at terragis.net]
> Sent: Friday, October 15, 2021 12:03
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not
> form projection
>
> I installed  proj-bin v 7.2.1-1 that was available from the apt packages
> but
> in postgres (also after) restart of the db it still list PROJ="6.3.1" being
> used.
>
> How can I make postgresql use the new proj ?
>
>
> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> Behalf
> Of karsten
> Sent: Friday, October 15, 2021 11:47
> To: 'PostGIS Users Discussion'
> Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not
> form projection
>
> Yes will try to get this to work and report back here.
>
> The stack exchange issue mentioned that it worked with an older gdal
> version
>
> so will try with both different proj and gdal combinations
>
> Karsten
>
> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> Behalf
> Of Paul Ramsey
> Sent: Friday, October 15, 2021 11:36
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not
> form projection
>
> There's something very particular about your environment and I don't know
> what it is. Try upgrading your proj version, and jimmying with other
> version
> combinations. There's nothing special about the SRID numbers, they work
> fine
> for me locally. I can't invest the time in setting up a mirror system that
> matches yours. If there's something specific about proj 6.3.1 maybe? (both
> you and the stack exchange issue)
>
> P
>
> > On Oct 15, 2021, at 11:11 AM, karsten <karsten at terragis.net> wrote:
> >
> > Hi All,
> >
> > on new server with Ubuntu 20.04 , PostgreSQL 13, PostGIS 3.1 I am
> > trying to import a plain sql dump . This mostly worked but when the
> > script is executing the creation of a geohash (involving a
> > transformation from srid 2263 to geographic 4326) like this
> >
> > CREATE INDEX parcels_geohash ON parcels USING btree
> > (st_geohash(st_transform(geom, 4326)));
> >
> > I am getting this error:
> > could not form projection (PJ) from 'srid=2263' to 'srid=4326'
> >
> > How can I fix this ?
> >
> > Here are more details about the environment:
> > postgres: PostgreSQL 13.4 (Ubuntu 13.4-4.pgdg20.04+1) on
> > x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04)
> > 9.3.0, 64-bit
> > postgis_version: 3.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
> > postgis_proj_version: 6.3.1
> >
> > Cheers
> > Karsten
> >
> > Karsten Vennemann
> > www.terragis.net
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>


-- 
Richard W. Greenwood
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211019/c0deee4b/attachment.html>