<div dir="ltr">I think "unknown elliptical parameter name" is the giveaway. I'm guessing you haven't installed the NAD grids in your new install, so it's unable to dereference "NAD83" into something it can use. <div><br></div><div>P</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 9, 2017 at 1:44 PM, Andrew Joseph <span dir="ltr"><<a href="mailto:ap.joseph@live.com" target="_blank">ap.joseph@live.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I receive the following error when running st_transform(geom,4326) on an<br>
ogr_fdw foreign table:<br>
<br>
[XX000] ERROR: AddToPROJ4SRSCache: could not parse proj4 string '+proj=lcc<br>
+lat_1=31.88333333333333 +lat_2=30.11666666666667 +lat_0=29.66666666666667<br>
+lon_0=-100.3333333333333 +x_0=699999.9998983998 +y_0=3000000 +datum=NAD83<br>
+units=us-ft +no_defs ' unknown elliptical parameter name<br>
<br>
This does not occur when I import the data into postgis manually using<br>
ogr2ogr and then run st_transform() on the concrete table.<br>
<br>
This issue was not present on the following configuration:<br>
<br>
POSTGIS="2.3.2 r15302" GEOS="3.6.1-CAPI-1.10.1 r0" SFCGAL="1.3.0" PROJ="Rel.<br>
4.8.0, 6 March 2012" GDAL="GDAL 2.2.0dev, released 2016/99/99"<br>
LIBXML="2.9.1" LIBJSON="0.11.99" TOPOLOGY RASTER<br>
<br>
But appears on the configuration below with the same dataset:<br>
<br>
POSTGIS="2.4.1 r16012" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6"<br>
SFCGAL="1.3.0" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.3.0dev,<br>
released 2017/99/99" LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY RASTER<br>
<br>
gdalsrsinfo output<br>
==============================<wbr>==============================<wbr>====<br>
gdalsrsinfo -e ESRI::testshp.prj<br>
<br>
EPSG:2277<br>
<br>
PROJ.4 : +proj=lcc +lat_1=31.88333333333333 +lat_2=30.11666666666667<br>
+lat_0=29.66666666666667 +lon_0=-100.3333333333333 +x_0=699999.9998983998<br>
+y_0=3000000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=us-ft +no_defs<br>
<br>
OGC WKT :<br>
PROJCS["NAD83 / Texas Central (ftUS)",<br>
GEOGCS["NAD83",<br>
DATUM["North_American_Datum_<wbr>1983",<br>
SPHEROID["GRS 1980",6378137,298.257222101,<br>
AUTHORITY["EPSG","7019"]],<br>
TOWGS84[0,0,0,0,0,0,0],<br>
AUTHORITY["EPSG","6269"]],<br>
PRIMEM["Greenwich",0,<br>
AUTHORITY["EPSG","8901"]],<br>
UNIT["degree",0.<wbr>0174532925199433,<br>
AUTHORITY["EPSG","9122"]],<br>
AUTHORITY["EPSG","4269"]],<br>
PROJECTION["Lambert_Conformal_<wbr>Conic_2SP"],<br>
PARAMETER["standard_parallel_<wbr>1",31.88333333333333],<br>
PARAMETER["standard_parallel_<wbr>2",30.11666666666667],<br>
PARAMETER["latitude_of_origin"<wbr>,29.66666666666667],<br>
PARAMETER["central_meridian",-<wbr>100.3333333333333],<br>
PARAMETER["false_easting",<wbr>2296583.333],<br>
PARAMETER["false_northing",<wbr>9842500.000000002],<br>
UNIT["US survey foot",0.3048006096012192,<br>
AUTHORITY["EPSG","9003"]],<br>
AXIS["X",EAST],<br>
AXIS["Y",NORTH],<br>
AUTHORITY["EPSG","2277"]]<br>
<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html" rel="noreferrer" target="_blank">http://postgis.17.x6.nabble.<wbr>com/PostGIS-User-f3516033.html</a><br>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></blockquote></div><br></div>