- Check with the stack builder for PostGIS spatial Extension is installed.
- Enable to install(if not) and click next.
- Download and install postGIS extension.
- Once it is installed check for the database postgis/template_postgis. If any of the above databases is there then that can be used.
- Otherwise create a new database manually and execute the sql file which should be located @ <c:\postgresinstallationlocation>\share\contrib\ with the name of postgis.sql.
- That database will have two tables called geometry_columns & spatial_ref_sys, some 100s of functions and some trigger functions.
- Now using that database as a template, any number of databases can be created with PostGIS enabled.
Thursday, September 15, 2011
Installing & Enabling PostGIS in Postgres
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment