[postgis-users] Win32 PostgreSQL 7.5/PostGIS snapshot update

[Mark Cave-Ayland]

> -----Original Message-----
> From: Hisaji ONO [mailto:hi_ono2001 at ybb.ne.jp] 
> Sent: 14 July 2004 17:53
> To: m.cave-ayland at webbased.co.uk
> Cc: PostGIS Users Discussion
> Subject: Re: [postgis-users] Win32 PostgreSQL 7.5/PostGIS 
> snapshot update
> 
> 
> Hi, Mark.
> 
> > Just to let you know I've updated my Win32 snapshot again at 
> > http://www.webbased.co.uk/mca/pgsql75win.zip. The CVS 
> snapshot of GEOS 
> > that I used in the original build was found to have some bugs in it 
> > which could cause out of memory errors and/or the backend 
> to die when 
> > using certain GEOS functions.
> 
>  I will try your Win32 PostgreSQL 7.5/PostGIS.
> 
>  However I've got following errors on Windows XP's cmd.exe.
> 
> psql -d columbusdb -f share\contrib\postgis.sql
> 
> psql:share\contrib\postgis.sql:38: NOTICE:  type 
> "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:share\contrib\postgis.sql:38: ERROR:  could not access file
> "libpostgis.dll": No such file or directory
> 
>  Could you give me any suggestion?
> 
>  Regards.


Hi Hisaji,

It sounds as if the PATH environment variable is not being set
somewhere, so PostgreSQL cannot find libpostgis.dll. Firstly, you must
make sure that the zip file is extracted in C:\ so that the snapshot
extracts into C:\pgsql75win. At the time I made the snapshot, it was
necessary to specify the PATH at compile time.

If you then look inside the C:\pgsql75win directory you will see some
batch files which set up PATH correctly before executing the relevant
command - you need to double-click these in the following order:

		initdb.bat - to initdb the database cluster
		pgstart.bat	- to run the database (leave this one
running)
		env.bat - sets up cmd.exe with the correct PATH to run
psql

If you look at these files, you should be able to see how the paths need
to be set up in order for the snapshot to run correctly. Please let me
know if this doesn't solve the problem for you.


Kind regards,

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.