[PORTS] Problem in ./psql -f /usr/local/pgsql/share/lwpostgis.sql -d database name

hemant <[email protected]> Fri, 02 Jun 2006 10:43:09 +0530
Newsgroups gmane.comp.db.postgresql.ports
Message-ID <1149225189.7214.4.camel@savarkar>
Hi,
   I have installes POstgresql-8.1.3 and POstgis-1.1.2.
   Create Database and Now run POstGIs as follws:
  
   run POstgressql by 
   su - postgres
   .....
   ./psql -f /usr/local/pgsql/share/lwpostgis.sql -d DataBAseName

   Then problem occur as follows: -

BEGIN
psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:44: NOTICE:  type
"histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:44: ERROR:  could not
load library "/usr/local/pgsql/lib/liblwgeom.so.1.1": libgeos_c.so.1:
cannot open shared object file: No such file or directory
psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:49: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
...........


Please resolve it ASAP




-- 
Hemant S. Moharir,
RelationWare,
Pune.
+91-9422372835


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match