[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