<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>Re: [postgis-users] Problems finding PostgresQL on an FC4 installation</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi Mike,</FONT>
</P>
<P><FONT SIZE=2>That did the trick. I had looked at the configure help, I just didn't </FONT>
<BR><FONT SIZE=2>give it the full path to pg_config.</FONT>
</P>
<P><FONT SIZE=2>Dan</FONT>
</P>
<P><FONT SIZE=2>On 6-Jan-06, at 4:40 PM, Mike Leahy wrote:</FONT>
</P>
<P><FONT SIZE=2>> Dan,</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> When I did this, I had set the pgsql parameter to point to </FONT>
<BR><FONT SIZE=2>> 'pg_config', and this has usually been the requirement for most </FONT>
<BR><FONT SIZE=2>> PostgreSQL-based builds that I done so far. If you run './ </FONT>
<BR><FONT SIZE=2>> configure --help', you should see this is mentioned in the info </FONT>
<BR><FONT SIZE=2>> listed there. Below is the configuration I used (my pgsql is </FONT>
<BR><FONT SIZE=2>> installed in /usr by the released RPMs for FC4), and I had no </FONT>
<BR><FONT SIZE=2>> problems with the build.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> ./configure --prefix=/usr/local --with-pgsql=/usr/bin/pg_config -- </FONT>
<BR><FONT SIZE=2>> with-geos=/usr/local/bin/geos-config --with-proj=/usr/local</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Hope this helps,</FONT>
<BR><FONT SIZE=2>> Mike</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Putler, Dan wrote:</FONT>
<BR><FONT SIZE=2>>> Hi All,</FONT>
<BR><FONT SIZE=2>>> I'm having a heck of a time installing PostGIS 1.1.0 on an FC4 </FONT>
<BR><FONT SIZE=2>>> system (with a P3 processor) that is running Postgresql 8.1.1, </FONT>
<BR><FONT SIZE=2>>> GEOS 2.2.1, and Proj 4.4.9.</FONT>
<BR><FONT SIZE=2>>> I installed Postgresql from source with /usr/local/pgsql as the </FONT>
<BR><FONT SIZE=2>>> installation directory. As a result, I configured PostGIS using </FONT>
<BR><FONT SIZE=2>>> the option --with-pgsql=/usr/local/pgsql (I've also tried /usr/ </FONT>
<BR><FONT SIZE=2>>> local and / usr/local/pgsql/bin as the postgres directories). </FONT>
<BR><FONT SIZE=2>>> Things seem to go along fine with configure since it finds geos, </FONT>
<BR><FONT SIZE=2>>> and proj, and doesn't complain about postgres. However, when I </FONT>
<BR><FONT SIZE=2>>> become root and attempt make, bad things happen. I created a </FONT>
<BR><FONT SIZE=2>>> transcript of the session, and here are the first few lines of </FONT>
<BR><FONT SIZE=2>>> the output of the make process, which might provide a clue to my </FONT>
<BR><FONT SIZE=2>>> problem:</FONT>
<BR><FONT SIZE=2>>> make -C lwgeom</FONT>
<BR><FONT SIZE=2>>> make[1]: execvp: /usr/local/pgsql: Permission denied</FONT>
<BR><FONT SIZE=2>>> make[1]: Entering directory `/home/putler/build/postgresql-8.1.1/ </FONT>
<BR><FONT SIZE=2>>> contrib/postgis-1.1.0/lwgeom'</FONT>
<BR><FONT SIZE=2>>> make[1]: execvp: /usr/local/pgsql: Permission denied</FONT>
<BR><FONT SIZE=2>>> make[1]: execvp: /usr/local/pgsql: Permission denied</FONT>
<BR><FONT SIZE=2>>> make[1]: execvp: /usr/local/pgsql: Permission denied</FONT>
<BR><FONT SIZE=2>>> make[1]: execvp: /usr/local/pgsql: Permission denied</FONT>
<BR><FONT SIZE=2>>> make[1]: execvp: /usr/local/pgsql: Permission denied</FONT>
<BR><FONT SIZE=2>>> gcc -DUSE_VERSION=82 -DPOSTGIS_LIB_VERSION='"1.1.0"' - </FONT>
<BR><FONT SIZE=2>>> DPOSTGIS_VERSION='"1.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"' - </FONT>
<BR><FONT SIZE=2>>> DPOSTGIS_SCRIPTS_VERSION='"1.1.0"' - </FONT>
<BR><FONT SIZE=2>>> DPOSTGIS_BUILD_DATE='"2006-01-06 22:23:57"' -I/usr/local/include - </FONT>
<BR><FONT SIZE=2>>> DUSE_PROJ -I -DAUTOCACHE_BBOX=1 - DUSE_STATS -Wall -g -O2 -fPIC - </FONT>
<BR><FONT SIZE=2>>> fexceptions -DUSE_GEOS -I/usr/local/ include -c -o liblwgeom.o </FONT>
<BR><FONT SIZE=2>>> liblwgeom.c</FONT>
<BR><FONT SIZE=2>>> In file included from liblwgeom.c:26:</FONT>
<BR><FONT SIZE=2>>> lwgeom_pg.h:4:22: error: postgres.h: No such file or directory</FONT>
<BR><FONT SIZE=2>>> lwgeom_pg.h:5:29: error: utils/geo_decls.h: No such file or directory</FONT>
<BR><FONT SIZE=2>>> lwgeom_pg.h:6:18: error: fmgr.h: No such file or directory</FONT>
<BR><FONT SIZE=2>>> In file included from liblwgeom.c:26:</FONT>
<BR><FONT SIZE=2>>> lwgeom_pg.h:28: error: syntax error before â</FONT>
<BR><FONT SIZE=2>>> The three header files make can't find are part of postgres, so </FONT>
<BR><FONT SIZE=2>>> my guess is make still can't find postgres. I've played with </FONT>
<BR><FONT SIZE=2>>> LD_LIBRARY_PATH without any luck (which isn't surprising since it </FONT>
<BR><FONT SIZE=2>>> doesn't point to the header directories). Any ideas about what </FONT>
<BR><FONT SIZE=2>>> I'm not doing to make postgres visible?</FONT>
<BR><FONT SIZE=2>>> Dan</FONT>
<BR><FONT SIZE=2>>> --------------------------------------------------------------------- </FONT>
<BR><FONT SIZE=2>>> ---</FONT>
<BR><FONT SIZE=2>>> _______________________________________________</FONT>
<BR><FONT SIZE=2>>> postgis-users mailing list</FONT>
<BR><FONT SIZE=2>>> postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2>>> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users" TARGET="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> postgis-users mailing list</FONT>
<BR><FONT SIZE=2>> postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2>> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users" TARGET="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
</P>
</BODY>
</HTML>