--Creating a template postgis database or new postgis database  --
1) Copy the contents of this folder into C:\Program Files\PostgreSQL\8.3 or where you have installed
2) "C:\Program Files\PostgreSQL\8.3\bin\psql" -p 5432 -U postgres -c "CREATE DATABASE template_postgis14"
3) "C:\Program Files\PostgreSQL\8.3\bin\psql" -p 5432 -U postgres -d template_postgis14 -c "CREATE LANGUAGE plpgsql"
4) "C:\Program Files\PostgreSQL\8.3\bin\psql" -p 5432 -U postgres -d template_postgis14 -f "C:\Program Files\PostgreSQL\8.3\share\contrib\postgis\postgis.sql"
5) "C:\Program Files\PostgreSQL\8.3\bin\psql" -p 5432 -U postgres -d template_postgis14 -f "C:\Program Files\PostgreSQL\8.3\share\contrib\postgis\spatial_ref_sys.sql"
6) "C:\Program Files\PostgreSQL\8.3\bin\psql" -p 5432 -U postgres -d template_postgis14 -f "C:\Program Files\PostgreSQL\8.3\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;

PostGIS 1.4 and 1.3 can coexist on the same PostgreSQL install, but if you wish to maintain both
, make sure to copy the .sql scripts into separate folders so as to not get confused


The only caveat is that there can only be one proj and one geos install, so when you copy the above, you 
will automatically upgrade your proj to 4.6.1 and your GEOS to 3.1.1 (which in general is not a bad thing)

If you are upgrading from 1.3 to 1.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
1) Just run the postgis_upgrade.sql file in the postgis folder of this zip


-- 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 using the above instructions
3) Restore your backup into this new postgis db (again you can use PgAdmin III for this)
