pgpool2_3.1.3-5_amd64.deb


Advertisement

Description

pgpool2 - connection pool server and replication proxy for PostgreSQL

Distribution: Debian 7 (Wheezy)
Repository: Debian Main amd64
Package name: pgpool2
Package version: 3.1.3
Package release: 5
Package architecture: amd64
Package type: deb
Installed size: 1.99 KB
Download size: 724.34 KB
Official Mirror: ftp.br.debian.org
pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It provides the following features: * Connection Pooling * Replication * Load Balance * Limiting Exceeding Connections * Parallel Query pgpool-II talks PostgreSQL's backend and frontend protocol, and relays a connection between them. Therefore, a database application (frontend) thinks that pgpool-II is the actual PostgreSQL server, and the server (backend) sees pgpool-II as one of its clients. Because pgpool-II is transparent to both the server and the client, an existing database application can be used with pgpool-II almost without a change to its sources. This is version 3 of pgpool-II, the second generation of pgpool.

Alternatives

Conflicts

  • pgpool

Replaces

  • pgpool

    Download

    Binary package: pgpool2_3.1.3-5_amd64.deb
    Source package: pgpool2

    Install Howto

    1. Update the package index:
      # sudo apt-get update
    2. Install pgpool2 deb package:
      # sudo apt-get install pgpool2

    Files

    • /etc/default/pgpool2
    • /etc/init.d/pgpool2
    • /etc/pgpool2/pcp.conf
    • /etc/pgpool2/pool_hba.conf
    • /usr/sbin/pcp_attach_node
    • /usr/sbin/pcp_detach_node
    • /usr/sbin/pcp_node_count
    • /usr/sbin/pcp_node_info
    • /usr/sbin/pcp_pool_status
    • /usr/sbin/pcp_proc_count
    • /usr/sbin/pcp_proc_info
    • /usr/sbin/pcp_promote_node
    • /usr/sbin/pcp_recovery_node
    • /usr/sbin/pcp_stop_pgpool
    • /usr/sbin/pcp_systemdb_info
    • /usr/sbin/pg_md5
    • /usr/sbin/pgpool
    • /usr/share/doc/pgpool2/NEWS.gz
    • /usr/share/doc/pgpool2/README.Debian
    • /usr/share/doc/pgpool2/basebackup.sh
    • /usr/share/doc/pgpool2/changelog.Debian.gz
    • /usr/share/doc/pgpool2/changelog.gz
    • /usr/share/doc/pgpool2/copyright
    • /usr/share/doc/pgpool2/pgpool-en.html
    • /usr/share/doc/pgpool2/pgpool-fr.html
    • /usr/share/doc/pgpool2/pgpool-ja.css
    • /usr/share/doc/pgpool2/pgpool-ja.html
    • /usr/share/doc/pgpool2/pgpool-zh_cn.html
    • /usr/share/doc/pgpool2/pgpool.css
    • /usr/share/doc/pgpool2/pgpool_remote_start
    • /usr/share/doc/pgpool2/recovery.conf.sample.gz
    • /usr/share/doc/pgpool2/tutorial-en.html
    • /usr/share/doc/pgpool2/tutorial-ja.html
    • /usr/share/doc/pgpool2/tutorial-zh_cn.html
    • /usr/share/doc/pgpool2/where_to_send_queries.odg.gz
    • /usr/share/doc/pgpool2/where_to_send_queries.pdf.gz
    • /usr/share/doc/pgpool2/examples/dist_def_pgbench.sql
    • /usr/share/doc/pgpool2/examples/pgpool.conf.sample-master-slave.gz
    • /usr/share/doc/pgpool2/examples/pgpool.conf.sample-replication.gz
    • /usr/share/doc/pgpool2/examples/pgpool.conf.sample-stream.gz
    • /usr/share/doc/pgpool2/examples/pgpool.pam
    • /usr/share/doc/pgpool2/examples/pgpool_recovery
    • /usr/share/doc/pgpool2/examples/pgpool_recovery_pitr
    • /usr/share/doc/pgpool2/examples/pgpool_remote_start
    • /usr/share/doc/pgpool2/examples/replicate_def_pgbench.sql
    • /usr/share/man/man8/pgpool.8.gz
    • /usr/share/pgpool2/insert_lock.sql
    • /usr/share/pgpool2/pgpool.conf
    • /usr/share/pgpool2/system_db.sql

    Changelog

    2013-04-10 - Christoph Berg <myon@debian.org> pgpool2 (3.1.3-5) unstable; urgency=low * Create /var/run/postgresql on startup when missing. Closes: #703696.

    2012-11-05 - Christoph Berg <myon@debian.org> pgpool2 (3.1.3-4) unstable; urgency=low * When installing a new config file, use group postgres/640.

    2012-06-11 - Christoph Berg <myon@debian.org> pgpool2 (3.1.3-3) unstable; urgency=low * Remove /etc/pgpool2/pgpool.conf on purge, ucf doesn't do that by itself. Closes: #674238.

    2012-05-22 - Christoph Berg <myon@debian.org> pgpool2 (3.1.3-2) unstable; urgency=low * Use ucf to handle /etc/pgpool2/pgpool.conf. Closes: #671359. Also, try to keep the port number used instead of calling next_free_port on every upgrade.

    2012-04-25 - Christoph Berg <myon@debian.org> pgpool2 (3.1.3-1) unstable; urgency=low * New upstream release.

    2012-03-20 - Christoph Berg <myon@debian.org> pgpool2 (3.1.2-1) unstable; urgency=low * New upstream release.

    2012-01-28 - Christoph Berg <myon@debian.org> pgpool2 (3.1.1-2) unstable; urgency=low * debian/control.in - libpgpool0: set Breaks to solve "fails to upgrade from squeeze" Thanks to Hideki Yamane for the patch. Closes: #657418.

    2011-12-22 - Christoph Berg <myon@debian.org> pgpool2 (3.1.1-1) unstable; urgency=low * New upstream release. Closes: #646116. Change the lock method of insert_lock. The previous insert_lock uses row locking against the sequence relation, but the current one uses row locking against pgpool_catalog.insert_lock table. The reason is that PostgreSQL core developers decided to disallow row locking against the sequence relation to avoid an internal error which it leads. So creating insert_lock table in all databases which are accessed via pgpool-II beforehand is required. If does not exist insert_lock table, pgpool-II locks the insert target table. This behavior is same as pgpool-II 2.2 and 2.3 series. * Build pgpool-recovery pgpool-regclass pgpool-walrecrunning server modules. Closes: #630465. * Build pgpool_adm server module. * Split libpcp.so into a separate package. There is already another libpcp in Debian, libpcp3/libpcp3-dev, therefore we call our packages libpgpool0/libpgpool-dev. We have a file conflict with /usr/lib/libpcp.{a,so}, so libpgpool-dev conflicts with libpcp3-dev. As they are already at SONAME 3 while we are at 0, the other package will not problems with our files in /usr/lib. (The alternative solution of putting libpcp.so.* in /usr/lib/pgpool2 would require setting RPATH in several places, which was both unsupported by the current build system (despite the documentation claiming otherwise) and also pretty ugly.)

    2011-06-10 - Christoph Berg <myon@debian.org> pgpool2 (3.0.4-1) unstable; urgency=low * New upstream release * Use format 3.0 (quilt).

    2011-03-31 - Christoph Berg <myon@debian.org> pgpool2 (3.0.3-2) unstable; urgency=low * Upload to unstable.

    Advertisement
    Advertisement