Opened 2 years ago
Closed 21 months ago
#5294 closed defect (worksforme)
Postgis st_transform error: SQL Error [XX000]: ERROR: could not form projection (LWPROJ) from 'srid=7801' to 'srid=4326'
Reported by: | iknikolov | Owned by: | pramsey |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 3.2.4 |
Component: | postgis | Version: | 3.3.x |
Keywords: | Cc: | iknikolov |
Description
I have 4 servers with the same versions of OS (Ubuntu 20.04), Postgis and Postgre:
POSTGIS="3.2.1 5fae8e5" [EXTENSION] PGSQL="130" GEOS="3.10.1-CAPI-1.16.0" PROJ="6.3.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" PostgreSQL 13.6 (Ubuntu 13.6-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
The query below works on any server except one:
SELECT st_asgeojson(st_transform("table-name".geom, 4326)) AS way FROM "table-name"
The server with the issue responds whiy this error:
SQL Error [XX000]: ERROR: could not form projection (LWPROJ) from 'srid=7801' to 'srid=4326'
I upgraded the PostGIS server to 3.3.2 but the result is the same.
Can you help me?
Change History (3)
comment:1 by , 2 years ago
Milestone: | PostGIS 3.3.3 → PostGIS 3.2.4 |
---|
comment:2 by , 2 years ago
oops sorry I missed the part about you having upgraded to 3.3.2.
Did you run:
SELECT postgis_extensions_upgrade();
after? that should fix issue of spatial_ref_sys if it is your spatial_ref_sys at fault.
comment:3 by , 21 months ago
Resolution: | → worksforme |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
You are several micro versions behind the latest stable 3.2. I'd suggest upgrading just to rule out any issues already fixed.
I'm running below so a bit newer than your setup.
What does this output in the database that is not working and in your others?
in psql
mine outputs:
also can you check what this outputs, in particular the one erroring does it fail on this?
mine outputs: POINT(25.5 42.667872450492496)
The issue sounds like possibly missing proj grid files so something off with your PROJ installation.