[postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

[patxi.mayol at free.fr]

ok, thanks i have install the 1.3.5 release of postgis and the 8.3.7 release of postgresql ant it's run very well
Thanks a lot
regards
----- Mail Original -----
De: "Regina Obe" <robe.dnd at cityofboston.gov>
À: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Envoyé: Mardi 14 Avril 2009 15h24:20 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: RE: [postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

No that is really ancient.  Where did you get that from though its only in english?

try using this one instead --
http://www.enterprisedb.com/products/pgdownload.do#windows  (the application stack builder will have options to install PostGIS).  So just follow the wizard steps.

Alternatively if you don't have an internet connection on the computer you are installing on and need to download the parts separately then
1) http://www.postgresql.org/ftp/binary/v8.3.7/win32/  (download the zip file (full from here) and run setup.

After step 1

2) Download the postgis-pg83-setup-1.3.5-1.exe from 
http://pgfoundry.org/frs/?group_id=1000256&release_id=1274
(full link is 
http://pgfoundry.org/frs/download.php/2035/postgis-pg83-setup-1.3.5-1.exe
)

and run

3) That should create a template_postgis db

4) Just create your new database using the template_postgis as template using PgAdmin III


Hope that helps,
Regina
 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of patxi.mayol at free.fr
Sent: Tuesday, April 14, 2009 9:10 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

why 8.0.3 ? 
it is the lastest release, no?
I novice in postgresql, so i have downloaded this version : postgresql-8.0.3_postgis-1.0.3_geos-2.1.3_proj-4.4.9-installeur
I have try your command createlang plpgsql SIG, but it say that the language is already install on SIG database !!

----- Mail Original -----
De: "Regina Obe" <robe.dnd at cityofboston.gov>
À: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Envoyé: Mardi 14 Avril 2009 14h28:42 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: RE: [postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

I'm sure there is a very good reason you are using the antiquated 8.0.3.
Just curious what is that  reason?

I'm guessing you forgot to install plpgsql language in your database.  

 createlang plpgsql SIG

then run the .sql files.

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
patxi.mayol at free.fr
Sent: Tuesday, April 14, 2009 8:20 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

Hi,
I have install postgresql 8.0.3 with no problem; 
I want now try to install gis database : i use command on DOS like this
C:\postgresql>createdb SIG --> it is OK
C:\postgresql>psql -d SIG -f D:\postgresql\share\contrib\lwpostgis.sql
--> i have this message : 

psql:D:/postgresql/share/contrib/lwpostgis.sql:48: ERROR:  type
"histogram2d" already exists
psql:D:/postgresql/share/contrib/lwpostgis.sql:65: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:D:/postgresql/share/contrib/lwpostgis.sql:70: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
.....

Have you an idea ?
thanks
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users