[Geoserver-users] Loading VMAP0 data into PostGIS

GeoServer GeoServer User
1

I’m trying to follow the Load VMAP0 wiki page but can’t get past step 4.

I am having trouble getting a valid PostGIS installation working on Windows 2000 Professional. I tried running the PostgreSQL Windows installer, selecting the PostGIS option, but it doesn’t seem to work right. The shp2pgsql executable exists and seems to create valid SQL but when I run it I get errors.

For example, I have a database named vmap0. When I run the following command:

shp2pgsql polbndl.shp polbndl | psql -d vmap0

I get an error telling me the AddGeometryColumn function doesn’t exist. Is this a sign PostGIS isn’t installed correctly? If so, what else do I have to do in order to get it working from the PostgreSQL installer?

Running the command on the wiki page says that the schema doesn’t exist. Do I need to prep the database by adding an associated schema for each .shp file?

I need some direction please!

Thanks
JAB

2

Is this a sign PostGIS isn't installed correctly? If so, what else do I

yes - your database doesnt have postgis installed on it.

You can get more info at postgis.refractions.net and the postgis mailing list.

dave
ps. I'll probably be working on the VMAP0 wiki pages in a few weeks.