This is an update to the postgresql ebuild. The update aims to add postgis (GIS extensions http://postgis.refractions.net) support as a use flag in postgresql. This aims to replace the existence of the postgis ebuild which fetches the postgresql source tree and tries to recreate the postgresql installation. I think that this will be more convenient.
Created attachment 23725 [details] postgresql-7.4.1-r2.ebuild
this ebuild is dependent on the geos library which I also just submitted an ebuild.
Created attachment 35246 [details] postgresql-7.4.3-r99.ebuild This is a version upgrade to the previously posted ebuild. It now uses postgis-0.8.1 and depends on geos, for which an ebuild is available on bugs.gentoo.org
Created attachment 40796 [details] Updated to postgres-7.4.5-r1, postgis-0.9.0. Builds OK, please test When integrating postgis-0.9.0, I removed as many diffs as I could to the current postgres-7.4.5-r1 ebuild. I also updated the geos ebuild to 2.0.0 http://bugs.gentoo.org/show_bug.cgi?id=38060 This ebuild emerged correctly, but I know nothing about *using* postgis yet, and don't have any ready data available, so more experienced users please test. Postgis doesn't seem any more obtrusive to the ebuild than pgheir or other postgres options. Lets get one of the maintainers to mainline this and geos as soon as possible. Anyone want to create a companion ebuild against postgresql-8.0.0-beta*, so that postgis will be ready when 8.0.0 final is released?
Wish I'd looked here before updating the PostGIS port. Can someone get this into CVS please?
Created attachment 47161 [details, diff] diff against postgresql-7.4.6.ebuild to add USE postgis support This attachment is a diff to add USE postgis support to postgresql-7.4.6.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 47162 [details] postgresql-7.4.6.ebuild to add USE postgis support This attachment is a complete ebuild to add USE postgis support to postgresql-7.4.6.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 47163 [details, diff] diff against postgresql-8.0.0_rc2.ebuild to add USE postgis support This attachment is a diff to add USE postgis support to postgresql-8.0.0_rc2.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 47164 [details] postgresql-8.0.0_rc2.ebuild to add USE postgis support This attachment is an ebuild to add USE postgis support to postgresql-8.0.0_rc2.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 47620 [details, diff] diff against postgresql-8.0.0_rc3.ebuild to add USE postgis support This attachment is a diff to add USE postgis support to postgresql-8.0.0_rc3.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 47621 [details] postgresql-8.0.0_rc3.ebuild to add USE postgis support This attachment is an ebuild to add USE postgis support to postgresql-8.0.0_rc3.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 47883 [details, diff] diff against postgresql-8.0.0_rc4.ebuild to add USE postgis support This attachment is a diff to add USE postgis support to postgresql-8.0.0_rc4.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 47884 [details] postgresql-8.0.0_rc4.ebuild to add USE postgis support This attachment is an ebuild to add USE postgis support to postgresql-8.0.0_rc4.ebuild. I've tested the build/emerge process. Others please test the actual functionality of postgis integration. Note the dependency on sci-libs/geos. There is a new ebuild for that in bug http://bugs.gentoo.org/show_bug.cgi?id=38060 The other dependency proj, is already committed to sci-libs/proj. Please add this change to CVS as soon as possible. I would like to have uniform support for USE postgis in both 7.4.6 and 8.0.0 in time for the final 8.0 release.
Created attachment 55233 [details] ebuild for 8.0.1 I updated the ebuild for the newer postgresql. It's basically a manual application of the older patch. Works fine! I just tested a geometry column. I love postgis, it is wonderful, and I think it is really nice to have it as a USE option. There are just a couple of steps to activate it on a particular database once it's installed.
hi, i'm going to this ebuild to portage. (it would be 8.0.1-r3) can i ask a question before that? Is there a reason that you've added LDFLAGS=-lstdc++. Does postgis requires it?
(In reply to comment #15) > hi, > > i'm going to this ebuild to portage. (it would be 8.0.1-r3) > can i ask a question before that? > > Is there a reason that you've added LDFLAGS=-lstdc++. > Does postgis requires it? I'm fairly certain some of postgis's dependencies are written in C++.
Stand by for a postgis patch against 8.0.1-r4 Here is an example of why postgis is excellent. zone contains US time zone polygons. This query searches for all the time zones whose bounding boxes overlap 81 W, 27 N (in Florida, where I live) and it gives the correct answer. GEOS (the C++ dependency) allows more precise A inside B queries but it is probably be faster to narrow it down with bounding boxes first. gis=# select timezone, box2d(the_geom) from zone where the_geom && GeometryFromText('POINT(-81 27)'); timezone | box2d ----------+---------------------------------------------------------------------------- Eastern | BOX(-86.8262176513672 25.1177921295166,-66.9534225463867 47.4619216918945)
Postgis 1.0.0 released 2005/04/19.
Created attachment 59168 [details, diff] patch against postgresql 8.0.1-r4 to add postgis USE flag I've worked on this as much as I can for now and I'd appreciate other interested eyes. I have it working with the geos functions now. Bugs: had to comment out patches ; installs files in /usr/share/contrib ; does not install any postgis utility scripts.
Created attachment 59738 [details] postgresql 8.0.3 with postgis as a USE flag
i tried using the patch for 8.0.1-r4 and it worked for me. i hope this gets into the portage tree.
We have a separat package for postgis now: dev-db/postgis and won't include postgis directly in the postgresql-ebuild therefore.
