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

[karsten]

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