No proj support for postgresql in fgs-dev

[Hentschel, Markus]

Hi everybody,

tried to compile mapserver, postgresql and so on with fgs-dev. Works great!

One problem: There is no proj support for the postgresql database. Why? I have built the mapserver-php package with postgres included. Then I compiled the postgis package with the standart built.list (proj::4.5.0:/home/fgs/fgs-dev/src/proj-4.5.0 in the first line) and installed it in the FGS runtime.

What's the mistake?

Thanks for help


Markus


_______________________________________________
Foss-gis-suite mailing list
Foss-gis-suite@...
http://lists.maptools.org/mailman/listinfo/foss-gis-suite

[Frank Warmerdam-2]

Hentschel, Markus wrote:
> Hi everybody,
>
> tried to compile mapserver, postgresql and so on with fgs-dev. Works great!
>
> One problem: There is no proj support for the postgresql database. Why? I have built the mapserver-php package with postgres included. Then I compiled the postgis package with the standart built.list (proj::4.5.0:/home/fgs/fgs-dev/src/proj-4.5.0 in the first line) and installed it in the FGS runtime.
>
> What's the mistake?

Markus,

I skimmed pkg_def/postgis, and it seems to default to configuring with
proj support.  I'm surprised this isn't working.  If you manually run
fgs_build in the postgis build directory do you see any suspect messages
about proj?

I haven't got an fgs build setup handy just now to try it myself.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam@...
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org

_______________________________________________
Foss-gis-suite mailing list
Foss-gis-suite@...
http://lists.maptools.org/mailman/listinfo/foss-gis-suite

[pkorduan]

>> What's the mistake?

>Markus,

>I skimmed pkg_def/postgis, and it seems to default to configuring with
>proj support.  I'm surprised this isn't working.  If you manually run
>fgs_build in the postgis build directory do you see any suspect messages
>about proj?

>I haven't got an fgs build setup handy just now to try it myself.

Hi, Markus and Frank,
right, it seems to be default with proj support, but USE_PROJ in the Makefile.config in the postgis source directory is set to 0 after building the package with fgsdev build_all. The --enable-autoconf Parameter for ./configure script in postgis fgs_build script leads to this Makefile.config. Omitting the parameter leads to further errors. Setting USE_PROJ in Makefile.config direkt to 1 and call make leads also to errors, but errors concerning geos. ... Some thing seems to be wrong with autoconf. ...

Then I get postgis-1.3.1.tar.gz from http://www.postgis.org/download/ extracted to $FGS_DEV_HOME/src/postgis-1.3.1 create the symbolic links to fgs_build and fgs_install and changed the call for configure in this way

./configure --prefix=/opt/fgs-dev/built/postgis \
--with-geos=$FGS_BUILD_HOME/geos/bin/geos-config \
--with-proj=$FGS_BUILD_HOME/proj \
--with-pgsql=$FGS_BUILD_HOME/postgresql/bin/pg_config

configure will be called in postgis 1.3.1 without autoconf and with --with-pgsql (link to pg_config)

./fgs_build and ./fgs_install called in $FGS_BUILD_HOME/src/postgis-1.3.1 now work.

I have installed the modules in fgs, changed the path in lwpostgis.sql from /opt/fgs-dev/built/postgis/lib to /opt/fgs/lib and SELECT postgis_version() shows now USE_PROJ=1

For Markus, I describe this also in: https://kvwmap.geoinformatik.uni-rostock.de/index.php/Dokumentation#Kompilieren_eines_benutzerdefinierten_Modules_f.C3.BCr_fgs_am_Beispiel_postgis

Best regards
Peter Korduan