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

[Paul Ramsey]

srid entries have to exist in spatial_ref_sys table, do they?

select srtext from spatial_ref_sys where srid in (2263, 4326);

> 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