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

[Mark Cave-Ayland]

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
> > 
> > 
> > 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.
> > 
> > 
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> >
> http://postgis.refractions.net/mailman/listinfo/postgis-users 
> 
> 
> 	
> 
> 	
> 		
> 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 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>