[postgis-users] Installing PostGIS - createlang plpgsql / lwpostgis.sql / spatial_ref_sys.sql?

[jcradock at me3.com]

Yes. You need to enabled and load PostGIS for each database you would like
GIS extensions enabled.

> I'm at the part in installing PostGIS where I'm doing:
>
>
>
> 1.  PostGIS requires the PL/pgSQL procedural language extension. Before
> loading the lwpostgis.sql file, you must first enable PL/pgSQL. You should
> use the createlang command. The PostgreSQL Programmer's Guide has the
> details if you want to this manually for some reason.
>
> # createlang plpgsql [yourdatabase]
>
> 2.  Now load the PostGIS object and function definitions into your
> database
> by loading the lwpostgis.sql definitions file.
>
> # psql -d [yourdatabase] -f lwpostgis.sql
>
> 3.  The PostGIS server extensions are now loaded and ready to use.
> For a complete set of EPSG coordinate system definition identifiers, you
> can
> also load the spatial_ref_sys.sql definitions file and populate the
> SPATIAL_REF_SYS table.
>
> # psql -d [yourdatabase] -f spatial_ref_sys.sql
>
>
>
> My question is:  Are you loading the PostGIS extensions on a Database by
> Database level?  If I start a new database will it just be a plain
> PostgreSQL DB until you do the above commands, and at that point when the
> commands finish will the DB now be PostGIS enabled?
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-----
James Cradock, jcradock at me3.com