Skip site navigation (1) Skip section navigation (2)

Problem in ./psql -f /usr/local/pgsql/share/lwpostgis.sql -ddatabase name

From: hemant <hemant(at)relationware(dot)info>
To: pgsql-ports(at)postgresql(dot)org
Subject: Problem in ./psql -f /usr/local/pgsql/share/lwpostgis.sql -ddatabase name
Date: 2006-06-02 05:13:09
Message-ID: 1149225189.7214.4.camel@savarkar (view raw or flat)
Thread:
Lists: pgsql-ports
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


pgsql-ports by date

Next:From: Match.GrunDate: 2006-06-08 23:22:20
Subject: Horology Test Case Fails with Sun Compiler
Previous:From: Eric MontagueDate: 2006-05-28 20:05:33
Subject: psql: krb5_sendauth: Bad application version was sent (via sendauth) - Windows 2000, MIT Kerberos, PG v 8.1.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group