From sacadmin Wed Dec 19 09:12:16 2007 Received: from zruty.sfbay.sun.com (zruty [129.146.168.40]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id lBJHCGjO026036; Wed, 19 Dec 2007 09:12:16 -0800 (PST) Received: from zruty.sfbay.sun.com (localhost [127.0.0.1]) by zruty.sfbay.sun.com (8.14.1+Sun/8.14.1) with ESMTP id lBJHCGfA028601; Wed, 19 Dec 2007 09:12:16 -0800 (PST) Received: (from dduvall@localhost) by zruty.sfbay.sun.com (8.14.1+Sun/8.14.1/Submit) id lBJHCGcb028598; Wed, 19 Dec 2007 09:12:16 -0800 (PST) Date: Wed, 19 Dec 2007 09:12:16 -0800 (PST) From: Danek Duvall Message-Id: <200712191712.lBJHCGcb028598@zruty.sfbay.sun.com> To: LSARC-record@sac.sfbay.sun.com Subject: pgBouncer [LSARC/2007/698 FastTrack] Status: RO Content-Length: 547 Template Version: @(#)sac_nextcase 1.64 07/13/07 SMI This information is Copyright 2007 Sun Microsystems 1. Introduction 1.1. Project/Component Working Name: pgBouncer 1.2. Name of Document Author/Supplier: Author: Magnus Mahre 1.3 Date of This Document: 19 December, 2007 4. Technical Description See the case directory for more detail 6. Resources and Schedule 6.4. Steering Committee requested information 6.4.1. Consolidation C-team Name: SFW 6.5. ARC review type: FastTrack 6.6. ARC Exposure: open From danek.duvall@sun.com Mon Feb 4 10:45:46 2008 Received: from sunmail2sca.sfbay.sun.com (sunmail2sca [129.145.155.234]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m14Ijkk2015616 for ; Mon, 4 Feb 2008 10:45:46 -0800 (PST) Received: from nwk-avmta-1.SFBay.Sun.COM (nwk-avmta-1.SFBay.Sun.COM [129.146.11.74]) by sunmail2sca.sfbay.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id m14Ijjqs005413 for <@sunmail2sca.sfbay.sun.com:lsarc-ext@sun.com>; Mon, 4 Feb 2008 10:45:46 -0800 (PST) Received: from pmxchannel-daemon.nwk-avmta-1.sfbay.Sun.COM by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JVQ00C0N9GA2H00@nwk-avmta-1.sfbay.Sun.COM> for lsarc-ext@sun.com (ORCPT lsarc-ext@sun.com); Mon, 04 Feb 2008 10:45:46 -0800 (PST) Received: from dm-sfbay-01.sfbay.sun.com ([129.145.155.118]) by nwk-avmta-1.sfbay.Sun.COM (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JVQ004I89G9KE60@nwk-avmta-1.sfbay.Sun.COM> for lsarc-ext@sun.com (ORCPT lsarc-ext@sun.com); Mon, 04 Feb 2008 10:45:45 -0800 (PST) Received: from zruty.sfbay.sun.com (zruty.SFBay.Sun.COM [129.146.168.40]) by dm-sfbay-01.sfbay.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id m14IjipW038278; Mon, 04 Feb 2008 10:45:44 -0800 (PST) Received: from zruty.sfbay.sun.com (localhost [127.0.0.1]) by zruty.sfbay.sun.com (8.14.2+Sun/8.14.2) with ESMTP id m14Ijiig002520; Mon, 04 Feb 2008 10:45:44 -0800 (PST) Received: (from dduvall@localhost) by zruty.sfbay.sun.com (8.14.2+Sun/8.14.2/Submit) id m14Ijh44002519; Mon, 04 Feb 2008 10:45:43 -0800 (PST) Date: Mon, 04 Feb 2008 10:45:43 -0800 From: Danek Duvall Subject: LSARC 2007/698 pgBouncer To: lsarc-ext@sun.com Cc: magne.mahre@sun.com Message-id: <20080204184543.GA2430@zruty.sfbay.sun.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline X-PMX-Version: 5.2.0.264296 User-Agent: Mutt/1.5.16 (2007-06-27) Status: RO Content-Length: 4874 I'm sponsoring this fast-track for Magne Mahre. I believe this project qualifies for a patch binding, but Magne can confirm whether or not he intends to integrate this into Solaris 10 or earlier. The timer is set for next Monday, February 11, 2008. Danek =========================================================================== Template Version: @(#)onepager.txt 1.31 07/08/08 SMI This information is Copyright 2007 Sun Microsystems 1. Introduction 1.1. Project/Component Working Name: pgBouncer - Provide PostgreSQL connection pooling for Solaris and OpenSolaris 1.2. Name of Document Author/Supplier: Magne Mahre 1.3. Date of This Document: 2007-12-06 1.4. Name of Major Document Customer(s)/Consumer(s): 1.4.1. The Community you expect to review your project: Databases 1.4.2. The ARC(s) you expect to review your project: LSARC 1.5. Email Aliases: 1.5.2. Responsible Engineer: Magne Mahre 1.5.4. Interest List: databases-discuss@sun.com 2. Project Summary 2.1. Project Description: pgBouncer is the most popular connection pool mechanism for PostgreSQL. This project aims to provide pgBouncer as a part of the OpenSolaris distribution(s). 3. Business Summary 3.2. Market/Requester: pgBouncer is a pri. 1 requirement from the Databases P-Team. 4. Technical Description: 4.1. Details: pgBouncer is a part of the PostgreSQL Global Development Team effort, with the bulk of the code supplied by Skype. The product implements a connection pooling front-end for PostgreSQL databases allowing muliple client to share a set of database connections for efficiency purposes. Connection pooling is a feature required by most "Web 2.0" installations, and also by other users. Opening, keeping and closing database connections has a cost in time and cpu/disk resources. To lower this cost, pgBouncer opens and holds a number of database connections that can be used by clients to execute transaction. When the client needs to execute a database transaction, it will direct the query to pgBouncer, which in turn will forward the query to the database using one of the set of pre-opened connections. When the transaction completes, the client will release the connection back to pgBouncer, and it will be available for the next client. The protocol between the client and the pgBouncer instance, and between pgBouncer and the PostgreSQL database is the "PostgreSQL Frontend/Backend Protocol version 3" The protocol is described at http://www.postgresql.org/docs/8.2/static/protocol.html pgBouncer will be installed with SMF capability, defaulted to disabled. The administrator will need to edit the configuration file before enabling the service. No changes are required on the PostgreSQL installation. PgBouncer web page: http://pgfoundry.org/projects/pgbouncer/ 4.5. Interfaces: pgBouncer is a component that strongly depend on a specific version of the PostgreSQL RDBMS. As such, it will be placed in the same directory tree as the corresponding PostgreSQL version. It is an OSS project, not controlled by Sun, so interface stability can't be guaranteed. SUNWpgbouncer_server_pg_82 Uncommitted Package name SUNWpgbouncer_config_pg_82 Uncommitted Package name Installed files: Uncommitted /usr/postgres//bin/pgbouncer /usr/postgres//share/man/man1/pgbouncer.1 /usr/postgres//share/man/man5/pgbouncer.5 /usr/postgres//share/doc/pgbouncer [Directory] /etc/pgbouncer/pgbouncer.ini /var/svc/manifest/application/database/pgbouncer.xml SMF FMRI: Uncommitted svc:/application/database/pgbouncer:default API / Protocol: Uncommitted The PostgreSQL Frontend/Backend Protocol 4.10 Packaging & Delivery SUNWpgbouncer_server_pg_82 The pgBouncer connection pool manager SUNWpgbouncer_config_pg_82 pgBouncer config and service mgmt. 4.12. Dependencies: SUNWpostgr-82-libs libevent-1.3e (PSARC 2007/580) libsocket.so.1 libnsl.so.1 libresolv.so.2 libc.so.1 6. Resources and Schedule: 6.1. Projected Availability: Q3FY08 6.4. Product Approval Committee requested information: 6.4.1. Consolidation or Component Name: SFWNV SFW 6.5. ARC review type: FastTrack From dduvall@zruty.sfbay.sun.com Tue Feb 19 10:10:41 2008 Received: from sunmail5.uk.sun.com (sunmail5.UK.Sun.COM [129.156.85.165]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m1JIAedp021034 for ; Tue, 19 Feb 2008 10:10:41 -0800 (PST) Received: from nwk-avmta-2.sfbay.sun.com (nwk-avmta-2.SFBay.Sun.COM [129.145.155.6]) by sunmail5.uk.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id m1JIAWJm009071; Tue, 19 Feb 2008 18:10:39 GMT Received: from pmxchannel-daemon.nwk-avmta-2.sfbay.sun.com by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JWH0070XZTOJL00@nwk-avmta-2.sfbay.sun.com>; Tue, 19 Feb 2008 10:10:36 -0800 (PST) Received: from zruty.sfbay.sun.com ([129.146.168.40]) by nwk-avmta-2.sfbay.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JWH007AIZTO9600@nwk-avmta-2.sfbay.sun.com>; Tue, 19 Feb 2008 10:10:36 -0800 (PST) Received: from zruty.sfbay.sun.com (localhost [127.0.0.1]) by zruty.sfbay.sun.com (8.14.2+Sun/8.14.2) with ESMTP id m1JIAaUx012437; Tue, 19 Feb 2008 10:10:36 -0800 (PST) Received: (from dduvall@localhost) by zruty.sfbay.sun.com (8.14.2+Sun/8.14.2/Submit) id m1JIAaqK012436; Tue, 19 Feb 2008 10:10:36 -0800 (PST) Date: Tue, 19 Feb 2008 10:10:36 -0800 From: Danek Duvall Subject: Re: LSARC 2007/698 pgBouncer In-reply-to: <20080204184543.GA2430@zruty.sfbay.sun.com> To: lsarc-ext@sun.com Cc: magne.mahre@sun.com Message-id: <20080219181036.GC1369@zruty.sfbay.sun.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline X-PMX-Version: 5.2.0.264296 References: <20080204184543.GA2430@zruty.sfbay.sun.com> User-Agent: Mutt/1.5.16 (2007-06-27) Status: RO Content-Length: 370 On Mon, Feb 04, 2008 at 10:45:43AM -0800, Danek Duvall wrote: > I'm sponsoring this fast-track for Magne Mahre. I believe this project > qualifies for a patch binding, but Magne can confirm whether or not he > intends to integrate this into Solaris 10 or earlier. > > The timer is set for next Monday, February 11, 2008. This was approved at LSARC last week. Danek From bm136801@clustra.norway.sun.com Wed Apr 16 07:32:02 2008 Received: from sunmail5.uk.sun.com (sunmail5.UK.Sun.COM [129.156.85.165]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m3GEW100008628 for ; Wed, 16 Apr 2008 07:32:02 -0700 (PDT) Received: from brm-avmta-1.central.sun.com (brm-avmta-1.Central.Sun.COM [129.147.4.11]) by sunmail5.uk.sun.com (8.13.8+Sun/8.13.8/ENSMAIL,v2.2) with ESMTP id m3GEVxrr020645 for <@sunmail2sca.sfbay.sun.com:lsarc-ext@sun.com>; Wed, 16 Apr 2008 15:32:00 +0100 (BST) Received: from pmxchannel-daemon.brm-avmta-1.central.sun.com by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JZF00I079PAUN00@brm-avmta-1.central.sun.com> for lsarc-ext@sun.com (ORCPT lsarc-ext@sun.com); Wed, 16 Apr 2008 08:31:58 -0600 (MDT) Received: from dm-norway-02.uk.sun.com ([129.156.101.226]) by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JZF00CPZ9P9D080@brm-avmta-1.central.sun.com> for lsarc-ext@sun.com (ORCPT lsarc-ext@sun.com); Wed, 16 Apr 2008 08:31:57 -0600 (MDT) Received: from clustra.norway.sun.com (clustra.Norway.Sun.COM [129.159.119.10]) by dm-norway-02.uk.sun.com (8.13.6+Sun/8.13.6/ENSMAIL,v2.2) with SMTP id m3GEVumJ018525 for ; Wed, 16 Apr 2008 15:31:56 +0100 (BST) Received: (qmail 28499 invoked from network); Wed, 16 Apr 2008 14:31:56 +0000 Received: from khepri12.norway.sun.com (129.159.112.183) by clustra.norway.sun.com with QMQP; Wed, 16 Apr 2008 14:31:56 +0000 Date: Wed, 16 Apr 2008 16:31:55 +0200 From: Bjorn Munch Subject: LSARC 2007/698 pgBouncer: minor changes necessary To: lsarc-ext@sun.com Cc: Magne.Mahre@sun.com Message-id: <20080416143155.GA10473@khepri12.norway.sun.com> Organization: Sun Microsystems MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline X-PMX-Version: 5.4.1.325704 User-Agent: Mutt/1.5.7i Status: RO Content-Length: 1137 Hello, I'm working on integration of this tool into Nevada, and I find there are some minor details in the ARC case which need to be changed. 1. There is no mention of "release binding", and this seems to be required. For PostgreSQL 8.3 we had this sentence added under 2.1: This qualifies for micro/patch release binding. (pgbouncer is an add-on tool for PostgreSQL) 2. The original package names include "82" as a reference to PostgreSQL 8.2. Since we are integrating after PostgreSQL 8.3 we will instead install with this version and thus the package names should change. New names: SUNWpgbouncer-pg83-config, SUNWpgbouncer-pg83-server [The original names cannot be used in any case since _ (underscore) is apparently not a valid character.] 3. In the installation paths, the man pages should not be under share/man but directly under man, together with the PostgreSQL man pages. Thus: /usr/postgres//man/man1/pgbouncer.1 /usr/postgres//man/man5/pgbouncer.5 ["" has now been instantiated as "8.3"] Regards, -- Bjorn Munch Database Technology Group Trondheim, Norway From bm136801@clustra.norway.sun.com Thu Apr 17 04:02:22 2008 Received: from newsunmail1brm.central.sun.com (newsunmail1brm.Central.Sun.COM [129.147.62.245]) by sac.sfbay.sun.com (8.13.8+Sun/8.13.8) with ESMTP id m3HB2LtT020216 for ; Thu, 17 Apr 2008 04:02:22 -0700 (PDT) Received: from brm-avmta-1.central.sun.com (brm-avmta-1.Central.Sun.COM [129.147.4.11]) by newsunmail1brm.central.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id m3HAxXIY005512 for <@sunmail2sca.sfbay.sun.com:lsarc-ext@sun.com>; Thu, 17 Apr 2008 05:02:20 -0600 (MDT) Received: from pmxchannel-daemon.brm-avmta-1.central.sun.com by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) id <0JZG00F13UNEU900@brm-avmta-1.central.sun.com> for lsarc-ext@sun.com (ORCPT lsarc-ext@sun.com); Thu, 17 Apr 2008 05:02:02 -0600 (MDT) Received: from dm-norway-02.uk.sun.com ([129.156.101.226]) by brm-avmta-1.central.sun.com (Sun Java System Messaging Server 6.2-3.04 (built Jul 15 2005)) with ESMTP id <0JZG00JO7UNBY6E0@brm-avmta-1.central.sun.com> for lsarc-ext@sun.com (ORCPT lsarc-ext@sun.com); Thu, 17 Apr 2008 05:01:59 -0600 (MDT) Received: from clustra.norway.sun.com (clustra.Norway.Sun.COM [129.159.119.10]) by dm-norway-02.uk.sun.com (8.13.6+Sun/8.13.6/ENSMAIL,v2.2) with SMTP id m3HB1wu1016195 for ; Thu, 17 Apr 2008 12:01:58 +0100 (BST) Received: (qmail 6521 invoked from network); Thu, 17 Apr 2008 11:01:58 +0000 Received: from khepri12.norway.sun.com (129.159.112.183) by clustra.norway.sun.com with QMQP; Thu, 17 Apr 2008 11:01:58 +0000 Date: Thu, 17 Apr 2008 13:01:58 +0200 From: Bjorn Munch Subject: Re: LSARC 2007/698 pgBouncer: minor changes necessary In-reply-to: <20080416143155.GA10473@khepri12.norway.sun.com> To: lsarc-ext@sun.com Cc: Magne.Mahre@sun.com Message-id: <20080417110158.GA10835@khepri12.norway.sun.com> Organization: Sun Microsystems MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline X-PMX-Version: 5.4.1.325704 User-Agent: Mutt/1.5.7i Status: RO Content-Length: 331 Followup to my email yesterday, with another minor change: Under 4.12 dependencies, remove SUNWpostgr-82-libs. pgbouncer itself does not actually use the PostgreSQL libraries (or header files), neither at compile time nor at run time. The client program that *uses* pgbouncer does, but that can run on another machine. - Bjorn