Problem in ./psql -f /usr/local/pgsql/share/lwpostgis.sql -d database 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 -d database name
Date: 2006-06-02 05:13:09
Message-ID: 1149225189.7214.4.camel@savarkar
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-ports by date

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