[postgis-users] Re: failure to load postgis.sql

[Robert W. Burgholzer]

Also,
You have to have the postgres database set to accept the pl/psql language, 
i.e. a script I use to do this:

#!/bin/sh
# creates a postgresql data base with postgis

createdb $1
createlang plpgsql $1
psql -d $1 -f /usr/local/pgsql/share/contrib/postgis.sql
psql -d $1 -f /usr/local/pgsql/share/contrib/spatial_ref_sys.sql

Robert W. Burgholzer
rburghol at veetee dot edu
History of Nutrition: "Buddha probably consumed a high-carb diet."