[postgis-users] FW: postgis.sql

[Anthony Agoro (C)]

Hello guys,

Many thanks for your help. 

I managed to locate the libpostgis.so.0.7 in   /usr/local/pgsql/postgresql-7.3.4/contrib/postgis-0.7.3

I modified the postgis.sql file manually to point to my libpostgis and ran make install again from my postgis directory.

Please see the log files


Regards,

Anthony



-----Original Message-----
From: Paul Ramsey [mailto:pramsey at refractions.net]
Sent: 15 October 2003 18:37
To: Anthony Agoro (C)
Subject: Re: [postgis-users] FW: postgis.sql


Run 'make install' in your postgis directory, then try again.
Paul

Anthony Agoro (C) wrote:

> Thanks guys,
> As you gathered I'm rather new to the forum, Postgres and Postgis.
> I reinstalled PostGIS and found Postgis.sql in the following directory:
> 
> /usr/local/pgsql/postgresql-7.3.4/contrib/postgis-0.7.3/postgis.sql
> 
> 
> I used the following command to load the PostGIS object and function definitions into the database 
> 
> /usr/local/pgsql/bin/psql -d osmm  -f /usr/local/pgsql/postgresql-7.3.4/contrib/postgis-0.7.3/postgis.sql
> 
> I got the following message:
> 
> 	MESSAGE
> .............................
> 
> plpgsql is installed
> (1 row)
> 
> CREATE TABLE / PRIMARY KEY will create implicit index 's patial_ref_sys_pkey' for table 'spatial_ref_sys'
> CREATE TABLE / PRIMARY KEY will create implicit index 's c_pk' for table 'geometry_columns'
> CREATE TABLE
> CREATE FUNCTION
> 
> 
> Then 
> 
> psql errors
> 
> such as :218: NOTICE: ProcedureCreate: type box3d is not yet defined
> 	  :218 ERROR stat failed on file '/usr/lib/contrib/libostgis.so.0.7' : No such file or directory
> alot of aborted error
> 
> 
> Platform : redhat 7.3  (on x86 (Intel))
> Postgres:  Postgresql-7.3.4.tar.gz
> PostGis:   0.7.3
> 
> I installed postgresql as per the doc:
> 
> # cd [postgresql source tree]/contrib 
> # gzip -d -c	postgis-0.7.tar.gz | tar xvf -
> 
> 
> I installed PostGIS following instruction obtained from PostGIS forum))
> 
> 
>>Move the tar file to the 'contrib' directory of you PostgreSQL support
>>tree, and de-compress it.
>>cd contrib
>>gunzip postgis-0.7.1.tar.gz
>>tar xvf postgis-0.7.1.tar
>>Change directories to the root of the PostgreSQL source tree:
>>$ cd ../..
>>Use the following configure arguments to configure the master makefile
>>correctly, then make, but DON'T make install
>>./configure --enable-multibyte --with-CXX --prefix=/usr
>>--sysconfdir=/etc --docdir=/usr/doc/postgresql-$version
>>make
>>Return to the PostGIS directory, and follow the standard installation
>>instructions:
>>make
>>make install
> 
> 
>   # createlang plpgsql [yourdatabase]
> 
>   # psql -d [yourdatabase] -f	postgis.sql
> 
> 
>  
> Tyler 
> 
> I would love to grab the window solution, we are however trying to deploy on pure open source, thus redhat. Should I not manage to get it going I may have take you up on it, as time is pressing on me.
> 
> 
> 
> It appears that I have a real challenge. I hope I can pick your brains tomorrow morning.
> 
> Many thanks,
> 
> Anthony
> 
> 
> 
> -----Original Message-----
> From: Paul Ramsey [mailto:pramsey at refractions.net]
> Sent: 15 October 2003 17:33
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] FW: postgis.sql
> 
> 
> Anthony,
> Yes, the problem is that you cannot locate your postgis.sql file :)
> You know that
> (a) you really have to compile PostgreSQL from source to build PostGIS
> (b) when you build PostGIS and run 'make install', postgis.sql gets 
> installed in your PostgreSQL install directory, under share/contrib
> (c) you have to build PostGIS from source at this point (unless someone > generously gives you binaries or RPMs)
> Always include lots of info with your questions. Like, for a question of > your sort, knowing what platform you are using, how you installed 
> postgis (did you install postgis), etc, would help people help you. What > we do not know, we cannot use to help you.
> Paul
> 
> Anthony Agoro (C) wrote:
> 
> 
>>>Hi,
>>>
>>>I hope you can help. I installed Postgres7.3.4 and successfully created a database. 
>>>I am trying to  load the PostGIS object and function definitions into my  database by loading the postgis.sql definitions file. 
>>>
>>>logged on as postgres user using the folloing command
>>> # psql -d [yourdatabase] -f postgis.sql	
>>>
>>>I  get the following error:
>>>
>>>postgis.sql:  No such file or directory 
>>>
>>>I did attempt to locate postgis.sql script but was unable to.
>>>
>>>Can any one help?
>>>
>>>Regards,
>>>
> 
> 
> 


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_



This Email and any attachments have been virus checked upon receipt at the Ordnance Survey and is free of all known viruses.



If you have received this email in error, please delete it immediately and notify the sender. 
This email may contain confidential information and if you are not the intended recipient, you must not copy, distribute or rely on it.
As email is not a 100% secure communications medium, you accept that there are risks in communicating by email by doing so. We advise you to check that emails and attachments are virus-free before opening them. No contracts can be entered into on our behalf by email. Opinions expressed in this email are not necessarily endorsed by us unless otherwise specifically stated. We reserve the right to read and monitor any email or attachment entering or leaving our systems without prior notice.
Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgiserror-txt
Type: application/octet-stream
Size: 11060 bytes
Desc: postgiserror-txt
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20031016/d074fbd7/attachment.obj>