Yes I did: $ /opt/postgresql/bin/createlang plpgsql testspatialdb createlang: language "plpgsql" is already installed in database "testspatialdb"
I'm actually following the procedure from the PostGIS documentation. Chris Hermansen wrote: > > Aside from compiling PostGIS, have you spatially enabled your database, > as per > > http://www.postgis.org/documentation/manual-1.3/ch02.html#PGInstall > > ie > > # createlang plpgsql [yourdatabase] > # psql -d [yourdatabase] -f lwpostgis.sql > # psql -d [yourdatabase] -f spatial_ref_sys.sql > > eroussel wrote: >> I currently have a problem with PostGIS 1.3.3 on Solaris 10. >> >> PostGIS compiled without problems, however, when I try to run: >> # /opt/postgresql/bin/psql -d testspatialdb -f >> /opt/postgresql/share/lwpostgis.sql >> >> I get this: >> psql:/opt/postgresql/share/lwpostgis.sql:53: NOTICE: type "histogram2d" >> is >> not yet defined >> DETAIL: Creating a shell type definition. >> psql:/opt/postgresql/share/lwpostgis.sql:53: ERROR: could not load >> library >> "/opt/postgresql/lib/liblwgeom.so": ld.so.1: postgres: fatal: libc.so.6: >> open failed: No such file or directory >> >> Looking at liblwgeom.so I get this: >> $ ldd liblwgeom.so >> libgeos_c.so.1 => /opt/geos/lib/libgeos_c.so.1 >> libproj.so.0 => /opt/proj/lib/libproj.so.0 >> libc.so.6 => (file not found) >> libgeos-3.0.0.so => /opt/geos/lib/libgeos-3.0.0.so >> libstdc++.so.6 => /usr/sfw/lib/libstdc++.so.6 >> libm.so.2 => /lib/libm.so.2 >> libgcc_s.so.1 => /usr/sfw/lib/libgcc_s.so.1 >> libc.so.1 => /lib/libc.so.1 >> >> Obviously libc.so.6 is missing. On Solaris 10 however libc.so.1 is >> available >> under /lib. Is there a secret "configure" switch to have PostGIS call >> libc.so.1 instead of libc.so.6 under Solaris 10? >> >> Thanks in advance. >> > > > -- > Regards, > > Chris Hermansen mailto:[EMAIL PROTECTED] > tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.232.0644 > Timberline Natural Resource Group · http://www.timberline.ca > 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5 > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://www.nabble.com/PostGIS-1.3.3-on-Solaris-10-tp19963091p19963410.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
