./databases/pgpool, Connection pooling/replication server for PostgreSQL

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 3.4.1, Package name: pgpool-3.4.1, Maintainer: pkgsrc-users

pgpool is a connection server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL
client can connect to pgpool as if it were a standard PostgreSQL

pgpool caches the connection to PostgreSQL server to reduce the
overhead to establish the connection to it. Also, pgpool could use
two PostgreSQL servers for fail over. If the first server goes down,
pgpool will automatically switch to the secondary server. Moreover,
pgpool supports scheduled switch over.

Required to build:

Master sites:

SHA1: 55027bfb0437b4edea38a480163e32762698c48a
RMD160: ba409a8b2b424272cd458e689ea94234f9bc3f42
Filesize: 196.786 KB

Version history: (Expand)

CVS history: (Expand)

   2019-11-02 16:38:12 by Roland Illig | Files touched by this commit (115)
Log message:
databases: align variable assignments

pkglint -Wall -F --only aligned -r

No manual corrections.
   2017-09-03 10:37:04 by Thomas Klausner | Files touched by this commit (182)
Log message:
Comment out dead MASTER_SITES/HOMEPAGEs.
   2015-11-03 02:56:36 by Alistair G. Crooks | Files touched by this commit (368)
Log message:
Add SHA512 digests for distfiles for databases category

Problems found with existing distfiles:
No changes made to the cstore or mariadb55-client distinfo files.

Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden).  All existing
SHA1 digests retained for now as an audit trail.
   2012-10-02 23:25:56 by Aleksej Saushev | Files touched by this commit (323)
Log message:
Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.
   2011-04-05 19:47:17 by Min Sik Kim | Files touched by this commit (4) | Package updated
Log message:
Update pgpool to 3.4.1.

Patch provided by Wen Heping in PR 43628.

        * Fix handling failover when health_check was disabled. (Yoshiyuki)
          - The bug was introduced in 3.4.
        * Fix deadlock while processing Parse message. (Yoshiyuki)
        * Add new "replicate_select" directive, being the default value to
          be false. (Yoshiyuki)
          - If it is true, SELECT query is replicated. This behavior is
            same as V3.2 or earlier.
        * Improve signal handling. (Yoshiyuki)
          - Occasionaly, zombie processes were remained. Or processes were
        * Fix hang up when SELECT was error inside a transaction
          block. The bug was introduced in V3.3. (Yoshiyuki)
        * Fix PREPARE/EXECUTE handling in master slave mode. (Yoshiyuki)
        * Fix "kind mismatch error" when deadlock error
        * Fix hang up and SEGV in extended query protocol when a warning
          SQL like "SELECT '\'';" executed. (Yoshiyuki)
        * Fix memory leak when connection cache was full. (Yoshiyuki)
        * Improve replication. SELECT nextval() and SELECT setval() are
          now replicated. (Yoshiyuki)
        * Change SELECT query is only sent to the master node. (Yoshiyuki)
          - Use /*REPLICATION*/ comment to repliate a SELECT query.
        * Fix unexpected failover error due to receiving an interrupt
          signal while connecting to the backend. (Yoshiyuki)
        * Fix "ps" output to follow PostgreSQL's output. (Taiki)
        * Change the default value for enable_pool_hba to true. (Taiki)
        * Add "pgpool.pam" file, for PAM configuration file, to be
          installed under "$PREFIX/share/". (Taiki)
        * Support HBA authentication(Taiki)
        * Support log_connections(Taiki)
        * Support log_hostname(Tatsuo)
        * Show pgpool status in ps command(Tatsuo)
        * Fix bug with prepared query(Yoshiyuki)
        * Detach secondary server when "kind mismatch error" is \ 
        * Re-open socket if it was closed by backend while reusing
        * Allow 0 weight(Tatsuo)
        * Return correct error messaes when pg_hba.conf auth fails. Patch
          contributed by Kenji Kikuchi
        * Fix kind mismatch errors with COPY FROM STDIN(Yoshiyuki)
        * Allow load balancing with extended protocol(Yoshiyuki)
        * Fix LISTEN/NOTIFY bug in master/slave mode reported by Michael
          Ulitskiy (Tatsuo)
        * Improve documentation. patches contributed by Mark Stosberg
        * Fix "kind is 0!" error in Execute(). Reads messages until
          receiving CommandComplete, EmptyQuery, ErrorResponse or
          PortalSuspend in Execute() (Yoshiyuki)
        * Add log_statement option. patches contributed by Thomas E
          Lackey, modifications and documents by Tatsuo
        * In SimpleForwardToFrontend() do not send SYNC and wait for ready for
          query when PANIC or FATAL error occurs. In this case the backend
          closes the communication channel immediately which will cause unwanted
          failover/degeneration by, for example, trying to connect to
          invalid database (Tatsuo)
        * Fix dealock problem in extended modd by calling synchronize() in
          Execute if replication_strict is enabled (Yoshiyuki)
        * Fix segfault problem in race conditions among
          connection_life_time, child_life_time and child_max_connections
        * pgpool does not exit even if pgpool.conf contents is wrong(Tatsuo)
        * Fix buffer overrun bug with long health_check_user name(Taiki)
        * Fix occasional segfault with replication and load balance
          enabled(bug id #1000548)(Tatsuo)
        * Fix pool_send_error_message to send properly NULL terminated
        * Fix kind mismatch error in SimpleFowardFrontend(Yoshiyuki)
        * Enable to build with BSD make(Yoshiyuki)
        * Fix pool_debug and friends to block signals while
        * Fix numerous bugs with extended query(Yoshiyuki)
        * Fix INSERT LOCK(Yoshiyuki)
        * Do not reuse startup packet(Tatsuo)
        * Automatically DEALLOCTE prepared queries when client
        * Do not forward packets when length = 0 in
        * Fix lost of kind info(Tatsuo)
        * Fix bugs with master/slave mode introduced in 2.7.2. per report
          from David Boreham (Tatsuo)
        * Fix bugs with master/slave and prepared quries. per report
          from David Boreham (Tatsuo)
        * Changed Copyright to PgPool Global Development Group
        * Fix a typo in man page
        * PQnotifes() does not receive immediate responses from LISTEN
        * NOTIFY emits packet kind does not agree errors in master/slave
        * add pgpool man pages(Peter Eisentra)
        * Fix bug in show pool_status for ignore_leading_white_space
   2008-06-12 04:14:58 by Joerg Sonnenberger | Files touched by this commit (1134)
Log message:
Add DESTDIR support.
   2007-03-24 20:21:34 by Joerg Sonnenberger | Files touched by this commit (124)
Log message:
Prepare for switching to NO_MTREE=yes.
   2006-01-15 18:09:51 by Min Sik Kim | Files touched by this commit (3) | Package updated
Log message:
Update pgpool to 2.7.  Based on patches provided by Inseo PARK in
private email.

Major changes from 2.5.1:
- Allow SERIAL data type replication by issuing table locks automatically.
- New directives: child_max_connections and ignore_leading_white_space.
- Bug fixes and minor improvements.