[mapserver-users] Mapserver and PostgreSQL

[Jan Hartmann]

Kieran,

It is in the PostGIS distribution: $PGHOME/contrib/postgis-0.7.3/loader. 
It is not compiled in by default: you have to do a "make" in that 
directory and copy "shp2pgsql" to some place in your path.

I don't think there is a Windows binary available. There is Cygwin of 
course, but that has to be compiled from source. Perhaps someone on this 
list has a recent compiled version of shp2pgsql for Cygwin available?

I would advise you to look at Frank Warmerdam's ogr2ogr. It can convert 
between most vector GIS formats, including PostGIS. Windows binaries are 
available (with many other things) at:

http://prdownloads.sourceforge.net/openev/OpenEV_FW_141.zip

or:

ftp://ftp.remotesensing.org/pub/gdal/gdal-115a-ntbin.zip

Jan Hartmann

Kieran J. Ames wrote:
> I'd not heard of shp2pgsql before.
> Is there a windows version of shp2pgsql around? I looked in my Mapserver
> directory and don't see it.
> Thanks,
> Kieran
>