[postgis-users] Win32 PostgreSQL 7.5/PostGIS snapshotavailablefor developers
Mark Cave-Ayland
m.cave-ayland at webbased.co.uk
Thu May 27 00:25:24 PDT 2004
Hi David,
Thanks for your links on this. It's really just a personal preference to
keep things in a separate environment as I hate clogging up the Windows
PATH variable as so many programs try to do. I had thought about running
PostgreSQL as a service but thought that if there are still some bugs
then it would be harder to detect if the postmaster had unexpectedly
terminated. I shall definitely consider this as an option later though!
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.
> -----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 15:25
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] Win32 PostgreSQL 7.5/PostGIS
> snapshotavailablefor developers
>
>
> 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
> _______________________________________________
> 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