[postgis-users] PostgreSQL 8.0 Beta Installer for Windows

[TECHER Jean David]

Hi Steffen

	I made a distribution from the cvs snapshot that pginstaller uses

I used GEOS 1.0.0, PROJ 4.4.7, AsSVG() function

You can download it at

	http://www.01map.com/download/postgres75_win32_postgis_082.zip (WITH
POSTGRESQL)

I attached the READ_ME.txt file to this mail

Or if you want only binairies for  PostGIS, GEOS, PROJ and AsSVG without
PostgreSQL

you can try

	http://www.01map.com/download/postgis-082_geos-100_proj-447_assvg.zip
(WITHOUT POSTGRESQL)

TECHER JEAN DAVID
- Responsable Informatique 01MAP -
e-mail:davidtecher at yahoo.fr
Tel: 06 85 37 36 75
Site PostGIS: http://techer.pascal.free.fr/postgis/index.htm

-------------- next part --------------


	POSTGRESQL 7.5 AND POSTGIS 0.8.2 WIN32

	TECHER Jean David

	e-mail: davidtecher at 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