--Creating a template postgis database or new postgis database  --
1) Copy the contents of this folder into C:\Program Files\PostgreSQL\8.4 or where you have installed
2) "C:\Program Files\PostgreSQL\8.4\bin\psql" -p 5432 -U postgres -c "CREATE DATABASE template_postgis14"
3) "C:\Program Files\PostgreSQL\8.4\bin\psql" -p 5432 -U postgres -d template_postgis14 -c "CREATE LANGUAGE plpgsql"
4) "C:\Program Files\PostgreSQL\8.4\bin\psql" -p 5432 -U postgres -d template_postgis14 -f "C:\Program Files\PostgreSQL\8.4\share\contrib\postgis\postgis.sql"
5) "C:\Program Files\PostgreSQL\8.4\bin\psql" -p 5432 -U postgres -d template_postgis14 -f "C:\Program Files\PostgreSQL\8.4\share\contrib\postgis\spatial_ref_sys.sql"
6) "C:\Program Files\PostgreSQL\8.4\bin\psql" -p 5432 -U postgres -d template_postgis14 -f "C:\Program Files\PostgreSQL\8.4\share\contrib\postgis\postgis_comments.sql"
7) Now you can connect via pgAdmin III and create a new postgis 14 database and set template to template_postgis14



--NOTE FOR UPGRADERS --
If you are upgrading from PostGIS 1.4b, 1.4Rc1, or 1.4RC2 -- the scripts didn't change -- so its safe enough to replace your postgis-1.4.dll with the one in this install
and just run this command to get rid of the 
annoying upgrade procs message

CREATE OR REPLACE FUNCTION postgis_scripts_installed() RETURNS text
	AS 'SELECT ''1.4.0''::text AS version' 
	LANGUAGE 'sql' IMMUTABLE;

If you are upgrading from 1.3 to 1.4 and also moving from PostgreSQL 8.+ to 8.4, there are two approaches you can use.  
-- For older versions - you can only use approach 2

-Approach 1 -- Upgrade the existing PostGIS 1.3 database in place (in your PostgreSQL 8.2/8.3 install)
1) Just run the postgis_upgrade.sql file in the postgis folder of this zip
2) Then backup this new database (or use PgMigrator (not tested) to migrate to 8.4)


-- Approach 2 -- this approach you should be able to use if you are upgrading a 1.3 or an older install
1) Backup your existing database with PgAmin III (make sure not to choose drop objects before restore) 
2) Create a new postgis database in PostgreSQL 8.4 using the above instructions
3) Restore your backup into this new postgis db (again you can use PgAdmin III for this)
