[mapserver-users] Mapserver and PostgreSQL

[Martin Hoegh]

Hi
You don't need to install PostgreSQL from source, you just need to have a installed source tree. Do a make but not a make install. This way you can use a rpm version of PostgreSQL an still extent it with Postgis. This works fine with SuSE 8 and PostgreSQL 7.2.

Remember to install the PostgreSQL development rpm.

/Martin


----- Original Message ----- 
From: "Arjen Vrielink" <vrielink at sarvision.com>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Thursday, November 21, 2002 4:01 PM
Subject: [mapserver-users] Mapserver and PostgreSQL


> Hello All,
> 
> I was wondering if I could connect to a PostgreSQL database directly 
> from Mapserver. The problem is that we have SuSE 8.1 doing the 
> installation of PostgreSQL so we don't have the pg src code on our 
> machine which you need to install / compile PostGIS. Not being convinced 
> about the benefits of POSTGIS after reading the documentation I decided 
> I could live without it. That is, until I tried to get Mapserver connect 
> to my Postgres db --> There are no error messages but I don't get the 
> layer displayed either (I use an ESRI shapefile which I dumped to SQL 
> code for testing). So my basic question is: do I really need Postgis 
> (and what are the benefits of Postgis anyway)? if I really need postgis, 
> I will get the postgres source code and install it manually on my linux box.
> 
> Suggestions would be appreciated, thanks
> 
> using:
> Linux 2.4.something
> PostgreSQL 7.2
> Mapserver 3.6
> (PHP 4.3.0RC1)
> 
> arjen,
> SarVision
> Wageningen
> The Netherlands
> 
> 
>