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

Tue Oct 19 20:04:55 PDT 2021

Thanks so much for the hints.

It turns out that the trouble must likely stem from incompatible versions
from the  <http://postgresql.org/> postgresql.org and the ubuntugis unstable
repos. 

I was on IRC today and got sorted it out using hints from Regina O. I ended
up removing the postgres repro, re-installing using postgres 12 (from
'universe', and postgis 3, restored db from dump and thus got all working
now. 
However, of course this is now not postgres 13 now but a take away message
is that it might end up in trouble when using the two repos and end up with
'mixed' installs,  likely due to the bigger changes with proj in the newer
versions ...

Maybe I should just always use only Docker containers for such things to
avoid such trouble ...

Cheers
Karsten 

  _____  

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Richard Greenwood
Sent: Tuesday, October 19, 2021 19:51
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not
form projection

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/04bf5ff2/attachment.html>