Re: [postgis-users] "ERROR: could not access file "$libdir/postgis-1.5": No such file or directory"
2010/3/12 Gissur Þórhallsson : > Hi, > I'm setting up postgis on a Ubuntu 8.0.4 LTS Server that I'm setting up. > I decided that it would be best for me build Postgis 1.5 from source so > that's what I did - starting with Postgres 8.4.2 from trunk through GEOS and > PROJ and everything went fine. I've now also compiled postgis 1.5 and was > preparing to run new_postgis_restore.pl to restore my database (migrated > from windows postgresql 8.2). > When I try to run psql postgis.sql on the database I intend to restore into > (as stipulated inside new_postgis_restore.pl) I get the > following: http://postgis.pastebin.com/TCC0yk35 > Running $ldd /absolute/path/to/postgis-1.5.so returns > this: http://postgis.pastebin.com/yERz1HeY (which looks normal enough) > > For further reference I enclose my pg_config > output: http://postgis.pastebin.com/6u3zfTyc > LIBDIR is set to /usr/lib in there, and my postgis-1.5.so is located > at /usr/lib/postgresql/8.4/lib/ postgis-1.5.so > Does anybody have any ideas? > Kind regards from Iceland, > Gissur Þórhallsson > > Loftmyndir ehf. > Laugavegur 13 > IS 101 Reykjavík - Iceland > sími (tel): (+354) 540 2500 > tölvupóstur (email): gis...@loftmyndir.is > Hi, Try adding /usr/lib/postgresql/8.4/lib/postgis-1.5.so to /etc/ld.so.conf and then executing "sudo ldconfig" Hope this helps... Best regards, Jorge > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS manager: importing multilinestring
On Fri, Mar 12, 2010 at 10:52:30AM -0800, Paul Ramsey wrote: > That appears to have fixed things on OS/X. Can you port back into 1.5 branch? Done: http://trac.osgeo.org/postgis/changeset/5431 --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS manager: importing multilinestring
That appears to have fixed things on OS/X. Can you port back into 1.5 branch? P On Fri, Mar 12, 2010 at 10:49 AM, Sandro Santilli(strk) wrote: > I found memory errors in the loader, and fixed in trunk > with commit 5430. > > Please test again with the new version. > > --strk; > > () Free GIS & Flash consultant/developer > /\ http://strk.keybit.net/services.html > > On Fri, Mar 12, 2010 at 05:35:54PM +0100, Sandro Santilli(strk) wrote: >> On Fri, Mar 12, 2010 at 05:30:13PM +0100, Paolo Cavallini wrote: >> > Hi all. >> > While importing a shapefile into postgis, I see that the command contains >> > 2 "u" that >> > I do not understand: >> [...] >> > I can make the shp available for testing if necessary. It has a wrong >> > record. >> >> Feel free to send the shapefile to me. >> Thanks for finding a new bug! > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS manager: importing multilinestring
I found memory errors in the loader, and fixed in trunk with commit 5430. Please test again with the new version. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html On Fri, Mar 12, 2010 at 05:35:54PM +0100, Sandro Santilli(strk) wrote: > On Fri, Mar 12, 2010 at 05:30:13PM +0100, Paolo Cavallini wrote: > > Hi all. > > While importing a shapefile into postgis, I see that the command contains 2 > > "u" that > > I do not understand: > [...] > > I can make the shp available for testing if necessary. It has a wrong > > record. > > Feel free to send the shapefile to me. > Thanks for finding a new bug! ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS manager: importing multilinestring
On Fri, Mar 12, 2010 at 05:30:13PM +0100, Paolo Cavallini wrote: > Hi all. > While importing a shapefile into postgis, I see that the command contains 2 > "u" that > I do not understand: [...] > I can make the shp available for testing if necessary. It has a wrong record. Feel free to send the shapefile to me. Thanks for finding a new bug! --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS manager: importing multilinestring
Paolo, Put the shapefile somewhere I can pull it and I'll see if I can replicate. You haven't specified your PostGIS version, which is important. P On Fri, Mar 12, 2010 at 8:30 AM, Paolo Cavallini wrote: > Hi all. > While importing a shapefile into postgis, I see that the command contains 2 > "u" that > I do not understand: > > ['shp2pgsql', '-c', '-s', '3003', > u'/home/paolo/Desktop/Dati_corso_QGIS/strade_regionali.shp', u'public.strade'] > > Furthermore, importing a linear vector throws an error: > > Something's wrong: > ['Shapefile type: Arc\n', 'Postgis type: MULTILINESTRING[2]\n'] > > If I select "Create single-part geometries instead of multi-part", I get > instead: > > syntax error at or near "' '" > RIGA 2: ...','0','0','0','0.0','0','0',NULL,NULL,NULL,NULL,NULL' ') > > I suspect this is due to some special character in the dbf; the same command > crashes > shp2pgsql from the command line: > > ... > INSERT INTO "public"."strade" > ("fnode_","tnode_","lpoly_","rpoly_","length","statali_","statali_id","codice","nome","tipo","codifica",the_geom) > VALUES ('0','0','0','0','0.0','0','0',NULL,NULL,NULL,NULL,NULL�9 ��9 > '); > Segmentation fault > > On another machine, I get a more explicit error: > > Something's wrong: > ['Shapefile type: Arc\n', 'Postgis type: MULTILINESTRING[2]\n', '*** glibc > detected > *** shp2pgsql: free(): invalid pointer: 0x7fce65fc7e60 ***\n', '=== > Backtrace: =\n', '/lib/libc.so.6[0x7fce65ce8d16]\n', > '/lib/libc.so.6(cfree+0x6c)[0x7fce65ced9bc]\n', 'shp2pgsql[0x40ab82]\n', > 'shp2pgsql[0x40b77e]\n', > '/lib/libc.so.6(__libc_start_main+0xfd)[0x7fce65c96abd]\n', > 'shp2pgsql[0x402969]\n', '=== Memory map: \n', '0040-00436000 > r-xp > 08:01 1190782 /usr/bin/shp2pgsql\n', > '00635000-00636000 rw-p 00035000 08:01 1190782 > /usr/bin/shp2pgsql\n', '01767000-01788000 rw-p 00:00 0 > [heap]\n', '7fce6000-7fce60021000 rw-p 00:00 0 \n', > '7fce60021000-7fce6400 ---p 00:00 0 \n', > '7fce655dd000-7fce655f3000 r-xp > 08:01 1042654 /lib/libgcc_s.so.1\n', > '7fce655f3000-7fce657f2000 ---p 00016000 08:01 1042654 > /lib/libgcc_s.so.1\n', '7fce657f2000-7fce657f3000 rw-p 00015000 08:01 1042654 > /lib/libgcc_s.so.1\n', '7fce657f3000-7fce657f5000 r-xp > 08:01 > 100246 /usr/lib/gconv/CP1252.so\n', > '7fce657f5000-7fce659f4000 > ---p 2000 08:01 100246 /usr/lib/gconv/CP1252.so\n', > '7fce659f4000-7fce659f5000 r--p 1000 08:01 100246 > /usr/lib/gconv/CP1252.so\n', '7fce659f5000-7fce659f6000 rw-p 2000 08:01 > 100246 > /usr/lib/gconv/CP1252.so\n', '7fce659f6000-7fce65a77000 r-xp > 08:01 1043745 /lib/libm-2.10.2.so\n', > '7fce65a77000-7fce65c76000 ---p 00081000 08:01 1043745 > /lib/libm-2.10.2.so\n', '7fce65c76000-7fce65c77000 r--p 0008 08:01 1043745 > /lib/libm-2.10.2.so\n', '7fce65c77000-7fce65c78000 rw-p 00081000 > 08:01 > 1043745 /lib/libm-2.10.2.so\n', '7fce65c78000-7fce65dc2000 > r-xp > 08:01 1043738 /lib/libc-2.10.2.so\n', > '7fce65dc2000-7fce65fc2000 ---p 0014a000 08:01 1043738 > /lib/libc-2.10.2.so\n', '7fce65fc2000-7fce65fc6000 r--p 0014a000 08:01 1043738 > /lib/libc-2.10.2.so\n', '7fce65fc6000-7fce65fc7000 rw-p 0014e000 > 08:01 > 1043738 /lib/libc-2.10.2.so\n', '7fce65fc7000-7fce65fcc000 > rw-p > 00:00 0 \n', '7fce65fcc000-7fce65fe9000 r-xp 08:01 1043115 > /lib/ld-2.10.2.so\n', '7fce661ab000-7fce661ac000 rw-p > 00:00 0 > \n', '7fce661ac000-7fce661b3000 r--s 08:01 98890 > /usr/lib/gconv/gconv-modules.cache\n', '7fce661b3000-7fce661d5000 rw-p > 00:00 > 0 \n', '7fce661d5000-7fce661e8000 rw-p 00:00 0 \n', > '7fce661e8000-7fce661e9000 r--p 0001c000 08:01 1043115 > /lib/ld-2.10.2.so\n', '7fce661e9000-7fce661ea000 rw-p 0001d000 08:01 1043115 > /lib/ld-2.10.2.so\n', '7fffe2c34000-7fffe2c49000 rw-p > 00:00 0 > [stack]\n', '7fffe2dd7000-7fffe2dd8000 r-xp > 00:00 0 > [vdso]\n', 'ff60-ff601000 r-xp > > 00:00 0 [vsyscall]\n'] > > So it must be a PostGIS problem. > I can make the shp available for testing if necessary. It has a wrong record. > > All the best. > -- > Paolo Cavallini: http://www.faunalia.it/pc > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS manager: importing multilinestring
Hi all. While importing a shapefile into postgis, I see that the command contains 2 "u" that I do not understand: ['shp2pgsql', '-c', '-s', '3003', u'/home/paolo/Desktop/Dati_corso_QGIS/strade_regionali.shp', u'public.strade'] Furthermore, importing a linear vector throws an error: Something's wrong: ['Shapefile type: Arc\n', 'Postgis type: MULTILINESTRING[2]\n'] If I select "Create single-part geometries instead of multi-part", I get instead: syntax error at or near "''" RIGA 2: ...','0','0','0','0.0','0','0',NULL,NULL,NULL,NULL,NULL'') I suspect this is due to some special character in the dbf; the same command crashes shp2pgsql from the command line: ... INSERT INTO "public"."strade" ("fnode_","tnode_","lpoly_","rpoly_","length","statali_","statali_id","codice","nome","tipo","codifica",the_geom) VALUES ('0','0','0','0','0.0','0','0',NULL,NULL,NULL,NULL,NULL�9 ��9 '); Segmentation fault On another machine, I get a more explicit error: Something's wrong: ['Shapefile type: Arc\n', 'Postgis type: MULTILINESTRING[2]\n', '*** glibc detected *** shp2pgsql: free(): invalid pointer: 0x7fce65fc7e60 ***\n', '=== Backtrace: =\n', '/lib/libc.so.6[0x7fce65ce8d16]\n', '/lib/libc.so.6(cfree+0x6c)[0x7fce65ced9bc]\n', 'shp2pgsql[0x40ab82]\n', 'shp2pgsql[0x40b77e]\n', '/lib/libc.so.6(__libc_start_main+0xfd)[0x7fce65c96abd]\n', 'shp2pgsql[0x402969]\n', '=== Memory map: \n', '0040-00436000 r-xp 08:01 1190782/usr/bin/shp2pgsql\n', '00635000-00636000 rw-p 00035000 08:01 1190782 /usr/bin/shp2pgsql\n', '01767000-01788000 rw-p 00:00 0 [heap]\n', '7fce6000-7fce60021000 rw-p 00:00 0 \n', '7fce60021000-7fce6400 ---p 00:00 0 \n', '7fce655dd000-7fce655f3000 r-xp 08:01 1042654/lib/libgcc_s.so.1\n', '7fce655f3000-7fce657f2000 ---p 00016000 08:01 1042654 /lib/libgcc_s.so.1\n', '7fce657f2000-7fce657f3000 rw-p 00015000 08:01 1042654 /lib/libgcc_s.so.1\n', '7fce657f3000-7fce657f5000 r-xp 08:01 100246 /usr/lib/gconv/CP1252.so\n', '7fce657f5000-7fce659f4000 ---p 2000 08:01 100246 /usr/lib/gconv/CP1252.so\n', '7fce659f4000-7fce659f5000 r--p 1000 08:01 100246 /usr/lib/gconv/CP1252.so\n', '7fce659f5000-7fce659f6000 rw-p 2000 08:01 100246 /usr/lib/gconv/CP1252.so\n', '7fce659f6000-7fce65a77000 r-xp 08:01 1043745/lib/libm-2.10.2.so\n', '7fce65a77000-7fce65c76000 ---p 00081000 08:01 1043745 /lib/libm-2.10.2.so\n', '7fce65c76000-7fce65c77000 r--p 0008 08:01 1043745 /lib/libm-2.10.2.so\n', '7fce65c77000-7fce65c78000 rw-p 00081000 08:01 1043745/lib/libm-2.10.2.so\n', '7fce65c78000-7fce65dc2000 r-xp 08:01 1043738/lib/libc-2.10.2.so\n', '7fce65dc2000-7fce65fc2000 ---p 0014a000 08:01 1043738 /lib/libc-2.10.2.so\n', '7fce65fc2000-7fce65fc6000 r--p 0014a000 08:01 1043738 /lib/libc-2.10.2.so\n', '7fce65fc6000-7fce65fc7000 rw-p 0014e000 08:01 1043738/lib/libc-2.10.2.so\n', '7fce65fc7000-7fce65fcc000 rw-p 00:00 0 \n', '7fce65fcc000-7fce65fe9000 r-xp 08:01 1043115 /lib/ld-2.10.2.so\n', '7fce661ab000-7fce661ac000 rw-p 00:00 0 \n', '7fce661ac000-7fce661b3000 r--s 08:01 98890 /usr/lib/gconv/gconv-modules.cache\n', '7fce661b3000-7fce661d5000 rw-p 00:00 0 \n', '7fce661d5000-7fce661e8000 rw-p 00:00 0 \n', '7fce661e8000-7fce661e9000 r--p 0001c000 08:01 1043115 /lib/ld-2.10.2.so\n', '7fce661e9000-7fce661ea000 rw-p 0001d000 08:01 1043115 /lib/ld-2.10.2.so\n', '7fffe2c34000-7fffe2c49000 rw-p 00:00 0 [stack]\n', '7fffe2dd7000-7fffe2dd8000 r-xp 00:00 0 [vdso]\n', 'ff60-ff601000 r-xp 00:00 0 [vsyscall]\n'] So it must be a PostGIS problem. I can make the shp available for testing if necessary. It has a wrong record. All the best. -- Paolo Cavallini: http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] "ERROR: could not access file "$libdir/postgis-1.5": No such file or directory"
Hi, I'm setting up postgis on a Ubuntu 8.0.4 LTS Server that I'm setting up. I decided that it would be best for me build Postgis 1.5 from source so that's what I did - starting with Postgres 8.4.2 from trunk through GEOS and PROJ and everything went fine. I've now also compiled postgis 1.5 and was preparing to run new_postgis_restore.pl to restore my database (migrated from windows postgresql 8.2). When I try to run psql postgis.sql on the database I intend to restore into (as stipulated inside new_postgis_restore.pl) I get the following: http://postgis.pastebin.com/TCC0yk35 Running $ldd /absolute/path/to/postgis-1.5.so returns this: http://postgis.pastebin.com/yERz1HeY (which looks normal enough) For further reference I enclose my pg_config output: http://postgis.pastebin.com/6u3zfTyc LIBDIR is set to /usr/lib in there, and my postgis-1.5.so is located at /usr/lib/postgresql/8.4/lib/ postgis-1.5.so Does anybody have any ideas? Kind regards from Iceland, Gissur Þórhallsson Loftmyndir ehf. Laugavegur 13 IS 101 Reykjavík - Iceland sími (tel): (+354) 540 2500 tölvupóstur (email): gis...@loftmyndir.is ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Make install failure in PostGIS-1.5.1
Sachin Srivastava wrote: Hi all, I am building postgis-1.5.1 with (proj 4.7.0, geos-3.2.0 and pg9.0alpha4) on linux (centos5 32 bit). make is successful, however in make install i am getting this error: /bin/sh /home/sachin/pgsql/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -d '/home/sachin/pgsql/lib/postgresql' '/home/sachin/pgsql/share/postgresql/contrib/postgis-1.5' make[1]: /home/sachin/pgsql/share/postgresql/contrib/postgis-1.5: No such file or directory make[1]: *** [installdirs] Error 1 make: *** [postgis-install] Error 2 Anything i am missing? Hi Sachin, No, it's a bug :( The PGXSOVERRIDE code to support versioned directory installation under older versions of PostgreSQL had not been updated to check for version 9.0 rather than 8.5. I've fixed this in SVN for both 1.5 branch and trunk, but you should be able to apply the attached patch and then re-run "autoconf" to generate a new configure file that should work correctly. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs Index: configure.ac === --- configure.ac (revision 5420) +++ configure.ac (working copy) @@ -329,10 +329,10 @@ fi fi -dnl Temporary hack until minimum PostgreSQL version is 8.5: -dnl If PostgreSQL < 8.5 is detected, trigger the inclusion of the new versioned PGXS targets +dnl Temporary hack until minimum PostgreSQL version is 9.0: +dnl If PostgreSQL < 9.0 is detected, trigger the inclusion of the new versioned PGXS targets PGXSOVERRIDE=0 -if test ! "$PGSQL_MINOR_VERSION" -ge 5; then +if test ! "$PGSQL_MAJOR_VERSION" -ge 9; then PGXSOVERRIDE=1 fi ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Make install failure in PostGIS-1.5.1
Hi all, I am building postgis-1.5.1 with (proj 4.7.0, geos-3.2.0 and pg9.0alpha4) on linux (centos5 32 bit). make is successful, however in make install i am getting this error: /bin/sh /home/sachin/pgsql/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -d '/home/sachin/pgsql/lib/postgresql' '/home/sachin/pgsql/share/postgresql/contrib/postgis-1.5' make[1]: /home/sachin/pgsql/share/postgresql/contrib/postgis-1.5: No such file or directory make[1]: *** [installdirs] Error 1 make: *** [postgis-install] Error 2 Anything i am missing? -- Regards, Sachin Srivastava EnterpriseDB, India www.enterprisedb.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users