[postgis-users] RE: Postgresql installation problems

[Swaminathan, Gayathri]

Hi:

As per Mark's suggestions I unregistered old versions of libpq.dll and did the following:

0) Connected to template1 through psql
1) created my new db using CREATE DATABASE athena LOCATION <path to data>
2) Createlang plpgsql athena
3) Ran the postgis.sql from share/contrib...

Works like a charm!Thanks mark.

And instead of PGAdmin, found this http://www.ems-hitech.com/pgmanager/download.phtml

That works without giving the tablespace error.

Gayathri

> -----Original Message-----
> From: Mark Cave-Ayland [mailto:m.cave-ayland at webbased.co.uk] 
> Sent: Thursday, July 15, 2004 3:30 AM
> To: Swaminathan, Gayathri
> Cc: postgis-users at postgis.refractions.net
> Subject: RE: Postgresql installation problems
> 
> 
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On 
> > Behalf Of Swaminathan, Gayathri
> > Sent: 14 July 2004 22:42
> > To: m.cave-ayland at webbased.co.uk
> > Cc: postgis-users at postgis.refractions.net
> > Subject: [postgis-users] Postgresql installation problems
> > 
> > 
> > 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
> 
> 
> Hi Gayathri,
> 
> The development snapshot was produced before the patch for 
> tablespaces was applied to PostgreSQL 7.5 and so I'm afraid 
> you'll have to use an updated snapshot if you wish to use 
> pgAdmin :(. psql.exe should work fine without any problems though.
> 
> I'm surprised you can't run any commands with the supplied 
> psql.exe; the only thing I can think of is that you already 
> have another libpq.dll on your PC but I can't tell more 
> without knowing the exact errors you are getting. A quick 
> solution for this would be to change the PATH in env.bat so 
> the snapshot directories are listed first, e.g.
> 
> set PATH=C:\pgsql75win\lib;C:\pgsql75win\bin;%PATH%
> 
> If you then run a new version of env.bat, psql.exe should 
> spring into life.
> 
> For the information of people on the list, the reason the 
> snapshot hasn't been updated is that firstly it's purpose was 
> to make sure that we could run PostGIS under Windows/PG7.5 
> when it is released, and secondly there are some very large 
> patches currently being applied (like
> tablespaces) which mean that CVS is tending to be very 
> unstable. The current plan is to update the snapshot when 7.5 
> enters beta when hopefully everything has been stabilised and 
> then it should just be bugfixes. Stay tuned....
> 
> 
> 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.
> 
> 
>