POSTGRESQL 7.5 AND POSTGIS 0.8.2 WIN32

	TECHER Jean David

	e-mail: davidtecher@yahoo.fr
	Site: http://techer.pascal.free.fr/postgis

 I. About

 This distribution deals with:

- postgresql CVS snapshot from 09 August 2004

- postgis 0.8.2 

- GEOS 1.0.0

- PROJ 4.4.7

- AsSVG() function done by Klaus Foester (see http://svg.cc)

II. Installation

	Decompress the zip file at C:\. You will have 

- c:\postgres75_win32_postgis_082\bin
- c:\postgres75_win32_postgis_082\lib
-c:\postgres75_win32_postgis_082\include and so on ...

Make the environment variables

PGHOME = c:\postgres75_win32_postgis_082
PGDATA = c:\postgres75_win32_postgis_082\data
PGPORT = 5432
PGHOST = localhost

At the beginning of your PATH add

	c:\postgres75_win32_postgis_082\bin;c:\postgres75_win32_postgis_082\lib;

Then reboot your machine


	i.E PATH = c:\postgres75_win32_postgis_082\bin;c:\postgres75_win32_postgis_082\lib;...

III. Init PostgreSQL

	You must not have Administrative Privileges in order to use PostgreSQL
	So make a user account without privileges (example : postgres)

	See http://www.hagander.net/pgsql/win32snap/ for more infos

	Open a DOS prompt and do

	runas /nonprofile /user:NAMEOFYOURMACHINE\NAMEOFUSER cmd

	(Example: runas /nonprofile /user:MYMACHINE\postgres cmd)

	In the new DOS prompt do:

		initdb

	Then type

		postmaster

       Let this windows openend

IV. Create a PostGIS Database

	In a new postgres' windows type

	createdb yourdatabase
	createlang plpgsql yourdatabase
	psql -d yourdatabase -f c:\postgres75_win32_postgis_082\share\postgis.sql
	psql -d yourdatabase -f c:\postgres75_win32_postgis_082\share\spatial_ref_sys.sql

In order to not typing this lines above, I had a batch file 'creategisdb' in c:\postgres75_win32_postgis_082\bin

	so just type

		creategisdb yourdatabase