#POSTGIS IRC Log - 2009-04-23

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
04:09:13 CIA-34: robe * r4018 /trunk/doc/xsl/postgis_gardentest.sql.xsl: Add ST_BdMPolyFromText to list not to test against 1.3.5 ( crashes 1.3.5 with curves though fine in 1.3.6 )
06:04:38 dassouki: i'm on ubuntu, with postgresql 8.3 installed. I'm getting this error when i "make" http://pastebin.com/d4da95740
06:04:39 sigq: Title: pastebin - collaborative debugging tool ( at pastebin.com )
06:08:29 dassouki: leave #arcgis
06:21:45 dassouki: i'm getting stuck on step 4 http://postgis.refractions.net/documentation/manual-1.3/ch02.html#PGInstall ->with the following output, any ideas http://pastebin.com/d4da95740
06:21:46 sigq: Title: Chapter 2. Installation ( at postgis.refractions.net )
06:33:10 CIA-34: robe * r4019 /trunk/doc/xsl/postgis_gardentest.sql.xsl: exclude curved geometries from 1.3.5 testing
06:58:27 dassouki: i then tried installing the postgresql-8.3-postgis project
06:58:39 dassouki: i can't see postgresql now from either ogrinfo --formats or from pgadmin :(
07:22:11 CIA-34: strk * r2405 /trunk/source/ ( 5 files in 2 dirs ): Apply Single-sided buffer patch, issue #215. UNTESTED.
07:27:18 dassouki: ugh this is frustrating :(
08:46:12 : <_dbd_l12> The ubuntu 8.04 packages for geos are ( unfortunately ) an old verison: 2.3.3 iirc. For a bug in postgis/geos that was fixed in the 3.0.0 release i want to have geos 3.0.0 working with postgis ( from packages )? I compiled geos 3 from source, ran ldconfig and restarted postgresql. This does not pick up the newer geos version. Do i also have to compile postgis from source to do this?
08:51:24 dassouki: _dbd_l12: i'm trying to install 1.3.5 from source, on 8.10 .. my configure sees geos 3.0
08:52:43 : <_dbd_l12> dassouki: yes, geos 3 should be available under the 8.10, but i'm still under 8.04 and i have not found any backports either...
08:52:50 dassouki: ooh k
08:55:03 : <_dbd_l12> migrating a live server to another release can break a lot of stuff ;- ) and 8.04 is a LTS ( 5 years support for server version ) whereas 8.10 is not iirc
08:55:54 dassouki: i agree, i upgraded to 8.10 3 days ago, and can't seem to get postgis installing on the new box :(
09:43:58 : <_dbd_l12> i'm trying deinstalling the 8.04 postgis packages / building geos 3.00 instead of the old 2.3.3 ( in the packages ) and recompiling postgis... i hope this works
09:44:05 : <_dbd_l12> building...
11:14:43 : <_dbd_l12> i recompiled geos and postgis ( trying to combine them with postgresql-8.3 from ubuntu 8.04 repositories ). is this impossible without also rebuilding postgres?
11:15:04 : <_dbd_l12> fails at lwpostgis.sql import
11:15:05 dassouki: _dbd_l12: have u tried mailing the mailing list
11:15:24 : <_dbd_l12> i could try that, thanks
11:15:34 : <_dbd_l12> thought that irc might be faster ; )
11:51:15 : <_dbd_l12> yes it works ! yihaa. the linking/compiling problem was due to a non-obvious geos/postgis version mismatch. Compiling geos 3.1.0 against postgis 1.3.5 went relatively smooth
11:54:24 dassouki: _dbd_l12: maybe that's what's going on wiht me
11:54:52 dassouki: i can't seem to install 1.3.5 either on my new box
11:57:25 : <_dbd_l12> dassouki: what is the specific problem?
11:58:13 nofxx: I need to cast to some type if I provide a hex ewkb to the query?
11:58:36 nofxx: SELECT ST_distance( T6.geom,0101000020E610.....big hash
11:59:08 nofxx: cast the ewkb hex*
12:00:19 dassouki: _dbd_l12: ./configure works, but when i do make i get hte following error
12:00:44 dassouki: http://pastebin.com/m66d27c14
12:00:46 sigq: Title: pastebin - collaborative debugging tool ( at pastebin.com )
12:00:55 nofxx: ahh 'BIGHASH'::geometry
12:01:31 nofxx: well, if I need to cast, is hex ewkb the more "native" let`s say way?
12:02:22 : <_dbd_l12> dassouki: i think you need to install the postgresql headers: try sudo apt-get install postgresql-server-dev-8.3. after that try 'make clean' , then ./configure, make, ...
12:03:00 : <_dbd_l12> what does geos-config --version give?
12:03:32 dassouki: 3 03
12:05:23 : <_dbd_l12> maybe check what ' ldd /usr/lib/postgresql/8.3/lib/liblwgeom.so' give ?
12:07:27 dassouki: i think the headers might've worked one second
12:08:32 dassouki: http://pastebin.com/d53ed4d2e
12:08:33 sigq: Title: pastebin - collaborative debugging tool ( at pastebin.com )
12:17:54 dassouki: _dbd_l12: is there a way i can verify if it's installed
15:26:52 TheSteve0: jlivni: ping