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

[Gregory S. Williamson]

Adam --

> 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?

Yes

>                   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?

Precisely.

HTH

Greg Williamson
DBA
GlobeXplorer LLC