[postgis-users] NAD conversion problem

[Peter N. Schweitzer]

Hello,

I have two PostgreSQL installations.  One uses 8.3.3 with PostGIS 1.3.3,
GEOS 3.0.1, and PROJ 4.6.1 (with proj-datumgrid-1.4).  With it I am able 
to run a command like

update county set nad27_geom=ST_Transform(the_geom,4267);

My newer installation uses 8.3.5 with PostGIS 1.3.4, GEOS 3.0.3, and
PROJ 4.6.1.  With this system I get the error message

WARNING:  transform: -38 (failed to load NAD27-83 correction file)
ERROR:  transform: couldn't project point: -38 (failed to load NAD27-83 correction file)

I know that proj-datumgrid-1.4.zip must be unzipped in the nad/
directory of proj-4.6.1 PRIOR to running configure.  I have done this.
I have also recompiled and reinstalled proj, GEOS, and PostGIS in that 
order, running ldconfig at the end of each step.  The directory
/usr/local/share/proj on each of these systems is identical.

I've tried recreating the database cluster, starting and stopping
the database instance, rebooting the machine, dropping and rebuilding
the spatial database, all to no avail.

So I'm looking for some setting that I may have missed, some environment
variable, or some trick to tell libproj.so.0.5.5 where its transform
files should go.

Both systems run Slackware 12.1.

I'm at wit's end.  Any clues?

Peter
-- 
Peter N. Schweitzer (MS 954, U.S. Geological Survey, Reston, VA 20192)
(703) 648-6533  FAX: (703) 648-6252  email: pschweitzer at usgs.gov
<http://geology.usgs.gov/peter/>