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 <kars...@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