[postgis-users] Win32 PostgreSQL 7.5/PostGIS snapshot availablefor developers

[David TECHER]

Ok...Mark

I only want now to tell you about twos freewares
envinst and pgsqvwin32.exe that you can download from 

http://www13.brinkster.com/vincenzog/isxart.asp?idart=38

and

http://www.unm.edu/%7Eefesar/pgsvc/index.html

Envinst.exe will help you to setup all your variable
environment PGHOST,PGPORT,PGHOME,PGDATA and your PATH

I just suggest you to write a batch file with

envinst -addval -name=PATH
-value=C:\pgsql75win\bin;C:\pgsql75win\lib; -prepend
envinst -setvar -name=PGDATA -value=C:\pgsql75win\data
envinst -setvar -name=PGHOME -value=C:\pgsql75win
envinst -setvar -name=PGPORT -value=5432
envinst -setvar -name=PGHOST -value=localhost



Pgsvcwin32 will help you to use postgresql as service
in XP, 2000 and WIndows NT

Download pgsvcwin32 and write a batch file with

pgsvcwin32_install
"C:\pgsql75win\psqlwin_svc\pgsvcwin32.exe"
"C:\pgsql75win\bin\postmaster.exe -D
C:\pgsql75win\data -i" "C:\pgsql75win\log\psqlwin.log"
"C:\pgsql75win\data\postmaster.pid" 


 --- Mark Cave-Ayland <m.cave-ayland at webbased.co.uk> a
écrit : > Hi David,
> 
> I remember that when I compiled PostGIS that I had
> to remove a couple of
> the debugging functions so that the PostGIS DLL
> would compile; however
> these are still included in the SQL file by default.
> I'd obviously done
> a 'make install' since loading the functions into my
> test database.
> 
> The quick answer is to delete lines 571-580 from the
> supplied
> postgis.sql and everything should then be fine. I'll
> try and update the
> ZIP file with this change later on today.
> 
> 
> Many thanks for trying and spotting this!
> 
> Mark.
> 
> ---
> 
> Mark Cave-Ayland
> Webbased Ltd.
> Tamar Science Park
> Derriford
> Plymouth
> PL6 8BX
> England
> 
> Tel: +44 (0)1752 764445
> Fax: +44 (0)1752 764446
> 
> 
> This email and any attachments are confidential to
> the intended
> recipient and may also be privileged. If you are not
> the intended
> recipient please delete it from your system and
> notify the sender. You
> should not copy it or use it for any purpose nor
> disclose or distribute
> its contents to any other person.
> 
> > -----Original Message-----
> > From:
> postgis-users-bounces at postgis.refractions.net 
> >
>
[mailto:postgis-users-bounces at postgis.refractions.net]
> On 
> > Behalf Of David TECHER
> > Sent: 26 May 2004 12:04
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] Win32 PostgreSQL
> 7.5/PostGIS 
> > snapshot availablefor developers
> > 
> > 
> > Hi Mark
> > 
> > I tried your distribution...thanks for it
> > 
> > I tried C:\pgsql75win
> > 
> > set PGDATA = C:\pgsql75win\data
> > set PGHOME = C:\pgsql75win
> > set PGHOST = localhost
> > set PATH =
> C:\pgsql75win\bin;C:\pgsql75win\lib;%PATH%
> > initdb -L C:/pgsql75win/share
> > 
> > I replaced 
> >           $libdir 
> > 
> > by 
> > 
> >             C:/pgsql75win/lib 
> > 
> > in  C:\pgsql75win\share\postgis.sql
> > 
> > I made a base test
> > 
> > posmaster
> > 
> > I opened an other DOS prompt and I do 
> > 
> > cd C:\pgsql75win\share
> > createdb test
> > createlang plpgsql test
> > psql -d test -f postgis.sql
> > 
> > I noticed that there is a error on the file
> > postgis.sql
> > 
> > It is
> > 
> > psql:postgistest.sql:574: ERROR:  could not find
> > function "mem_size" in file "C:
> > /pgsql75win/lib/libpostgis.dll"
> > psql:postgistest.sql:580: ERROR:  could not find
> > function "summary" in file "C:/
> > pgsql75win/lib/libpostgis.dll"
> > 
> > 
> >  --- Mark Cave-Ayland
> <m.cave-ayland at webbased.co.uk> a
> > écrit : > Hi guys,
> > > 
> > > After following all the traffic on this list
> about
> > > Win32 PostgreSQL, I
> > > thought it would be a useful exercise to try and
> > > build it myself. The
> > > result is that I now have a working snapshot
> which I
> > > have decided to
> > > upload to the web to allow developers to
> determine
> > > how their spatial
> > > applications may perform under Win32. The
> download
> > > can be found at
> > > http://www.webbased.co.uk/mca/pgsql75win.zip and
> is
> > > roughly 14Mb in
> > > size. The installation includes PostGIS CVS,
> PROJ
> > > 4.4.8 and GEOS CVS
> > > taken from the end of last week.
> > > 
> > > Installation is simple: extract the ZIP file in
> C:\
> > > and all the paths
> > > should be correct. The only thing to watch out
> for
> > > is to make sure you
> > > don't have another copy of libpq.dll in \WINDOWS
> or 
> > > \WINDOWS\SYSTEM[32]. There are several scripts
> included to ease 
> > > setting things up.
> > > 
> > > 	- pgstart.bat starts the PostgreSQL server
> > > 	- env.bat starts a command line with the
> correct
> > > path so any of
> > > the
> > > 	postgres executables can be run, e.g. psql.exe
> > > 	- initdb.bat performs an initdb in the
> > > C:\pgsql75win\data
> > > subdirectory
> > > 
> > > Note that this is just a test installation we
> are
> > > using to evaluate
> > > PostGIS performance under Win32 and as such it
> has
> > > no warranties
> > > whatsoever. Win32 PostgreSQL development is
> still
> > > very much a work in
> > > progress. Please treat it like a new toy, don't
> use
> > > it in production,
> > > and there is a chance you may lose some data.
> > > However, any feedback is
> > > gratefully received and it is hoped that it will
> > > allow many of the
> > > Win32/PostGIS issues to be resolved before the
> final
> > > 7.5 release.
> > > 
> > > Finally a big thank you to Romi Hardiyanto and
> David
> > > Techer, without
> > > whom this would have been a much harder job. I
> can
> > > also verify that
> > > Romi's patches work satisfactorily for other
> > > developers who wish to try
> > > a similar exercise.
> > > 
> > > 
> > > Cheers,
> > > 
> > > Mark.
> > > 
> > > ---
> > > 
> > > Mark Cave-Ayland
> > > Webbased Ltd.
> > > Tamar Science Park
> > > Derriford
> > > Plymouth
> > > PL6 8BX
> > > England
> > > 
> > > Tel: +44 (0)1752 764445
> > > Fax: +44 (0)1752 764446
> 
=== message truncated === 


	

	
		
Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout ! 
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Dialoguez en direct avec vos amis grâce à Yahoo! Messenger !Téléchargez Yahoo! Messenger sur http://fr.messenger.yahoo.com