[postgis-users] does postgreSQL 8.0 work on xp sp2?

TECHER Jean David davidtecher at yahoo.fr
Mon Nov 22 05:08:48 PST 2004


Hi Paul

Did you try to install PG+PostGIS+Geos+Proj manually???

I don't know if it could be a good and enough test for you but if you want
you can download a binary distribution at:

http://postgresqlwin32.free.fr/download/postgresql800beta3/pg-800b3-win32.zi
p

it was built for pg800b3/postgis-0.9.0/geos2.0..0/proj4.48

if U want:

unizp it at C:\

U will have C:\pg-800b3-win32 with bin, lib and so on

Create environment variables

PGHOME = C:\pg-800b3-win32

PGHOST = localhost

PGDATA = C:\pg-800b3-win32\data

PGPORT = 5432

Add at the beginning of your PATH

PATH = C:\pg-800b3-win32\bin;C:\pg-800b3-win32\lib;

reboot your machine and log in with as user without administrative
privileges and wth a password

>From a  DOS windows prompt do

initdb --encoding=SQL_ASCII -A trust

start/stop PG with

pg_ctl -o -i start/stop

U can create a POstGIS DB by doing

createdb MyDB

createlang plpgsql MyDB

psql -d MyDB -c ''\i c:/pg-800b3-win32/share/postgresql/lwpostgis.sql''

psql -d MyDB -c ''\i
c:/pg-800b3-win32/share/postgresql/spatial_ref_sys.sql''

----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site perso : http://techer.pascal.free.fr/postgis/
site pro: http://www.01map.com/download/
------------------------------------------------------------
----- Original Message -----
From: "Paul Hastings" <paul.hastings at gmail.com>
To: "Frank Rittinger" <gis at schnegg.net>
Cc: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, November 22, 2004 1:50 PM
Subject: Re: [postgis-users] does postgreSQL 8.0 work on xp sp2?


> > I'm running PostgreSQL 8.0 on XP SP2, although I installed SP2 after I
> > installed PostgreSQL, turned the WIndows firewall off and configured
another
> > firewall to let through all requests to PostgreSQL.
>
> well we turned off the firewall & it's still throwing the same error
> during install. any ideas?
>
> thanks.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>





More information about the postgis-users mailing list