[postgis-users] Postgresql installation problems

[Swaminathan, Gayathri]

Hi Mark:
I downloaded the binary from the url in the email below. I am sucessfully able to configure and run postgresql but when I try to connect through PGAdmin I seem to get pg_tablespace not found error..

Another thing is am not able to run any SQL statements such as CREATE DATABASE etc., with the supplied psql.exe

Any help or pointers will be very useful
Gayathri

> -----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.