I have set up an ebuild for pgpool-II, the newer postgresql pooling server. This is a different package than the one already in the tree (dev-db/pgpool). This ebuild is for the latest version (1.2.1). Works fine for me on amd64. Reproducible: Always Portage 2.1.3.9 (default-linux/amd64/2007.0, gcc-4.1.2, glibc-2.5-r4, 2.6.20-xen-r3 x86_64) ================================================================= System uname: 2.6.20-xen-r3 x86_64 Intel(R) Xeon(TM) CPU 3.00GHz Timestamp of tree: Tue, 25 Sep 2007 03:00:01 +0000 app-shells/bash: 3.2_p17 dev-lang/python: 2.4.4-r5 dev-python/pycrypto: 2.0.1-r6 sys-apps/baselayout: 1.12.9-r2 sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.61-r1 sys-devel/automake: 1.9.6-r2, 1.10 sys-devel/binutils: 2.17-r1 sys-devel/gcc-config: 1.3.16 sys-devel/libtool: 1.5.24 virtual/os-headers: 2.6.21 ACCEPT_KEYWORDS="amd64" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe -march=k8" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -pipe -march=k8" DISTDIR="/usr/portage/distfiles" FEATURES="buildpkg ccache distcc distlocks metadata-transfer pararell-fetch sandbox sfperms strict unmerge-orphans userfetch" GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo" MAKEOPTS="-j4" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="acl amd64 bash-completion berkdb bitmap-fonts cli cracklib crypt cups dri fortran gdbm gpm iconv isdnlog midi mmx mudflap ncurses nls nptl nptlonly openmp pam pcre perl pppd python readline reflection session spl sse sse2 ssl tcpd truetype-fonts type1-fonts unicode vim-syntax xorg zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i810 mach64 mga neomagic nv r128 radeon rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga via vmware voodoo" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Created attachment 133787 [details] Ebuild for pgpool-II, version 1.2.1
Created attachment 133788 [details] init.d file for starting and stopping the service
2.1 is out as of July 25, 2008. http://pgfoundry.org/projects/pgpool/ It would be great if someone stepped up to maintain this.
Created attachment 185614 [details] ebuild for latest version 2.2
I attached an updated ebuild for the latest 2.2. It pulls in the postgresql-base dependency, builds cleanly, installs all config files and starts (when pg itself is running). Stopping doesn't seem to work, which seems to be yet another problem with start-stop-daemon and the pid file. Maybe this helps to get the ball rolling again with PG in Gentoo..
Created attachment 185619 [details] init file with fixed stop function (--exec instead of pid) This init file uses the --exec argument to stop pgpool. I know this is less than optimal since pgpool still writes its pid file and --exec will kill *all* instances (do people run multiple pgpools?), but the written pid file is not null-terminated and I can't make start-stop-daeon use it correctly. If anybody has a better idea (e.g. manual kill -TERM <pid>) I'd love to hear it.
(this is an automated message based on filtering criteria that matched this bug) 'EBUILD' is in the KEYWORDS which should mean that there is a ebuild attached to this bug. This bug is assigned to maintainer-wanted which means that it is not in the main tree. Heuristics show that no Gentoo developer has commented on your ebuild. Hello, The Gentoo Team would like to firstly thank you for your ebuild submission. We also apologize for not being able to accommodate you in a timely manner. There are simply too many new packages. Allow me to use this opportunity to introduce you to Gentoo Sunrise. The sunrise overlay[1] is a overlay for Gentoo which we allow trusted users to commit to and all users can have ebuilds reviewed by Gentoo devs for entry into the overlay. So, the sunrise team is suggesting that you look into this and submit your ebuild to the overlay where even *you* can commit to. =) Because this is a mass message, we are also asking you to be patient with us. We anticipate a large number of requests in a short time. Thanks, On behalf of the Gentoo Sunrise Team, Jeremy. [1]: http://www.gentoo.org/proj/en/sunrise/ [2]: http://overlays.gentoo.org/proj/sunrise/wiki/SunriseFaq
Created attachment 189606 [details] ebuild for 2.2.1 Update for latest 2.2.1. The only change is a small fix for the source dir since pgpool's source directory is only named -major.minor, not -major.minor.micro like the package tarball.
Created attachment 201179 [details] pgpool-II-2.2.3 ebuild changed dev-db/postgresql-base virtual/postgresql-base since we can get by with libpq.
Created attachment 218069 [details] ebuild for pgpool-II 2.3.1 update for version 2.3.1 compile and run successful under ~x86
Created attachment 218077 [details] ebuild for pgpool-II-2.3.1 create directories for log and pid files
Created attachment 218079 [details] init script add log and optional debug arguments
please change the summary of a bug. There is a mistype there causing search no to find this bug by a search querry pgpool
Created attachment 245358 [details] pgpool-II-2.3.3 ebuild new ebuild for pgpool-II-2.3.3
hi, the init script fails with sys-apps/baselayout-1.12.13: # /etc/init.d/pgpool-II start * Starting pgpool-II ... /sbin/start-stop-daemon: invalid option -- '1' Try `/sbin/start-stop-daemon --help' for more information.
Created attachment 248503 [details] working init script the attached init script works for me.
Ebuild i patched for my work in main tree. (dev-db/pgpool2)