From dc12575e0d806a47587ed28917fae16f012c7a2b Mon Sep 17 00:00:00 2001 From: Aaron Swenson Date: Tue, 2 Aug 2011 02:13:49 +0000 Subject: [PATCH] Fixes bug 368177 and hopefully bug 341729 Package-Manager: portage-2.1.10.3/cvs/Linux i686 --- dev-db/postgresql-server/ChangeLog | 14 +- dev-db/postgresql-server/Manifest | 18 +- .../postgresql-server-8.2.21-r2.ebuild | 316 +++++++++++++++++ .../postgresql-server-8.3.15-r2.ebuild | 319 +++++++++++++++++ .../postgresql-server-8.4.8-r2.ebuild | 323 +++++++++++++++++ .../postgresql-server-9.0.4-r2.ebuild | 327 ++++++++++++++++++ .../postgresql-server-9.1_beta3-r1.ebuild | 320 +++++++++++++++++ 7 files changed, 1632 insertions(+), 5 deletions(-) create mode 100644 dev-db/postgresql-server/postgresql-server-8.2.21-r2.ebuild create mode 100644 dev-db/postgresql-server/postgresql-server-8.3.15-r2.ebuild create mode 100644 dev-db/postgresql-server/postgresql-server-8.4.8-r2.ebuild create mode 100644 dev-db/postgresql-server/postgresql-server-9.0.4-r2.ebuild create mode 100644 dev-db/postgresql-server/postgresql-server-9.1_beta3-r1.ebuild diff --git a/dev-db/postgresql-server/ChangeLog b/dev-db/postgresql-server/ChangeLog index 281663d62fa5..75a86c6e1ac8 100644 --- a/dev-db/postgresql-server/ChangeLog +++ b/dev-db/postgresql-server/ChangeLog @@ -1,6 +1,18 @@ # ChangeLog for dev-db/postgresql-server # Copyright 1999-2011 Gentoo Foundation; Distributed under the GPL v2 -# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/ChangeLog,v 1.133 2011/07/23 17:01:47 titanofold Exp $ +# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/ChangeLog,v 1.134 2011/08/02 02:13:49 titanofold Exp $ + +*postgresql-server-9.1_beta3-r1 (02 Aug 2011) +*postgresql-server-9.0.4-r2 (02 Aug 2011) +*postgresql-server-8.4.8-r2 (02 Aug 2011) +*postgresql-server-8.3.15-r2 (02 Aug 2011) +*postgresql-server-8.2.21-r2 (02 Aug 2011) + + 02 Aug 2011; Aaron W. Swenson + +postgresql-server-8.2.21-r2.ebuild, +postgresql-server-8.3.15-r2.ebuild, + +postgresql-server-8.4.8-r2.ebuild, +postgresql-server-9.0.4-r2.ebuild, + +postgresql-server-9.1_beta3-r1.ebuild: + Fixes bug 368177 and hopefully bug 341729 23 Jul 2011; Aaron W. Swenson -postgresql-server-8.2.21.ebuild, -postgresql-server-8.3.15.ebuild, diff --git a/dev-db/postgresql-server/Manifest b/dev-db/postgresql-server/Manifest index 3935d9565996..234aa6b8435d 100644 --- a/dev-db/postgresql-server/Manifest +++ b/dev-db/postgresql-server/Manifest @@ -37,30 +37,40 @@ DIST postgresql-9.1beta2.tar.bz2 14767102 RMD160 e1d884838772c2e7208b1afcf0e24dd DIST postgresql-9.1beta3.tar.bz2 14773133 RMD160 3582981068dde58abc7d43d3bb39c7517a41d51a SHA1 62dac43b151619aae3e40acd86feb3f34f79f027 SHA256 05bcb16dcd22e58a56ca25e30bbc81177e08c309b961fa36e9a4ec7a99949bd1 DIST postgresql-initscript-1.0.1.tbz2 2635 RMD160 989b89364ff367569c5129dec70c369496a69af1 SHA1 24cfbab756bf2c08e783ecae31c26ca45984de87 SHA256 a85276c431047e0123c988b296869cfa8afbbb6a4721d74fff4b419f608f0293 DIST postgresql-initscript-1.2.tbz2 2776 RMD160 137a737c928a73886192c822fe31be18e9ee0b85 SHA1 9140008e07c0c71e0fdbc8c2f6d40ab729d094a3 SHA256 19600139714738552e4b6880f6349df27b275814c62954103f20984b607e357f +DIST postgresql-patches-8.2-r1.tbz2 4859 RMD160 864f166e01219b1f8f9ca2732a1d6b9c6de0cf7f SHA1 27977244ef48cb1a232542657d76267faa7e9d3d SHA256 7b9f46ca16d7adf29cfd2a3f57f2b54bbf349b4dbbe679f4e31302376bda51cf DIST postgresql-patches-8.2.tbz2 4640 RMD160 d00ff2f4e573ba33bb77cb39374d20d28cd8e771 SHA1 e69fc03250a360d8b9bfed047c8ed6c18a8d7c9d SHA256 00bc4a97e0270310117d9114da7c5540aa990619d85670d871f7208c28703f42 +DIST postgresql-patches-8.3-r1.tbz2 5491 RMD160 6a05ec9a9c0dd587cc86e7684a353cb5e3cd7fa3 SHA1 a60e5f813e77f8b1edc9483f62e067b04457fb1d SHA256 522d4563f2e5fa857751091d1344799d8e22846de20c4fb360a7451d746fd176 DIST postgresql-patches-8.3.tbz2 5274 RMD160 b12f362a9f6795ef2180d2e9f09b049fffb328e8 SHA1 de6aba5ee191995758f79844b748d067ea8a8707 SHA256 fb29b45e6cdb58ed46a035e946e1e15c58fdf61328ab55fe81de88c96a352cc2 +DIST postgresql-patches-8.4-r1.tbz2 4826 RMD160 4cd4d9e890ef9010c89d88944a75bf6482b18742 SHA1 0ce0eefcc64b506b612b4da9e74fb8127dc514cb SHA256 00b915c2232c0f5c0a4fbcfbc66cff451429d544a2658aec6900858fb4c7224a DIST postgresql-patches-8.4.tbz2 4615 RMD160 ce13939969e19125099afcf8629b5f0955d83788 SHA1 381913b49dd2c9a5c6b105b6f45cc7b2784bb55b SHA256 6173fbc38d7eef912b51501f155f1c35a2dd891c4d4f31dd9758243e5becade8 DIST postgresql-patches-9.0-r1.tbz2 4305 RMD160 858525038e409bc351efd178cfa9886aa98e0944 SHA1 d1e8cdf56900ad1426f9b17fe0d45ec2beb39c49 SHA256 0f6684fec778208a8527f9bdd7eb498e0b25af6f3e01439c9774311fc541e107 +DIST postgresql-patches-9.0-r2.tbz2 4527 RMD160 781181b32326e0e2dd4e0624b78604cc4c8bf4c7 SHA1 3f3ebbb2ad83a4a8d94ebe05c23d7d753835ac86 SHA256 c7f5e77d16ecc384a8b7802ac2c35ed5b0de68f3dc30cb767a96b49501f8219f DIST postgresql-patches-9.1beta1.tbz2 4343 RMD160 a5e714733131afa3361c57cac5595482a9cc0778 SHA1 1c694f50db382c90a3fdd8548322ddf31b1b355d SHA256 216448c1810ef5de4ced5e52277fde2a8edc7979bda74bd8cd78b436dd83c509 DIST postgresql-patches-9.1beta2.tbz2 4343 RMD160 a5e714733131afa3361c57cac5595482a9cc0778 SHA1 1c694f50db382c90a3fdd8548322ddf31b1b355d SHA256 216448c1810ef5de4ced5e52277fde2a8edc7979bda74bd8cd78b436dd83c509 +DIST postgresql-patches-9.1beta3-r1.tbz2 4648 RMD160 9c98d2d5c0691618dc8aa86a5abdd956d2232fe6 SHA1 2fb476ac25a1263e0a14db4dbb8937002da31880 SHA256 db0a0ed4047181951dafdf72055f7c18ffd0b1ad63930aa839a437e5c16395cc DIST postgresql-patches-9.1beta3.tbz2 4421 RMD160 b9a95839861a5c0ecfcd9a0573bd080f17e0fc53 SHA1 e9cf9232825811eb20ad8323360cc82ad5a971f0 SHA256 a02be062a773e26adbe22616dabc8b78421d404964820ef885dea5540111b5ae EBUILD postgresql-server-8.2.20.ebuild 10148 RMD160 9e3da620143070e62daf7c475bc9246e93313e35 SHA1 26a8b7e21a435c8d8b2ba75e1b266d9fabc90e77 SHA256 2750bb3f2cfbd29db54565f82a022b606de6f2f0d3e92b7e15d2aca34337595b EBUILD postgresql-server-8.2.21-r1.ebuild 10836 RMD160 f0293c0e783379ab82b7291ed9fe5b1bde9676e5 SHA1 b74eb075fff1ba6331d231169c5430a6d263b2e7 SHA256 7212b39c1f9b5d7136bd68879fe0ed3ddc19ade6af458b436e776f185534b2df +EBUILD postgresql-server-8.2.21-r2.ebuild 10913 RMD160 ac625dbafbbcbf4d7f073c275ad76d21c0a1b91a SHA1 00daad90d6e515d7aeb4e6f1fc8c3406ccd7b4db SHA256 4ce8160fcad8d7e32e1e36b390dab8e2e0bd683507909c01cc561e9291b7cc83 EBUILD postgresql-server-8.3.14.ebuild 10276 RMD160 970bd57f2f49a6d6e54470aade654013a0dc76e5 SHA1 3a255eee8c1137e8a22c0489d9a50070e6f7f29a SHA256 84199b817928d5a13e5d7ccc25b533eb1d29a7533f9baae6406b9b7fd38aa155 EBUILD postgresql-server-8.3.15-r1.ebuild 11031 RMD160 f79e55bfca9a193d26d95ac8ca7fc398b855f1cf SHA1 a7637b3d574fdc1d77c27052a3e00782e5869e77 SHA256 2f1c05d7d24045a1fe6e8541bd4381c8fe159f7d8f4a167ca520ebac60c82b4e +EBUILD postgresql-server-8.3.15-r2.ebuild 11110 RMD160 d2b5f3f43f48869ce4e91c9093829f978dda6f38 SHA1 59c5108ef86c12cf20a40c5488c130a9335952b9 SHA256 9c548372eb35e6caf3c71b9be0d10f7efdfe9bb691de99f0b25d7573ece7056c EBUILD postgresql-server-8.4.7.ebuild 10344 RMD160 c885044bc7798ef4ff9be452f8a7efd627996306 SHA1 57c543f2be626f3728f7bc481e058908ca9e2f29 SHA256 5118b76613653f2037845b8f3f840af1e32ce4cbc721fbcd90f8e9406eb54bbd EBUILD postgresql-server-8.4.8-r1.ebuild 11320 RMD160 51902ce1c4dd1c9aa430427b1e86d3086fbed84e SHA1 5d19b20a7eaaa5544b17b8331c1d0ddd04dfa363 SHA256 3aeca5b6c9a6773fdb388ba36dc7569733087f8af857c1447195054367829cea +EBUILD postgresql-server-8.4.8-r2.ebuild 11401 RMD160 992434002a551e071a347dc40206cf0e7afac288 SHA1 424e3e3dc6588a3d2bbdd726fc2545642aceaace SHA256 0f36fe1175a87de0f4cee85a3c4d1dc50e563fefdf09a35190ac601fc3b38a9e EBUILD postgresql-server-9.0.3.ebuild 10178 RMD160 65da0866e062f1254e5e082aa3d6e5460035c972 SHA1 629aba6be85464b7e32548e05accc1cb86eeada9 SHA256 5f931b0c7a5ba5265cc1e3386243e18bba02fa1ff415b79d9f78ecbb5d3734de EBUILD postgresql-server-9.0.4-r1.ebuild 11269 RMD160 da8a282754b447e8d1cc3d650cce3a28b1e979e4 SHA1 cb2245c3c11a2df7412000b500fc9d2b1930c57d SHA256 fd006da302cc19a270ac9cfea76b604e93b54f7fa038d09fe23b0c540957e17c +EBUILD postgresql-server-9.0.4-r2.ebuild 11315 RMD160 1e4f44f652d2ee83f5f6a43fdb5f71d486d5ae51 SHA1 ac3db690241e1e33b3a1b17ae8a28640885edeb5 SHA256 766a7ff28a3581e863c88768670d06bf1c031665ed75c26c151fb99a16323d1b EBUILD postgresql-server-9.1_beta1-r1.ebuild 10803 RMD160 98b0630335d0239c385d3aae9cefd45f38f7ba8c SHA1 ce01de1d3814095a432fd5bfe0829c27a330d443 SHA256 360755f56791f401a9a77a102e87915ebe07036cfd8118c74a7eae641cc66a64 EBUILD postgresql-server-9.1_beta2.ebuild 10839 RMD160 c8d49e39c8f5f8a63006b09d8f644348ba621f0a SHA1 287556e92ad77511d4a4853154c7e010c0de0ce1 SHA256 6744fdebe9941a35a56767ccb592b36b9f3484c32d50a1f16c63358f15689db3 +EBUILD postgresql-server-9.1_beta3-r1.ebuild 10822 RMD160 b0a5f7d38f8556d526fd0eaf764c702b6991f2d1 SHA1 ccecfacc14268739e28551d304d9c1e88cad88cf SHA256 e6b1bef77dc5eb4cbd3a043b263fd367bb373badc061d04160246b3343868ebd EBUILD postgresql-server-9.1_beta3.ebuild 10859 RMD160 b6ceed5bc0af59e7178e3ac054bca7d9f1e162f5 SHA1 0feb7606303706d8520c5a6d21eb288101b864b9 SHA256 fe390b752122be578ad3d3cbeb025830bc5a7cdabc31cf96e2e5e3f81ca6bb9b -MISC ChangeLog 42968 RMD160 bdf777c1dafe9a303175c281f7440e43a03f350d SHA1 0fe88e125426e2509e780b288ab3c549c0a2a85e SHA256 5d32a3a2ae4cc56714c9e68c357b9f2c872bc97aec20ca5a467b5fa966afcd3c +MISC ChangeLog 43478 RMD160 1ba76c10166a7a99dc28425a824c9ec2212f21ff SHA1 cda237b226f7460c9a6997947ca94e4f0c52e2df SHA256 399217c6863426e4fd00e2379e67ed6faf933fcdcfbb091e03a983e87946292d MISC metadata.xml 420 RMD160 789f5a0ce45d05125098fd7e74a816cf08f4c39b SHA1 d308d7434a37f12cd320f74ed85e1d3ca7dabc75 SHA256 ac37a5084450a782d02510149d030bd0d4a63164f2ffb7bdda3ddf344606ca62 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux) -iF4EAREIAAYFAk4q/oMACgkQCOhwUhu5AEmTqgEAnOtyWYNSSWANiEODdET82cDO -lllsQ+Ksr2HsvClD3WEA/15k8srKUzvAPCpIiFwKnzFCSVJBdGtTfWlv6msVZXia -=E3HE +iF4EAREIAAYFAk43XWcACgkQCOhwUhu5AEk7sgD/YGXlOHEaVktQLMlgGqQCmjfO +B/vkP9x3mGnjuHp43nEBAIEhvkkvJ885yQVWD5brAdczuI6F3+SgRjD6xBu6MNbT +=Xm8F -----END PGP SIGNATURE----- diff --git a/dev-db/postgresql-server/postgresql-server-8.2.21-r2.ebuild b/dev-db/postgresql-server/postgresql-server-8.2.21-r2.ebuild new file mode 100644 index 000000000000..3f2ddff07419 --- /dev/null +++ b/dev-db/postgresql-server/postgresql-server-8.2.21-r2.ebuild @@ -0,0 +1,316 @@ +# Copyright 1999-2011 Gentoo Foundation +# Distributed under the terms of the GNU General Public License v2 +# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/postgresql-server-8.2.21-r2.ebuild,v 1.1 2011/08/02 02:13:49 titanofold Exp $ + +EAPI="4" + +WANT_AUTOMAKE="none" +inherit autotools eutils multilib pam prefix versionator + +SLOT="$(get_version_component_range 1-2)" + +KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~ppc ~s390 ~sh ~sparc ~x86" + +DESCRIPTION="PostgreSQL server" +HOMEPAGE="http://www.postgresql.org/" +SRC_URI="mirror://postgresql/source/v${PV}/postgresql-${PV}.tar.bz2 + http://dev.gentoo.org/~titanofold/postgresql-patches-${SLOT}-r1.tbz2 + http://dev.gentoo.org/~titanofold/postgresql-initscript-1.0.1.tbz2" +LICENSE="POSTGRESQL" + +S="${WORKDIR}/postgresql-${PV}" + +LINGUAS="af cs de en es fa fr hr hu it ko nb pl pt_BR ro ru sk sl sv tr zh_CN zh_TW" +IUSE="doc kernel_linux nls pam perl python selinux tcl xml" + +for lingua in ${LINGUAS} ; do + IUSE+=" linguas_${lingua}" +done + +wanted_languages() { + local enable_langs + + for lingua in ${LINGUAS} ; do + use linguas_${lingua} && enable_langs+="${lingua} " + done + + echo -n ${enable_langs} +} + +RDEPEND="~dev-db/postgresql-base-${PV}:${SLOT}[pam?,nls=] + perl? ( >=dev-lang/perl-5.8 ) + selinux? ( sec-policy/selinux-postgresql ) + tcl? ( >=dev-lang/tcl-8 ) + xml? ( dev-libs/libxml2 dev-libs/libxslt )" + +DEPEND="${RDEPEND} + sys-devel/flex + xml? ( dev-util/pkgconfig )" + +PDEPEND="doc? ( ~dev-db/postgresql-docs-${PV} )" + +pkg_setup() { + enewgroup postgres 70 + enewuser postgres 70 /bin/bash /var/lib/postgresql postgres +} + +src_prepare() { + epatch "${WORKDIR}/autoconf.patch" "${WORKDIR}/bool.patch" \ + "${WORKDIR}/darwin.patch" "${WORKDIR}/pg_ctl-exit-status.patch" \ + "${WORKDIR}/server.patch" "${WORKDIR}/SuperH.patch" + + eprefixify src/include/pg_config_manual.h + + if use test ; then + epatch "${WORKDIR}/regress.patch" + sed -e "s|@SOCKETDIR@|${T}|g" -i src/test/regress/pg_regress.c + sed -e "s|/no/such/location|${S}/src/test/regress/tmp_check/no/such/location|g" \ + -i src/test/regress/{input,output}/tablespace.source + else + echo "all install:" > "${S}/src/test/regress/GNUmakefile" + fi + + eautoconf +} + +src_configure() { + # eval is needed to get along with pg_config quotation of space-rich entities. + eval econf "$(${EPREFIX%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --configure)" \ + --with-includes="${EPREFIX%/}/usr/include/postgresql-${SLOT}/" \ + $(use_with perl) \ + $(use_with python) \ + $(use_with tcl) \ + "$(has_version ~dev-db/postgresql-base-${PV}[nls] && use_enable nls nls "$(wanted_languages)")" +} + +src_compile() { + local bd + for bd in . contrib $(use xml && echo contrib/xml2); do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake -C $bd -j1 \ + PGXS=$(${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \ + PGXS_IN_SERVER=1 PGXS_WITH_SERVER="${S}/src/backend/postgres" \ + NO_PGXS=0 USE_PGXS=1 docdir=${EROOT%/}/usr/share/doc/${PF} + done +} + +src_install() { + if use perl ; then + mv -f "${S}/src/pl/plperl/GNUmakefile" "${S}/src/pl/plperl/GNUmakefile_orig" + sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \ + "${S}/src/pl/plperl/GNUmakefile_orig" > "${S}/src/pl/plperl/GNUmakefile" + fi + + local bd + for bd in . contrib $(use xml && echo contrib/xml2) ; do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake install -C $bd -j1 DESTDIR="${D}" \ + PGXS_IN_SERVER=1 PGXS_WITH_SERVER="${S}/src/backend/postgres" \ + PGXS=$(${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \ + NO_PGXS=0 USE_PGXS=1 docdir=${EROOT%/}/usr/share/doc/${PF} + done + + rm -r "${ED}/usr/share/postgresql-${SLOT}/man/man7/" "${ED}/usr/share/doc/${PF}/html" + rm "${ED}"/usr/share/postgresql-${SLOT}/man/man1/{clusterdb,create{db,lang,user},drop{db,lang,user},ecpg,pg_{config,dump,dumpall,restore},psql,reindexdb,vacuumdb}.1 + docompress /usr/share/postgresql-${SLOT}/man/man1 + + dodoc README HISTORY doc/{README.*,TODO,bug.template} + + dodir /etc/eselect/postgresql/slots/${SLOT} + echo "postgres_ebuilds=\"\${postgres_ebuilds} ${PF}\"" \ + > "${ED}/etc/eselect/postgresql/slots/${SLOT}/server" + + newconfd "${WORKDIR}/postgresql.confd" postgresql-${SLOT} + newinitd "${WORKDIR}/postgresql.init" postgresql-${SLOT} + + use pam && pamd_mimic system-auth postgresql auth account session + + keepdir /var/run/postgresql + fperms 0770 /var/run/postgresql + use prefix || fowners postgres:postgres /var/run/postgresql +} + +pkg_postinst() { + postgresql-config update + + elog "The Unix-domain socket is located in:" + elog " ${EROOT%/}/var/run/postgresql/" + elog + elog "If you have users and/or services that you would like to utilize the socket," + elog "you must add them to the 'postgres' system group:" + elog " usermod -a -G postgres " + elog + elog "Before initializing the database, you may want to edit PG_INITDB_OPTS so that" + elog "it contains your preferred locale in:" + elog " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + elog + elog "Then, execute the following command to setup the initial database" + elog "environment:" + elog " emerge --config =${CATEGORY}/${PF}" +} + +pkg_postrm() { + postgresql-config update +} + +pkg_config() { + [[ -f ${EROOT%/}/etc/conf.d/postgresql-${SLOT} ]] && source ${EROOT%/}/etc/conf.d/postgresql-${SLOT} + [[ -z ${PGDATA} ]] && PGDATA="${EROOT%/}/etc/postgresql-${SLOT}/" + [[ -z ${DATA_DIR} ]] && DATA_DIR="${EROOT%/}/var/lib/postgresql/${SLOT}/data" + + # environment.bz2 may not contain the same locale as the current system + # locale. Unset and source from the current system locale. + if [[ -f ${EROOT%/}/etc/env.d/02locale ]] ; then + unset LANG + unset LC_CTYPE + unset LC_NUMERIC + unset LC_TIME + unset LC_COLLATE + unset LC_MONETARY + unset LC_MESSAGES + unset LC_ALL + source ${EROOT%/}/etc/env.d/02locale + [[ -n ${LANG} ]] && export LANG + [[ -n ${LC_CTYPE} ]] && export LC_CTYPE + [[ -n ${LC_NUMERIC} ]] && export LC_NUMERIC + [[ -n ${LC_TIME} ]] && export LC_TIME + [[ -n ${LC_COLLATE} ]] && export LC_COLLATE + [[ -n ${LC_MONETARY} ]] && export LC_MONETARY + [[ -n ${LC_MESSAGES} ]] && export LC_MESSAGES + [[ -n ${LC_ALL} ]] && export LC_ALL + fi + + einfo "You can modify the paths and options passed to initdb by editing:" + einfo " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + einfo + einfo "Information on options that can be passed to initdb are found at:" + einfo " http://www.postgresql.org/docs/${SLOT}/static/creating-cluster.html" + einfo " http://www.postgresql.org/docs/${SLOT}/static/app-initdb.html" + einfo + einfo "PG_INITDB_OPTS is currently set to:" + if [[ -z "${PG_INITDB_OPTS}" ]] ; then + einfo " (none)" + else + einfo " ${PG_INITDB_OPTS}" + fi + einfo + einfo "Configuration files will be installed to:" + einfo " ${PGDATA}" + einfo + einfo "The database cluster will be created in:" + einfo " ${DATA_DIR}" + einfo + while [[ $correct != "true" ]] ; do + einfo "Are you ready to continue? (y/n)" + read answer + if [[ $answer =~ ^[Yy]([Ee][Ss])?$ ]] ; then + correct="true" + elif [[ $answer =~ ^[Nn]([Oo])?$ ]] ; then + die "Aborting initialization." + else + echo "Answer not recognized" + fi + done + + if [ -n "$(ls -A ${DATA_DIR} 2> /dev/null)" ] ; then + eerror "The given directory, '${DATA_DIR}', is not empty." + eerror "Modify DATA_DIR to point to an empty directory." + die "${DATA_DIR} is not empty." + fi + + [[ -z ${PG_MAX_CONNECTIONS} ]] && PG_MAX_CONNECTIONS=128 + einfo "Checking system parameters..." + + if ! use kernel_linux ; then + einfo "Skipped." + einfo "Tests not supported on this OS (yet)" + else + if [[ -z ${SKIP_SYSTEM_TESTS} ]] ; then + einfo "Checking whether your system supports at least ${PG_MAX_CONNECTIONS} connections..." + + local SEMMSL=$(sysctl -n kernel.sem | cut -f1) + local SEMMNS=$(sysctl -n kernel.sem | cut -f2) + local SEMMNI=$(sysctl -n kernel.sem | cut -f4) + local SHMMAX=$(sysctl -n kernel.shmmax) + + local SEMMSL_MIN=17 + local SEMMNS_MIN=$(( ( ${PG_MAX_CONNECTIONS}/16 ) * 17 )) + local SEMMNI_MIN=$(( ( ${PG_MAX_CONNECTIONS}+15 ) / 16 )) + local SHMMAX_MIN=$(( 500000 + ( 30600 * ${PG_MAX_CONNECTIONS} ) )) + + for p in SEMMSL SEMMNS SEMMNI SHMMAX ; do + if [[ $(eval echo \$$p) -lt $(eval echo \$${p}_MIN) ]] ; then + eerror "The value for ${p} $(eval echo \$$p) is below the recommended value $(eval echo \$${p}_MIN)" + eerror "You have now several options:" + eerror " - Change the mentioned system parameter" + eerror " - Lower the number of max.connections by setting PG_MAX_CONNECTIONS to a" + eerror " value lower than ${PG_MAX_CONNECTIONS}" + eerror " - Set SKIP_SYSTEM_TESTS in case you want to ignore this test completely" + eerror "More information can be found here:" + eerror " http://www.postgresql.org/docs/${SLOT}/static/kernel-resources.html" + die "System test failed." + fi + done + einfo "Passed." + else + ewarn "SKIP_SYSTEM_TESTS set, so skipping." + fi + fi + + if [[ ${EUID} == 0 ]] ; then + einfo "Creating the data directory ..." + mkdir -p "${DATA_DIR}" + chown -Rf postgres:postgres "${DATA_DIR}" + chmod 0700 "${DATA_DIR}" + fi + + einfo "Initializing the database ..." + if [[ ${EUID} == 0 ]] ; then + su postgres -c "${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -D \"${DATA_DIR}\" ${PG_INITDB_OPTS}" + else + "${EROOT%/}"/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -U postgres -D "${DATA_DIR}" ${PG_INITDB_OPTS} + fi + mv "${DATA_DIR%/}"/*.conf "${PGDATA}" + + einfo "The autovacuum function, which was in contrib, has been moved to the main" + einfo "PostgreSQL functions starting with 8.1." + einfo "You can enable it in the cluster's:" + einfo " ${PGDATA%/}/postgresql.conf" + einfo + einfo "The PostgreSQL server, by default, will log events to:" + einfo " ${DATA_DIR%/}/postmaster.log" + einfo + if use prefix ; then + einfo "The location of the configuration files have moved to:" + einfo " ${PGDATA}" + einfo + einfo "To start the server:" + einfo " pg_ctl start -D ${DATA_DIR} -o '-D ${PGDATA} --data-directory=${DATA_DIR}'" + einfo + einfo "To stop:" + einfo " pg_ctl stop -D ${DATA_DIR}" + einfo + einfo "Or move the configuration files back:" + einfo " mv ${PGDATA}*.conf ${DATA_DIR}" + else + einfo "You should use the '${EROOT%/}/etc/init.d/postgresql-${SLOT}' script to run PostgreSQL" + einfo "instead of 'pg_ctl'." + fi +} + +src_test() { + einfo ">>> Test phase [check]: ${CATEGORY}/${PF}" + + if [[ ${UID} != 0 ]] ; then + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/:${PATH}" \ + emake check \ + PGXS=$("${EROOT%/}"/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \ + NO_PGXS=0 USE_PGXS=1 SLOT="${SLOT}" + + einfo "If you think other tests besides the regression tests are necessary, please" + einfo "submit a bug including a patch for this ebuild to enable them." + else + ewarn "Tests cannot be run as root. Skipping." + ewarn "HINT: FEATURES=\"userpriv\"" + fi +} diff --git a/dev-db/postgresql-server/postgresql-server-8.3.15-r2.ebuild b/dev-db/postgresql-server/postgresql-server-8.3.15-r2.ebuild new file mode 100644 index 000000000000..2f6f0f9198b3 --- /dev/null +++ b/dev-db/postgresql-server/postgresql-server-8.3.15-r2.ebuild @@ -0,0 +1,319 @@ +# Copyright 1999-2011 Gentoo Foundation +# Distributed under the terms of the GNU General Public License v2 +# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/postgresql-server-8.3.15-r2.ebuild,v 1.1 2011/08/02 02:13:49 titanofold Exp $ + +EAPI="4" + +WANT_AUTOMAKE="none" +inherit autotools eutils multilib pam prefix versionator + +SLOT="$(get_version_component_range 1-2)" + +KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~s390 ~sh ~sparc ~x86 ~x86-fbsd" + +DESCRIPTION="PostgreSQL server" +HOMEPAGE="http://www.postgresql.org/" +SRC_URI="mirror://postgresql/source/v${PV}/postgresql-${PV}.tar.bz2 + http://dev.gentoo.org/~titanofold/postgresql-patches-${SLOT}-r1.tbz2 + http://dev.gentoo.org/~titanofold/postgresql-initscript-1.2.tbz2" +LICENSE="POSTGRESQL" + +S="${WORKDIR}/postgresql-${PV}" + +LINGUAS="af cs de en es fa fr hr hu it ko nb pl pt_BR ro ru sk sl sv tr zh_CN zh_TW" +IUSE="doc kernel_linux nls pam perl python selinux tcl uuid xml" + +for lingua in ${LINGUAS} ; do + IUSE+=" linguas_${lingua}" +done + +wanted_languages() { + local enable_langs + + for lingua in ${LINGUAS} ; do + use linguas_${lingua} && enable_langs+="${lingua} " + done + + echo -n ${enable_langs} +} + +RDEPEND="~dev-db/postgresql-base-${PV}:${SLOT}[pam?,nls=] + perl? ( >=dev-lang/perl-5.8 ) + selinux? ( sec-policy/selinux-postgresql ) + tcl? ( >=dev-lang/tcl-8 ) + uuid? ( dev-libs/ossp-uuid ) + xml? ( dev-libs/libxml2 dev-libs/libxslt )" + +DEPEND="${RDEPEND} + sys-devel/flex + xml? ( dev-util/pkgconfig )" + +PDEPEND="doc? ( ~dev-db/postgresql-docs-${PV} )" + +pkg_setup() { + enewgroup postgres 70 + enewuser postgres 70 /bin/bash /var/lib/postgresql postgres +} + +src_prepare() { + epatch "${WORKDIR}/autoconf.patch" "${WORKDIR}/bool.patch" \ + "${WORKDIR}/darwin.patch" "${WORKDIR}/pg_ctl-exit-status.patch" \ + "${WORKDIR}/server.patch" "${WORKDIR}/SuperH.patch" + + eprefixify src/include/pg_config_manual.h + + if use test ; then + epatch "${WORKDIR}/regress.patch" + sed -e "s|@SOCKETDIR@|${T}|g" -i src/test/regress/pg_regress{,_main}.c + sed -e "s|/no/such/location|${S}/src/test/regress/tmp_check/no/such/location|g" \ + -i src/test/regress/{input,output}/tablespace.source + else + echo "all install:" > "${S}/src/test/regress/GNUmakefile" + fi + + eautoconf +} + +src_configure() { + # eval is needed to get along with pg_config quotation of space-rich entities. + eval econf "$(${EPREFIX%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --configure)" \ + --with-includes="${EPREFIX%/}/usr/include/postgresql-${SLOT}/" \ + --with-system-tzdata="${EPREFIX%/}/usr/share/zoneinfo" \ + $(use_with perl) \ + $(use_with python) \ + $(use_with tcl) \ + $(use_with xml libxml) \ + $(use_with xml libxslt) \ + $(use_with uuid ossp-uuid) \ + "$(has_version ~dev-db/postgresql-base-${PV}[nls] && use_enable nls nls "$(wanted_languages)")" +} + +src_compile() { + local bd + for bd in . contrib $(use xml && echo contrib/xml2); do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake -C $bd -j1 \ + PGXS=$(${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \ + PGXS_IN_SERVER=1 PGXS_WITH_SERVER="${S}/src/backend/postgres" \ + NO_PGXS=0 USE_PGXS=1 docdir=${EROOT%/}/usr/share/doc/${PF} + done +} + +src_install() { + if use perl ; then + mv -f "${S}/src/pl/plperl/GNUmakefile" "${S}/src/pl/plperl/GNUmakefile_orig" + sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \ + "${S}/src/pl/plperl/GNUmakefile_orig" > "${S}/src/pl/plperl/GNUmakefile" + fi + + local bd + for bd in . contrib $(use xml && echo contrib/xml2) ; do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake install -C $bd -j1 DESTDIR="${D}" \ + PGXS_IN_SERVER=1 PGXS_WITH_SERVER="${S}/src/backend/postgres" \ + PGXS=$(${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \ + NO_PGXS=0 USE_PGXS=1 docdir=${EROOT%/}/usr/share/doc/${PF} + done + + rm -r "${ED}/usr/share/postgresql-${SLOT}/man/man7/" "${ED}/usr/share/doc/${PF}/html" + rm "${ED}"/usr/share/postgresql-${SLOT}/man/man1/{clusterdb,create{db,lang,user},drop{db,lang,user},ecpg,pg_{config,dump,dumpall,restore},psql,reindexdb,vacuumdb}.1 + docompress /usr/share/postgresql-${SLOT}/man/man1 + + dodoc README HISTORY doc/{README.*,TODO,bug.template} + + dodir /etc/eselect/postgresql/slots/${SLOT} + echo "postgres_ebuilds=\"\${postgres_ebuilds} ${PF}\"" \ + > "${ED}/etc/eselect/postgresql/slots/${SLOT}/server" + + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}"/postgresql.confd + newconfd "${WORKDIR}/postgresql.confd" postgresql-${SLOT} + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}"/postgresql.init + newinitd "${WORKDIR}/postgresql.init" postgresql-${SLOT} + + use pam && pamd_mimic system-auth postgresql auth account session + + keepdir /var/run/postgresql + fperms 0770 /var/run/postgresql + use prefix || fowners postgres:postgres /var/run/postgresql +} + +pkg_postinst() { + postgresql-config update + + elog "The Unix-domain socket is located in:" + elog " ${EROOT%/}/var/run/postgresql/" + elog + elog "If you have users and/or services that you would like to utilize the socket," + elog "you must add them to the 'postgres' system group:" + elog " usermod -a -G postgres " + elog + elog "Before initializing the database, you may want to edit PG_INITDB_OPTS so that" + elog "it contains your preferred locale in:" + elog " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + elog + elog "Execute the following command to setup the initial database" + elog "environment:" + elog " emerge --config =${CATEGORY}/${PF}" +} + +pkg_postrm() { + postgresql-config update +} + +pkg_config() { + [[ -f ${EROOT%/}/etc/conf.d/postgresql-${SLOT} ]] && source "${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + [[ -z ${PGDATA} ]] && PGDATA="${EROOT%/}/etc/postgresql-${SLOT}/" + [[ -z ${DATA_DIR} ]] && DATA_DIR="${EROOT%/}/var/lib/postgresql/${SLOT}/data" + + # environment.bz2 may not contain the same locale as the current system + # locale. Unset and source from the current system locale. + if [[ -f ${EROOT%/}/etc/env.d/02locale ]] ; then + unset LANG + unset LC_CTYPE + unset LC_NUMERIC + unset LC_TIME + unset LC_COLLATE + unset LC_MONETARY + unset LC_MESSAGES + unset LC_ALL + source ${EROOT%/}/etc/env.d/02locale + [[ -n ${LANG} ]] && export LANG + [[ -n ${LC_CTYPE} ]] && export LC_CTYPE + [[ -n ${LC_NUMERIC} ]] && export LC_NUMERIC + [[ -n ${LC_TIME} ]] && export LC_TIME + [[ -n ${LC_COLLATE} ]] && export LC_COLLATE + [[ -n ${LC_MONETARY} ]] && export LC_MONETARY + [[ -n ${LC_MESSAGES} ]] && export LC_MESSAGES + [[ -n ${LC_ALL} ]] && export LC_ALL + fi + + einfo "You can modify the paths and options passed to initdb by editing:" + einfo " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + einfo + einfo "Information on options that can be passed to initdb are found at:" + einfo " http://www.postgresql.org/docs/${SLOT}/static/creating-cluster.html" + einfo " http://www.postgresql.org/docs/${SLOT}/static/app-initdb.html" + einfo + einfo "PG_INITDB_OPTS is currently set to:" + if [[ -z ${PG_INITDB_OPTS} ]] ; then + einfo " (none)" + else + einfo " ${PG_INITDB_OPTS}" + fi + einfo + einfo "Configuration files will be installed to:" + einfo " ${PGDATA}" + einfo + einfo "The database cluster will be created in:" + einfo " ${DATA_DIR}" + einfo + while [[ $correct != "true" ]] ; do + einfo "Are you ready to continue? (y/n)" + read answer + if [[ $answer =~ ^[Yy]([Ee][Ss])?$ ]] ; then + correct="true" + elif [[ $answer =~ ^[Nn]([Oo])?$ ]] ; then + die "Aborting initialization." + else + echo "Answer not recognized." + fi + done + + if [[ -n "$(ls -A ${DATA_DIR} 2> /dev/null)" ]] ; then + eerror "The given directory, '${DATA_DIR}', is not empty." + eerror "Modify DATA_DIR to point to an empty directory." + die "${DATA_DIR} is not empty." + fi + + [[ -z ${PG_MAX_CONNECTIONS} ]] && PG_MAX_CONNECTIONS=128 + einfo "Checking system parameters..." + + if ! use kernel_linux ; then + einfo "Skipped." + einfo "Tests not supported on this OS (yet)." + else + if [[ -z ${SKIP_SYSTEM_TESTS} ]] ; then + einfo "Checking whether your system supports at least ${PG_MAX_CONNECTIONS} connections..." + + local SEMMSL=$(sysctl -n kernel.sem | cut -f1) + local SEMMNS=$(sysctl -n kernel.sem | cut -f2) + local SEMMNI=$(sysctl -n kernel.sem | cut -f4) + local SHMMAX=$(sysctl -n kernel.shmmax) + + local SEMMSL_MIN=17 + local SEMMNS_MIN=$(( ( ${PG_MAX_CONNECTIONS}/16 ) * 17 )) + local SEMMNI_MIN=$(( ( ${PG_MAX_CONNECTIONS}+15 ) / 16 )) + local SHMMAX_MIN=$(( 500000 + ( 30600 * ${PG_MAX_CONNECTIONS} ) )) + + for p in SEMMSL SEMMNS SEMMNI SHMMAX ; do + if [[ $(eval echo \$$p) -lt $(eval echo \$${p}_MIN) ]] ; then + eerror "The value for ${p} $(eval echo \$$p) is below the recommended value $(eval echo \$${p}_MIN)" + eerror "You have now several options:" + eerror " - Change the mentioned system parameter" + eerror " - Lower the number of max connections by setting PG_MAX_CONNECTIONS to a" + eerror " value lower than ${PG_MAX_CONNECTIONS}" + eerror " - Set SKIP_SYSTEM_TESTS in case you want to ignore this test completely" + eerror "More information can be found here:" + eerror " http://www.postgresql.org/docs/${SLOT}/static/kernel-resources.html" + die "System test failed." + fi + done + einfo "Passed." + else + ewarn "SKIP_SYSTEM_TESTS is set, so skipping." + fi + fi + + if [[ ${EUID} == 0 ]] ; then + einfo "Creating the data directory ..." + mkdir -p "${DATA_DIR}" + chown -Rf postgres:postgres "${DATA_DIR}" + chmod 0700 "${DATA_DIR}" + fi + + einfo "Initializing the database ..." + if [[ ${EUID} == 0 ]] ; then + su postgres -c "${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -D \"${DATA_DIR}\" ${PG_INITDB_OPTS}" + else + "${EROOT%/}"/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -U postgres -D "${DATA_DIR}" ${PG_INITDB_OPTS} + fi + mv "${DATA_DIR%/}"/*.conf "${PGDATA}" + + einfo "The autovacuum function, which was in contrib, has been moved to the main" + einfo "PostgreSQL functions starting with 8.1. You can enable it in the clusters" + einfo "postgresql.conf." + einfo + if use prefix ; then + einfo "The location of the configuration files have moved to:" + einfo " ${PGDATA}" + einfo + einfo "To start the server:" + einfo " pg_ctl start -D ${DATA_DIR} -o '-D ${PGDATA} --data-directory=${DATA_DIR}'" + einfo + einfo "To stop:" + einfo " pg_ctl stop -D ${DATA_DIR}" + einfo + einfo "Or move the configuration files back:" + einfo " mv ${PGDATA}*.conf ${DATA_DIR}" + else + einfo "You should use the '${EROOT%/}/etc/init.d/postgresql-${SLOT}' script to run PostgreSQL" + einfo "instead of 'pg_ctl'." + fi +} + +src_test() { + einfo ">>> Test phase [check]: ${CATEGORY}/${PF}" + + if [[ ${UID} != 0 ]] ; then + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/:${PATH}" \ + emake check \ + PGXS=$(${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \ + NO_PGXS=0 USE_PGXS=1 SLOT=${SLOT} + + einfo "If you think other tests besides the regression tests are necessary, please" + einfo "submit a bug including a patch for this ebuild to enable them." + else + ewarn "Tests cannot be run as root. Skipping." + ewarn "HINT: FEATURES=\"userpriv\"" + fi +} diff --git a/dev-db/postgresql-server/postgresql-server-8.4.8-r2.ebuild b/dev-db/postgresql-server/postgresql-server-8.4.8-r2.ebuild new file mode 100644 index 000000000000..1387fc0af735 --- /dev/null +++ b/dev-db/postgresql-server/postgresql-server-8.4.8-r2.ebuild @@ -0,0 +1,323 @@ +# Copyright 1999-2011 Gentoo Foundation +# Distributed under the terms of the GNU General Public License v2 +# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/postgresql-server-8.4.8-r2.ebuild,v 1.1 2011/08/02 02:13:49 titanofold Exp $ + +EAPI="3" +PYTHON_DEPEND="python? 2" + +WANT_AUTOMAKE="none" +inherit autotools eutils multilib pam prefix python versionator + +SLOT="$(get_version_component_range 1-2)" + +KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~s390 ~sh ~sparc ~x86 ~x86-fbsd" + +DESCRIPTION="PostgreSQL server" +HOMEPAGE="http://www.postgresql.org/" +SRC_URI="mirror://postgresql/source/v${PV}/postgresql-${PV}.tar.bz2 + http://dev.gentoo.org/~titanofold/postgresql-patches-${SLOT}-r1.tbz2 + http://dev.gentoo.org/~titanofold/postgresql-initscript-1.2.tbz2" +LICENSE="POSTGRESQL" + +S="${WORKDIR}/postgresql-${PV}" + +LINGUAS="af cs de en es fa fr hr hu it ko nb pl pt_BR ro ru sk sl sv tr zh_CN zh_TW" +IUSE="doc kernel_linux nls pam perl -pg_legacytimestamp python selinux tcl uuid xml" + +for lingua in ${LINGUAS} ; do + IUSE+=" linguas_${lingua}" +done + +wanted_languages() { + local enable_langs + + for lingua in ${LINGUAS} ; do + use linguas_${lingua} && enable_langs+="${lingua} " + done + + echo -n ${enable_langs} +} + +RDEPEND="~dev-db/postgresql-base-${PV}:${SLOT}[pam?,pg_legacytimestamp=,nls=] + perl? ( >=dev-lang/perl-5.8 ) + selinux? ( sec-policy/selinux-postgresql ) + tcl? ( >=dev-lang/tcl-8 ) + uuid? ( dev-libs/ossp-uuid ) + xml? ( dev-libs/libxml2 dev-libs/libxslt )" + +DEPEND="${RDEPEND} + sys-devel/flex + xml? ( dev-util/pkgconfig )" + +PDEPEND="doc? ( ~dev-db/postgresql-docs-${PV} )" + +pkg_setup() { + enewgroup postgres 70 + enewuser postgres 70 /bin/bash /var/lib/postgresql postgres + + use python && python_set_active_version 2 +} + +src_prepare() { + epatch "${WORKDIR}/autoconf.patch" "${WORKDIR}/bool.patch" \ + "${WORKDIR}/darwin.patch" "${WORKDIR}/ldflags.patch" \ + "${WORKDIR}/pg_ctl-exit-status.patch" "${WORKDIR}/server.patch" \ + "${WORKDIR}/SuperH.patch" + + eprefixify src/include/pg_config_manual.h + + if use test ; then + epatch "${WORKDIR}/regress.patch" + sed -e "s|@SOCKETDIR@|${T}|g" -i src/test/regress/pg_regress{,_main}.c + sed -e "s|/no/such/location|${S}/src/test/regress/tmp_check/no/such/location|g" \ + -i src/test/regress/{input,output}/tablespace.source + else + echo "all install:" > "${S}/src/test/regress/GNUmakefile" + fi + + eautoconf +} + +src_configure() { + # eval is needed to get along with pg_config quotation of space-rich entities. + eval econf "$(${EPREFIX%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --configure)" \ + --with-includes="${EPREFIX%/}/usr/include/postgresql-${SLOT}/" \ + --with-libraries="${EPREFIX%/}/usr/$(get_libdir)/postgresql-${SLOT}/$(get_libdir)" \ + --with-system-tzdata="${EPREFIX%/}/usr/share/zoneinfo" \ + $(use_with perl) \ + $(use_with python) \ + $(use_with tcl) \ + $(use_with xml libxml) \ + $(use_with xml libxslt) \ + $(use_with uuid ossp-uuid) \ + "$(has_version ~dev-db/postgresql-base-${PV}[nls] && use_enable nls nls "$(wanted_languages)")" +} + +src_compile() { + local bd + for bd in . contrib $(use xml && echo contrib/xml2) ; do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake -C $bd -j1 || die "emake in $bd failed" + done +} + +src_install() { + if use perl ; then + mv -f "${S}/src/pl/plperl/GNUmakefile" "${S}/src/pl/plperl/GNUmakefile_orig" + sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \ + "${S}/src/pl/plperl/GNUmakefile_orig" > "${S}/src/pl/plperl/GNUmakefile" + fi + + local bd + for bd in . contrib $(use xml && echo contrib/xml2) ; do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake install -C $bd -j1 DESTDIR="${D}" || die "emake install in $bd failed" + done + + rm -r "${ED}/usr/share/postgresql-${SLOT}/man/man7/" "${ED}/usr/share/doc/postgresql-${SLOT}/html" + rm "${ED}"/usr/share/postgresql-${SLOT}/man/man1/{clusterdb,create{db,lang,user},drop{db,lang,user},ecpg,pg_{config,dump,dumpall,restore},psql,reindexdb,vacuumdb}.1 + + dodoc README HISTORY doc/{README.*,TODO,bug.template} + + dodir /etc/eselect/postgresql/slots/${SLOT} + echo "postgres_ebuilds=\"\${postgres_ebuilds} ${PF}\"" \ + > "${ED}/etc/eselect/postgresql/slots/${SLOT}/server" + + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}"/postgresql.confd + newconfd "${WORKDIR}"/postgresql.confd postgresql-${SLOT} || die "Inserting conf.d file failed" + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}"/postgresql.init + newinitd "${WORKDIR}"/postgresql.init postgresql-${SLOT} || die "Inserting init.d file failed" + + use pam && pamd_mimic system-auth postgresql auth account session + + keepdir /var/run/postgresql + fperms 0770 /var/run/postgresql + use prefix || fowners postgres:postgres /var/run/postgresql +} + +pkg_postinst() { + postgresql-config update + + elog "The time stamp format is 64 bit integers now. If you upgrade from older" + elog "databases, this may force you to either do a dump and reload of enable" + elog "pg_legacytimestamp until you find time to do so. If the database can't start" + elog "please try enabling pg_legacytimestamp and rebuild." + elog + elog "The Unix-domain socket is located in:" + elog " ${EROOT%/}/var/run/postgresql/" + elog + elog "If you have users and/or services that you would like to utilize the socket," + elog "you must add them to the 'postgres' system group:" + elog " usermod -a -G postgres " + elog + elog "Before initializing the database, you may want to edit PG_INITDB_OPTS so that" + elog "it contains your preferred locale and character encoding in:" + elog " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + elog + elog "Then, execute the following command to setup the initial database" + elog "environment:" + elog " emerge --config =${CATEGORY}/${PF}" +} + +pkg_postrm() { + postgresql-config update +} + +pkg_config() { + [[ -f ${EROOT%/}/etc/conf.d/postgresql-${SLOT} ]] && source "${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + [[ -z ${PGDATA} ]] && PGDATA="${EROOT%/}/etc/postgresql-${SLOT}/" + [[ -z ${DATA_DIR} ]] && DATA_DIR="${EROOT%/}/var/lib/postgresql/${SLOT}/data" + + # environment.bz2 may not contain the same locale as the current system + # locale. Unset and source from the current system locale. + if [[ -f ${EROOT%/}/etc/env.d/02locale ]] ; then + unset LANG + unset LC_CTYPE + unset LC_NUMERIC + unset LC_TIME + unset LC_COLLATE + unset LC_MONETARY + unset LC_MESSAGES + unset LC_ALL + source "${EROOT%/}/etc/env.d/02locale" + [[ -n ${LANG} ]] && export LANG + [[ -n ${LC_CTYPE} ]] && export LC_CTYPE + [[ -n ${LC_NUMERIC} ]] && export LC_NUMERIC + [[ -n ${LC_TIME} ]] && export LC_TIME + [[ -n ${LC_COLLATE} ]] && export LC_COLLATE + [[ -n ${LC_MONETARY} ]] && export LC_MONETARY + [[ -n ${LC_MESSAGES} ]] && export LC_MESSAGES + [[ -n ${LC_ALL} ]] && export LC_ALL + fi + + einfo "You can modify the paths and options passed to initdb by editing:" + einfo " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + einfo + einfo "Information on options that can be passed to initdb are found at:" + einfo " http://www.postgresql.org/docs/${SLOT}/static/creating-cluster.html" + einfo " http://www.postgresql.org/docs/${SLOT}/static/app-initdb.html" + einfo + einfo "PG_INITDB_OPTS is currently set to:" + if [[ -z ${PG_INITDB_OPTS} ]] ; then + einfo " (none)" + else + einfo " ${PG_INITDB_OPTS}" + fi + einfo + einfo "Configuration files will be installed to:" + einfo " ${PGDATA}" + einfo + einfo "The database cluster will be created in:" + einfo " ${DATA_DIR}" + einfo + while [[ $correct != "true" ]] ; do + einfo "Are you ready to continue? (y/n)" + read answer + if [[ $answer =~ ^[Yy]([Ee][Ss])?$ ]] ; then + correct="true" + elif [[ $answer =~ ^[Nn]([Oo])?$ ]] ; then + die "Aborting initialization." + else + echo "Answer not recognized" + fi + done + + if [[ -n "$(ls -A ${DATA_DIR} 2> /dev/null)" ]] ; then + eerror "The given directory, '${DATA_DIR}', is not empty." + eerror "Modify DATA_DIR to point to an empty directory." + die "${DATA_DIR} is not empty." + fi + + [[ -z ${PG_MAX_CONNECTIONS} ]] && PG_MAX_CONNECTIONS=128 + einfo "Checking system parameters..." + + if ! use kernel_linux ; then + einfo "Skipped." + einfo " Tests not supported on this OS (yet)" + else + if [[ -z ${SKIP_SYSTEM_TESTS} ]] ; then + einfo "Checking whether your system supports at least ${PG_MAX_CONNECTIONS} connections..." + + local SEMMSL=$(sysctl -n kernel.sem | cut -f1) + local SEMMNS=$(sysctl -n kernel.sem | cut -f2) + local SEMMNI=$(sysctl -n kernel.sem | cut -f4) + local SHMMAX=$(sysctl -n kernel.shmmax) + + local SEMMSL_MIN=17 + local SEMMNS_MIN=$(( ( ${PG_MAX_CONNECTIONS}/16 ) * 17 )) + local SEMMNI_MIN=$(( ( ${PG_MAX_CONNECTIONS}+15 ) / 16 )) + local SHMMAX_MIN=$(( 500000 + ( 30600 * ${PG_MAX_CONNECTIONS} ) )) + + for p in SEMMSL SEMMNS SEMMNI SHMMAX ; do + if [[ $(eval echo \$$p) -lt $(eval echo \$${p}_MIN) ]] ; then + eerror "The value for ${p} $(eval echo \$$p) is below the recommended value $(eval echo \$${p}_MIN)" + eerror "You have now several options:" + eerror " - Change the mentioned system parameter" + eerror " - Lower the number of max.connections by setting PG_MAX_CONNECTIONS to a" + eerror " value lower than ${PG_MAX_CONNECTIONS}" + eerror " - Set SKIP_SYSTEM_TESTS in case you want to ignore this test completely" + eerror "More information can be found here:" + eerror " http://www.postgresql.org/docs/${SLOT}/static/kernel-resources.html" + die "System test failed." + fi + done + einfo "Passed." + else + ewarn "SKIP_SYSTEM_TESTS set, so skipping." + fi + fi + + if [[ ${EUID} == 0 ]] ; then + einfo "Creating the data directory ..." + mkdir -p "${DATA_DIR}" + chown -Rf postgres:postgres "${DATA_DIR}" + chmod 0700 "${DATA_DIR}" + fi + + einfo "Initializing the database ..." + if [[ ${EUID} == 0 ]] ; then + su postgres -c "${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -D \"${DATA_DIR}\" ${PG_INITDB_OPTS}" + else + "${EROOT%/}"/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -U postgres -D "${DATA_DIR}" ${PG_INITDB_OPTS} + fi + mv "${DATA_DIR%/}"/*.conf "${PGDATA}" + + einfo "The autovacuum function, which was in contrib, has been moved to the main" + einfo "PostgreSQL functions starting with 8.1, and starting with 8.4 is now enabled by" + einfo "default. You can disable it in the cluster's:" + einfo " ${PGDATA%/}/postgresql.conf" + einfo + einfo "The PostgreSQL server, by default, will log events to:" + einfo " ${DATA_DIR%/}/postmaster.log" + einfo + if use prefix ; then + einfo "The location of the configuration files have moved to:" + einfo " ${PGDATA}" + einfo + einfo "To start the server:" + einfo " pg_ctl start -D ${DATA_DIR} -o '-D ${PGDATA} --data-directory=${DATA_DIR}'" + einfo + einfo "To stop:" + einfo " pg_ctl stop -D ${DATA_DIR}" + einfo + einfo "Or move the configuration files back:" + einfo " mv ${PGDATA}*.conf ${DATA_DIR}" + else + einfo "You should use the '${EROOT%/}/etc/init.d/postgresql-${SLOT}' script to run PostgreSQL" + einfo "instead of 'pg_ctl'." + fi +} + +src_test() { + einfo ">>> Test phase [check]: ${CATEGORY}/${PF}" + + if [[ ${UID} != 0 ]] ; then + emake check || die "Make check failed. See above for details." + + einfo "If you think other tests besides the regression tests are necessary, please" + einfo "submit a bug including a patch for this ebuild to enable them." + else + ewarn "Tests cannot be run as root. Skipping." + ewarn "HINT: FEATURES=\"userpriv\"" + fi +} diff --git a/dev-db/postgresql-server/postgresql-server-9.0.4-r2.ebuild b/dev-db/postgresql-server/postgresql-server-9.0.4-r2.ebuild new file mode 100644 index 000000000000..c84148613b09 --- /dev/null +++ b/dev-db/postgresql-server/postgresql-server-9.0.4-r2.ebuild @@ -0,0 +1,327 @@ +# Copyright 1999-2011 Gentoo Foundation +# Distributed under the terms of the GNU General Public License v2 +# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/postgresql-server-9.0.4-r2.ebuild,v 1.1 2011/08/02 02:13:49 titanofold Exp $ + +EAPI="3" +PYTHON_DEPEND="python? 2" + +WANT_AUTOMAKE="none" +inherit autotools eutils multilib pam prefix python versionator + +SLOT="$(get_version_component_range 1-2)" + +KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~s390 ~sh ~sparc ~x86 ~x86-fbsd ~ppc-macos ~x86-solaris" + +DESCRIPTION="PostgreSQL server" +HOMEPAGE="http://www.postgresql.org/" +SRC_URI="mirror://postgresql/source/v${PV}/postgresql-${PV}.tar.bz2 + http://dev.gentoo.org/~titanofold/postgresql-patches-${SLOT}-r2.tbz2 + http://dev.gentoo.org/~titanofold/postgresql-initscript-1.2.tbz2" +LICENSE="POSTGRESQL" + +S="${WORKDIR}/postgresql-${PV}" + +LINGUAS="af cs de en es fa fr hr hu it ko nb pl pt_BR ro ru sk sl sv tr zh_CN zh_TW" +IUSE="doc kernel_linux nls pam perl -pg_legacytimestamp python selinux tcl uuid xml" + +for lingua in ${LINGUAS}; do + IUSE+=" linguas_${lingua}" +done + +wanted_languages() { + local enable_langs + + for lingua in ${LINGUAS} ; do + use linguas_${lingua} && enable_langs+="${lingua} " + done + + echo -n ${enable_langs} +} + +RDEPEND="~dev-db/postgresql-base-${PV}:${SLOT}[pam?,pg_legacytimestamp=,nls=] + perl? ( >=dev-lang/perl-5.8 ) + selinux? ( sec-policy/selinux-postgresql ) + tcl? ( >=dev-lang/tcl-8 ) + uuid? ( dev-libs/ossp-uuid ) + xml? ( dev-libs/libxml2 dev-libs/libxslt )" + +DEPEND="${RDEPEND} + sys-devel/flex + xml? ( dev-util/pkgconfig )" + +PDEPEND="doc? ( ~dev-db/postgresql-docs-${PV} )" + +pkg_setup() { + enewgroup postgres 70 + enewuser postgres 70 /bin/bash /var/lib/postgresql postgres + + use python && python_set_active_version 2 +} + +src_prepare() { + epatch "${WORKDIR}/autoconf.patch" "${FILESDIR}/bool.patch" \ + "${FILESDIR}/pg_ctl-exit-status.patch" "${WORKDIR}/server.patch" + + eprefixify src/include/pg_config_manual.h + + if use test ; then + epatch "${WORKDIR}/regress.patch" + sed -e "s|@SOCKETDIR@|${T}|g" -i src/test/regress/pg_regress{,_main}.c + sed -e "s|/no/such/location|${S}/src/test/regress/tmp_check/no/such/location|g" \ + -i src/test/regress/{input,output}/tablespace.source + else + echo "all install:" > "${S}/src/test/regress/GNUmakefile" + fi + + eautoconf +} + +src_configure() { + # eval is needed to get along with pg_config quotation of space-rich entities. + eval econf "$(${EPREFIX%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --configure)" \ + --with-includes="${EPREFIX%/}/usr/include/postgresql-${SLOT}/" \ + --with-libraries="${EPREFIX%/}/usr/$(get_libdir)/postgresql-${SLOT}/$(get_libdir)" \ + --with-system-tzdata="${EPREFIX%/}/usr/share/zoneinfo" \ + $(use_with perl) \ + $(use_with python) \ + $(use_with tcl) \ + $(use_with xml libxml) \ + $(use_with xml libxslt) \ + $(use_with uuid ossp-uuid) \ + "$(use_enable nls nls "$(wanted_languages)")" +} + +src_compile() { + local bd + for bd in . contrib $(use xml && echo contrib/xml2); do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake -C $bd -j1 || die "emake in $bd failed" + done +} + +src_install() { + if use perl ; then + mv -f "${S}/src/pl/plperl/GNUmakefile" "${S}/src/pl/plperl/GNUmakefile_orig" + sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \ + "${S}/src/pl/plperl/GNUmakefile_orig" > "${S}/src/pl/plperl/GNUmakefile" + fi + + local bd + for bd in . contrib $(use xml && echo contrib/xml2) ; do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake install -C $bd -j1 DESTDIR="${D}" || die "emake install in $bd failed" + done + + dodir /usr/share/postgresql-${SLOT}/man/man1/ + cp "${S}"/doc/src/sgml/man1/{initdb,pg_controldata,pg_ctl,pg_resetxlog,post{gres,master}}.1 \ + "${ED}"/usr/share/postgresql-${SLOT}/man/man1/ || die + + dodoc README HISTORY doc/{README.*,TODO,bug.template} + + dodir /etc/eselect/postgresql/slots/${SLOT} + echo "postgres_ebuilds=\"\${postgres_ebuilds} ${PF}\"" \ + > "${ED}/etc/eselect/postgresql/slots/${SLOT}/server" + + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}/postgresql.confd" + newconfd "${WORKDIR}/postgresql.confd" postgresql-${SLOT} || die "Inserting conf.d file failed" + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}/postgresql.init" + newinitd "${WORKDIR}/postgresql.init" postgresql-${SLOT} || die "Inserting init.d file failed" + + use pam && pamd_mimic system-auth postgresql auth account session + + keepdir /var/run/postgresql + fperms 0770 /var/run/postgresql + use prefix || fowners postgres:postgres /var/run/postgresql +} + +pkg_postinst() { + postgresql-config update + + elog "The time stamp format is 64 bit integers now. If you upgrade from older" + elog "databases, this may force you to either do a dump and reload or enable" + elog "pg_legacytimestamp until you find time to do so. If the database cannot start" + elog "please try enabling pg_legacytimestamp and rebuild." + elog + elog "The Unix-domain socket is located in:" + elog " ${EROOT%/}/var/run/postgresql/" + elog + elog "If you have users and/or services that you would like to utilize the socket," + elog "you must add them to the 'postgres' system group:" + elog " usermod -a -G postgres " + elog + elog "Before initializing the database, you may want to edit PG_INITDB_OPTS so that" + elog "it contains your preferred locale in:" + elog " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + elog + elog "Then, execute the following command to setup the initial database" + elog "environment:" + elog " emerge --config =${CATEGORY}/${PF}" +} + +pkg_postrm() { + postgresql-config update +} + +pkg_config() { + [[ -f ${EROOT%/}/etc/conf.d/postgresql-${SLOT} ]] && source "${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + [[ -z ${PGDATA} ]] && PGDATA="${EROOT%/}/etc/postgresql-${SLOT}/" + [[ -z ${DATA_DIR} ]] && DATA_DIR="${EROOT%/}/var/lib/postgresql/${SLOT}/data" + + # environment.bz2 may not contain the same locale as the current system + # locale. Unset and source from the current system locale. + if [[ -f ${EROOT%/}/etc/env.d/02locale ]] ; then + unset LANG + unset LC_CTYPE + unset LC_NUMERIC + unset LC_TIME + unset LC_COLLATE + unset LC_MONETARY + unset LC_MESSAGES + unset LC_ALL + source "${EROOT%/}/etc/env.d/02locale" + [[ -n ${LANG} ]] && export LANG + [[ -n ${LC_CTYPE} ]] && export LC_CTYPE + [[ -n ${LC_NUMERIC} ]] && export LC_NUMERIC + [[ -n ${LC_TIME} ]] && export LC_TIME + [[ -n ${LC_COLLATE} ]] && export LC_COLLATE + [[ -n ${LC_MONETARY} ]] && export LC_MONETARY + [[ -n ${LC_MESSAGES} ]] && export LC_MESSAGES + [[ -n ${LC_ALL} ]] && export LC_ALL + fi + + einfo "You can modify the paths and options passed to initdb by editing:" + einfo " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + einfo + einfo "Information on options that can be passed to initdb are found at:" + einfo " http://www.postgresql.org/docs/${SLOT}/static/creating-cluster.html" + einfo " http://www.postgresql.org/docs/${SLOT}/static/app-initdb.html" + einfo + einfo "PG_INITDB_OPTS is currently set to:" + if [[ -z "${PG_INITDB_OPTS}" ]] ; then + einfo " (none)" + else + einfo " ${PG_INITDB_OPTS}" + fi + einfo + einfo "Configuration files will be installed to:" + einfo " ${PGDATA}" + einfo + einfo "The database cluster will be created in:" + einfo " ${DATA_DIR}" + einfo + while [[ $correct != "true" ]] ; do + einfo "Are you ready to continue? (y/n)" + read answer + if [[ $answer =~ ^[Yy]([Ee][Ss])?$ ]] ; then + correct="true" + elif [[ $answer =~ ^[Nn]([Oo])?$ ]] ; then + die "Aborting initialization." + else + echo "Answer not recognized" + fi + done + + if [[ -n "$(ls -A ${DATA_DIR} 2> /dev/null)" ]] ; then + eerror "The given directory, '${DATA_DIR}', is not empty." + eerror "Modify DATA_DIR to point to an empty directory." + die "${DATA_DIR} is not empty." + fi + + [[ -z ${PG_MAX_CONNECTIONS} ]] && PG_MAX_CONNECTIONS=128 + einfo "Checking system parameters..." + + if ! use kernel_linux ; then + einfo "Skipped." + einfo " Tests not supported on this OS (yet)" + else + if [[ -z ${SKIP_SYSTEM_TESTS} ]] ; then + einfo "Checking whether your system supports at least ${PG_MAX_CONNECTIONS} connections..." + + local SEMMSL=$(sysctl -n kernel.sem | cut -f1) + local SEMMNS=$(sysctl -n kernel.sem | cut -f2) + local SEMMNI=$(sysctl -n kernel.sem | cut -f4) + local SHMMAX=$(sysctl -n kernel.shmmax) + + local SEMMSL_MIN=17 + local SEMMNS_MIN=$(( ( ${PG_MAX_CONNECTIONS}/16 ) * 17 )) + local SEMMNI_MIN=$(( ( ${PG_MAX_CONNECTIONS}+15 ) / 16 )) + local SHMMAX_MIN=$(( 500000 + ( 30600 * ${PG_MAX_CONNECTIONS} ) )) + + for p in SEMMSL SEMMNS SEMMNI SHMMAX ; do + if [[ $(eval echo \$$p) -lt $(eval echo \$${p}_MIN) ]] ; then + eerror "The value for ${p} $(eval echo \$$p) is below the recommended value $(eval echo \$${p}_MIN)" + eerror "You have now several options:" + eerror " - Change the mentioned system parameter" + eerror " - Lower the number of max connections by setting PG_MAX_CONNECTIONS to a" + eerror " value lower than ${PG_MAX_CONNECTIONS}" + eerror " - Set SKIP_SYSTEM_TESTS in case you want to ignore this test completely" + eerror "More information can be found here:" + eerror " http://www.postgresql.org/docs/${SLOT}/static/kernel-resources.html" + die "System test failed." + fi + done + einfo "Passed." + else + ewarn "SKIP_SYSTEM_TESTS set, so skipping." + fi + fi + + if [[ ${EUID} == 0 ]] ; then + einfo "Creating the data directory ..." + mkdir -p "${DATA_DIR}" + chown -Rf postgres:postgres "${DATA_DIR}" + chmod 0700 "${DATA_DIR}" + fi + + einfo "Initializing the database ..." + + if [[ ${EUID} == 0 ]] ; then + su postgres \ + -c "${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -D '${DATA_DIR}' -L '${EROOT%/}/usr/share/postgresql-${SLOT}/' ${PG_INITDB_OPTS}" + else + "${EROOT%/}"/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb \ + -U postgres -D "${DATA_DIR}" \ + -L "${EROOT%/}/usr/share/postgresql-${SLOT}/" ${PG_INITDB_OPTS} + fi + + mv "${DATA_DIR%/}"/*.conf "${PGDATA}" + + einfo "The autovacuum function, which was in contrib, has been moved to the main" + einfo "PostgreSQL functions starting with 8.1, and starting with 8.4 is now enabled" + einfo "by default. You can disable it in the cluster's:" + einfo " ${PGDATA%/}/postgresql.conf" + einfo + einfo "The PostgreSQL server, by default, will log events to:" + einfo " ${DATA_DIR%/}/postmaster.log" + einfo + if use prefix ; then + einfo "The location of the configuration files have moved to:" + einfo " ${PGDATA}" + einfo + einfo "To start the server:" + einfo " pg_ctl start -D ${DATA_DIR} -o '-D ${PGDATA} --data-directory=${DATA_DIR}'" + einfo + einfo "To stop:" + einfo " pg_ctl stop -D ${DATA_DIR}" + einfo + einfo "Or move the configuration files back:" + einfo " mv ${PGDATA}*.conf ${DATA_DIR}" + else + einfo "You should use the '${EROOT%/}/etc/init.d/postgresql-${SLOT}' script to run PostgreSQL" + einfo "instead of 'pg_ctl'." + fi +} + +src_test() { + einfo ">>> Test phase [check]: ${CATEGORY}/${PF}" + + if [[ ${UID} != 0 ]] ; then + emake check || die "Make check failed. See above for details." + + einfo "If you think other tests besides the regression tests are necessary, please" + einfo "submit a bug including a patch for this ebuild to enable them." + else + ewarn "Tests cannot be run as root. Skipping." + ewarn "HINT: FEATURES=\"userpriv\"" + fi +} diff --git a/dev-db/postgresql-server/postgresql-server-9.1_beta3-r1.ebuild b/dev-db/postgresql-server/postgresql-server-9.1_beta3-r1.ebuild new file mode 100644 index 000000000000..c744f19328b2 --- /dev/null +++ b/dev-db/postgresql-server/postgresql-server-9.1_beta3-r1.ebuild @@ -0,0 +1,320 @@ +# Copyright 1999-2011 Gentoo Foundation +# Distributed under the terms of the GNU General Public License v2 +# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/postgresql-server-9.1_beta3-r1.ebuild,v 1.1 2011/08/02 02:13:49 titanofold Exp $ + +EAPI="3" +PYTHON_DEPEND="python? 2" + +WANT_AUTOMAKE="none" +inherit autotools eutils flag-o-matic multilib pam prefix python versionator + +KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~s390 ~sh ~sparc ~x86 ~x86-fbsd ~ppc-macos ~x86-solaris" + +# Upstream doesn't have an underscore in the file name +MY_PV=${PV/_/} + +DESCRIPTION="PostgreSQL server" +HOMEPAGE="http://www.postgresql.org/" +SRC_URI="mirror://postgresql/source/v${MY_PV}/postgresql-${MY_PV}.tar.bz2 + http://dev.gentoo.org/~titanofold/postgresql-patches-${MY_PV}-r1.tbz2 + http://dev.gentoo.org/~titanofold/postgresql-initscript-1.2.tbz2" +LICENSE="POSTGRESQL" + +S="${WORKDIR}/postgresql-${MY_PV}" +SLOT="$(get_version_component_range 1-2)" + +LINGUAS="af cs de en es fa fr hr hu it ko nb pl pt_BR ro ru sk sl sv tr zh_CN zh_TW" +IUSE="doc kernel_linux nls pam perl -pg_legacytimestamp python selinux tcl uuid xml" + +for lingua in ${LINGUAS}; do + IUSE+=" linguas_${lingua}" +done + +wanted_languages() { + local enable_langs + + for lingua in ${LINGUAS} ; do + use linguas_${lingua} && enable_langs+="${lingua} " + done + + echo -n ${enable_langs} +} + +RDEPEND="~dev-db/postgresql-base-${PV}:${SLOT}[pam?,pg_legacytimestamp=,nls=] + perl? ( >=dev-lang/perl-5.8 ) + selinux? ( sec-policy/selinux-postgresql ) + tcl? ( >=dev-lang/tcl-8 ) + uuid? ( dev-libs/ossp-uuid ) + xml? ( dev-libs/libxml2 dev-libs/libxslt )" +DEPEND="${RDEPEND} + sys-devel/flex + xml? ( dev-util/pkgconfig )" +PDEPEND="doc? ( ~dev-db/postgresql-docs-${PV} )" + +pkg_setup() { + enewgroup postgres 70 + enewuser postgres 70 /bin/bash /var/lib/postgresql postgres + + use python && python_set_active_version 2 +} + +src_prepare() { + epatch "${WORKDIR}/autoconf.patch" "${WORKDIR}/bool.patch" \ + "${WORKDIR}/pg_ctl-exit-status.patch" "${WORKDIR}/server.patch" + + eprefixify src/include/pg_config_manual.h + + if use test ; then + epatch "${WORKDIR}/regress.patch" + sed -e "s|@SOCKETDIR@|${T}|g" -i src/test/regress/pg_regress{,_main}.c + sed -e "s|/no/such/location|${S}/src/test/regress/tmp_check/no/such/location|g" -i src/test/regress/{input,output}/tablespace.source + else + echo "all install:" > "${S}/src/test/regress/GNUmakefile" + fi + + eautoconf +} + +src_configure() { + case ${CHOST} in + *-darwin*|*-solaris*) + use nls && append-libs intl + ;; + esac + + local PO="${EPREFIX%/}" + + # eval is needed to get along with pg_config quotation of space-rich entities. + eval econf "$(${PO}/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --configure)" \ + $(use_with perl) \ + $(use_with python) \ + $(use_with tcl) \ + $(use_with xml libxml) \ + $(use_with xml libxslt) \ + $(use_with uuid ossp-uuid) \ + --with-system-tzdata="${PO}/usr/share/zoneinfo" \ + --with-includes="${PO}/usr/include/postgresql-${SLOT}/" \ + --with-libraries="${PO}/usr/$(get_libdir)/postgresql-${SLOT}/$(get_libdir)" \ + "$(use_enable nls nls "$(wanted_languages)")" +} + +src_compile() { + local bd + for bd in . contrib $(use xml && echo contrib/xml2); do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake -C $bd || die "emake in $bd failed" + done +} + +src_install() { + if use perl ; then + mv -f "${S}/src/pl/plperl/GNUmakefile" "${S}/src/pl/plperl/GNUmakefile_orig" + sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \ + "${S}/src/pl/plperl/GNUmakefile_orig" > "${S}/src/pl/plperl/GNUmakefile" + fi + + local bd + for bd in . contrib $(use xml && echo contrib/xml2) ; do + PATH="${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \ + emake install -C $bd DESTDIR="${D}" || die "emake install in $bd failed" + done + + dodoc README HISTORY doc/{README.*,TODO,bug.template} + + dodir /etc/eselect/postgresql/slots/${SLOT} + echo "postgres_ebuilds=\"\${postgres_ebuilds} ${PF}\"" > \ + "${ED}/etc/eselect/postgresql/slots/${SLOT}/server" + + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}"/postgresql.confd + newconfd "${WORKDIR}/postgresql.confd" postgresql-${SLOT} || die "Inserting conf failed" + sed -e "s/@SLOT@/${SLOT}/g" -i "${WORKDIR}"/postgresql.init + newinitd "${WORKDIR}/postgresql.init" postgresql-${SLOT} || die "Inserting conf failed" + + use pam && pamd_mimic system-auth postgresql auth account session + + keepdir /var/run/postgresql + fperms 0770 /var/run/postgresql + use prefix || fowners postgres:postgres /var/run/postgresql +} + +pkg_postinst() { + postgresql-config update + + elog "The Unix-domain socket is located in:" + elog " ${EROOT%/}/var/run/postgresql/" + elog + elog "If you have users and/or services that you would like to utilize the socket," + elog "you must add them to the 'postgres' system group:" + elog " usermod -a -G postgres " + elog + elog "Before initializing the database, you may want to edit PG_INITDB_OPTS so that" + elog "it contains your preferred locale in:" + elog " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + elog + elog "Then, execute the following command to setup the initial database" + elog "environment:" + elog " emerge --config =${CATEGORY}/${PF}" +} + +pkg_postrm() { + postgresql-config update +} + +pkg_config() { + [[ -f "${EROOT%/}/etc/conf.d/postgresql-${SLOT}" ]] && source "${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + [[ -z "${PGDATA}" ]] && PGDATA="${EROOT%/}/etc/postgresql-${SLOT}/" + [[ -z "${DATA_DIR}" ]] && DATA_DIR="${EROOT%/}/var/lib/postgresql/${SLOT}/data" + + # environment.bz2 may not contain the same locale as the current system + # locale. Unset and source from the current system locale. + if [ -f "${EROOT%/}/etc/env.d/02locale" ]; then + unset LANG + unset LC_CTYPE + unset LC_NUMERIC + unset LC_TIME + unset LC_COLLATE + unset LC_MONETARY + unset LC_MESSAGES + unset LC_ALL + source "${EROOT%/}/etc/env.d/02locale" + [ -n "${LANG}" ] && export LANG + [ -n "${LC_CTYPE}" ] && export LC_CTYPE + [ -n "${LC_NUMERIC}" ] && export LC_NUMERIC + [ -n "${LC_TIME}" ] && export LC_TIME + [ -n "${LC_COLLATE}" ] && export LC_COLLATE + [ -n "${LC_MONETARY}" ] && export LC_MONETARY + [ -n "${LC_MESSAGES}" ] && export LC_MESSAGES + [ -n "${LC_ALL}" ] && export LC_ALL + fi + + einfo "You can modify the paths and options passed to initdb by editing:" + einfo " ${EROOT%/}/etc/conf.d/postgresql-${SLOT}" + einfo + einfo "Information on options that can be passed to initdb are found at:" + einfo " http://www.postgresql.org/docs/${SLOT}/static/creating-cluster.html" + einfo " http://www.postgresql.org/docs/${SLOT}/static/app-initdb.html" + einfo + einfo "PG_INITDB_OPTS is currently set to:" + if [[ -z "${PG_INITDB_OPTS}" ]] ; then + einfo " (none)" + else + einfo " ${PG_INITDB_OPTS}" + fi + einfo + einfo "Configuration files will be installed to:" + einfo " ${PGDATA}" + einfo + einfo "The database cluster will be created in:" + einfo " ${DATA_DIR}" + einfo + while [ "$correct" != "true" ] ; do + einfo "Are you ready to continue? (y/n)" + read answer + if [[ $answer =~ ^[Yy]([Ee][Ss])?$ ]] ; then + correct="true" + elif [[ $answer =~ ^[Nn]([Oo])?$ ]] ; then + die "Aborting initialization." + else + echo "Answer not recognized" + fi + done + + if [ -n "$(ls -A ${DATA_DIR} 2> /dev/null)" ] ; then + eerror "The given directory, '${DATA_DIR}', is not empty." + eerror "Modify DATA_DIR to point to an empty directory." + die "${DATA_DIR} is not empty." + fi + + [ -z "${PG_MAX_CONNECTIONS}" ] && PG_MAX_CONNECTIONS="128" + einfo "Checking system parameters..." + + if ! use kernel_linux ; then + einfo "Skipped." + einfo " Tests not supported on this OS (yet)" + else + if [ -z ${SKIP_SYSTEM_TESTS} ] ; then + einfo "Checking whether your system supports at least ${PG_MAX_CONNECTIONS} connections..." + + local SEMMSL=$(sysctl -n kernel.sem | cut -f1) + local SEMMNS=$(sysctl -n kernel.sem | cut -f2) + local SEMMNI=$(sysctl -n kernel.sem | cut -f4) + local SHMMAX=$(sysctl -n kernel.shmmax) + + local SEMMSL_MIN=17 + local SEMMNS_MIN=$(( ( ${PG_MAX_CONNECTIONS}/16 ) * 17 )) + local SEMMNI_MIN=$(( ( ${PG_MAX_CONNECTIONS}+15 ) / 16 )) + local SHMMAX_MIN=$(( 500000 + ( 30600 * ${PG_MAX_CONNECTIONS} ) )) + + for p in SEMMSL SEMMNS SEMMNI SHMMAX ; do + if [ $(eval echo \$$p) -lt $(eval echo \$${p}_MIN) ] ; then + eerror "The value for ${p} $(eval echo \$$p) is below the recommended value $(eval echo \$${p}_MIN)" + eerror "You have now several options:" + eerror " - Change the mentioned system parameter" + eerror " - Lower the number of max.connections by setting PG_MAX_CONNECTIONS to a" + eerror " value lower than ${PG_MAX_CONNECTIONS}" + eerror " - Set SKIP_SYSTEM_TESTS in case you want to ignore this test completely" + eerror "More information can be found here:" + eerror " http://www.postgresql.org/docs/${SLOT}/static/kernel-resources.html" + die "System test failed." + fi + done + einfo "Passed." + else + ewarn "SKIP_SYSTEM_TESTS set, so skipping." + fi + fi + + einfo "Creating the data directory ..." + if [[ ${EUID} == 0 ]] ; then + mkdir -p "${DATA_DIR}" + chown -Rf postgres:postgres "${DATA_DIR}" + chmod 0700 "${DATA_DIR}" + fi + + einfo "Initializing the database ..." + + if [[ ${EUID} == 0 ]] ; then + su postgres -c "${EROOT%/}/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -D \"${DATA_DIR}\" ${PG_INITDB_OPTS}" + else + "${EROOT%/}"/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb -U postgres -D "${DATA_DIR}" ${PG_INITDB_OPTS} + fi + + mv "${DATA_DIR%/}"/*.conf "${PGDATA}" + + einfo "The autovacuum function, which was in contrib, has been moved to the main" + einfo "PostgreSQL functions starting with 8.1, and starting with 8.4 is now enabled" + einfo "by default. You can disable it in the cluster's:" + einfo " ${PGDATA%/}/postgresql.conf" + einfo + einfo "The PostgreSQL server, by default, will log events to:" + einfo " ${DATA_DIR%/}/postmaster.log" + einfo + if use prefix ; then + einfo "The location of the configuration files have moved to:" + einfo " ${PGDATA}" + einfo "To start the server:" + einfo " pg_ctl start -D ${DATA_DIR} -o '-D ${PGDATA} --data-directory=${DATA_DIR}'" + einfo "To stop:" + einfo " pg_ctl stop -D ${DATA_DIR}" + einfo + einfo "Or move the configuration files back:" + einfo "mv ${PGDATA}*.conf ${DATA_DIR}" + else + einfo "You should use the '${EROOT%/}/etc/init.d/postgresql-${SLOT}' script to run PostgreSQL" + einfo "instead of 'pg_ctl'." + fi +} + +src_test() { + einfo ">>> Test phase [check]: ${CATEGORY}/${PF}" + + if [ ${UID} -ne 0 ] ; then + emake -j1 check || die "Make check failed. See above for details." + + einfo "If you think other tests besides the regression tests are necessary, please" + einfo "submit a bug including a patch for this ebuild to enable them." + else + ewarn "Tests cannot be run as root. Skipping." + ewarn "HINT: FEATURES=\"userpriv\"" + fi +} -- 2.26.2