org.postgresql.util.PSQLException: ERROR: AddToPROJ4SRSCache: could not parse proj4 string

[jdrake]

Using postgresql 2.5.0 (Ubuntu 18.4 package postgresql-10-postgis-2.5), I was getting the following exception from the query ST_Transform(ST_GeomFromText('POINT(…)', 4326), 102008):

org.postgresql.util.PSQLException: ERROR: AddToPROJ4SRSCache: could not parse proj4 string '+proj=aea +lat_1=20.0 +lat_2=60.0+lat_0=40.0+lon_0=-96 +x_0=0 +y_0=0 +ellps=GRS80 +datum=NAD83 +units=m no_defs' unknown unit conversion id SQL state: XX000

This appeared to be fixed by manually changing the proj4text to have a '+' in front of no_defs: update spatial_ref_sys set proj4text='+proj=aea +lat_1=20.0 +lat_2=60.0+lat_0=40.0+lon_0=-96 +x_0=0 +y_0=0 +ellps=GRS80 +datum=NAD83 +units=m +no_defs' where srid = 102008

[jdrake]

Replying to jdrake: Correction - using postgis 2.5.0, not postgresql 2.5.0.

Using postgresql 2.5.0 (Ubuntu 18.4 package postgresql-10-postgis-2.5), I was getting the following exception from the query ST_Transform(ST_GeomFromText('POINT(…)', 4326), 102008):

org.postgresql.util.PSQLException: ERROR: AddToPROJ4SRSCache: could not parse proj4 string '+proj=aea +lat_1=20.0 +lat_2=60.0+lat_0=40.0+lon_0=-96 +x_0=0 +y_0=0 +ellps=GRS80 +datum=NAD83 +units=m no_defs' unknown unit conversion id SQL state: XX000

This appeared to be fixed by manually changing the proj4text to have a '+' in front of no_defs: update spatial_ref_sys set proj4text='+proj=aea +lat_1=20.0 +lat_2=60.0+lat_0=40.0+lon_0=-96 +x_0=0 +y_0=0 +ellps=GRS80 +datum=NAD83 +units=m +no_defs' where srid = 102008

[robe]

Josh,

Was this record you inserted? I don't see srid=102008 in the spatial_ref_sys table we distribute.

[robe]

I'm dismissing as invalid since I think this was a user entered record and not one we ship. All ours have +no_defs where we use no_defs.