[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] PostgreSQL 13, PostGIS 3.1  import -  could not form projection
From:       "karsten" <karsten () terragis ! net>
Date:       2021-10-19 19:17:17
Message-ID: 207B37ED2DE64E74AAECB239B76DA9D8 () terragispc
[Download RAW message or body]

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


-----Original Message-----
From: karsten [mailto:karsten@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@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@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@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@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
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]