./databases/pgpool2, Middleware between PostgreSQL servers and a PostgreSQL database client

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

Branch: CURRENT, Version: 4.3.2, Package name: postgresql13-pgpool2-4.3.2, Maintainer: pkgsrc-users

pgpool-II is a middleware that works between PostgreSQL
servers and a PostgreSQL database client. It talks
PostgreSQL's backend and frontend protocol, and relays
a connection between them.

Required to run:
[shells/bash] [databases/postgresql95-client] [databases/postgresql95-server]

Required to build:

Master sites:

Filesize: 5709.735 KB

Version history: (Expand)

CVS history: (Expand)

   2022-05-24 13:50:12 by Adam Ciarcinski | Files touched by this commit (4) | Package updated
Log message:
pgpool2: updated to 4.3.2



Enhance in stopping pgpool main process. (Tatsuo Ishii)
If "pgpool stop" couldn't terminate the main process within certain \ 
period (currently 5 seconds), send the signal again.
Fix not to abort session while in failed transaction. (Tatsuo Ishii)
When an explicit transaction fails, subsequent commands should be ignored until \ 
commit or rollback command comes in. However pgpool sometimes aborted the \ 
session if relcache lookup happened.
Change the PID length of pcp_proc_count command to 7 characters long. (Bo Peng)
Enhance error message to include the message kind returned and the backend node \ 
id while processing parse message. (Tatsuo Ishii)
Downgrade log level of ParameterStatus message from LOG to DEBUG5. (Tatsuo Ishii)
Change the default value of pcp_listen_addresses from '*' to 'localhost'. \ 
(Tatsuo Ishii)
Adjust the field name in pcp_watchdog_info. (Muhammad Usama)
Enable parameters related to logging_collector by default in RPM packages. (Bo Peng)

Bug fixes

Fix issue that watchdog cluster keeps rejecting the restarted remote node which \ 
is lost previously. (Muhammad Usama)
Fix exit_handler in pgpool main process to avoid possible infinite wait. (Tatsuo \ 
Fix pgpool child process to obtain process information. (Tatsuo Ishii)
Fix a potential issue in shared memory allocation function. (Tatsuo Ishii)
Fix bug with pg_enc and pg_md5 when using "-i" option. (bug \ 
747)(Tatsuo Ishii)
Fix not to include garbage in %m log_line_prefix. (Tatsuo Ishii)
Fix main process exiting if a backend is failing or shutting down while \ 
performing finding primary. (Tatsuo Ishii)
Fix segfaults in watchdog. (Muhammad Usama)
Fix issue that failover request is refused if backend node status managed in \ 
private_backend_status and the one in the share memory area do not agree. \ 
(Tatsuo Ishii)
Fixed follow_primary.sh.sample script to check the status of PostgreSQL using \ 
pg_isready. (Bo Peng)


Doc: move the example of "Pgpool-II on Kubernetes" to github \ 
repository. (Bo Peng)
Doc: update configuration example. (Masaya Kawamoto)
Doc: update the example output of pcp_watchdog_info. (Bo Peng)
Doc: mention that escaping is required if you are providing the password as an \ 
argument to pg_enc and the password contains a "$" character. (Bo \ 

Regression Tests

Enhance regression test 018.detach_primary to avoid the timeut error. (Tatsuo Ishii)
Enhance regression test 074.bug700_memqcache_segfault to avoid the timeut error. \ 
(Tatsuo Ishii)
Improve regression test to detect segmentation fault. (Bo Peng)
Increase timeout for regression test 077.invalid_failover_node. (Tatsuo Ishii)
   2022-05-18 13:20:35 by Adam Ciarcinski | Files touched by this commit (7) | Package updated
Log message:
pgpool2: updated to 4.3.1


Suppress message length log for in_hot_standby.
Change the default value for log_line_prefix.
Add validations of wd_lifecheck_password and recovery_password format.
Enhance parameter status handling.
Bug fixes


Many enhancements are added to this version for easier configuration and \ 
administration. A new cluster membership mechanism is introduced to dynamically \ 
adjust the Watchdog cluster size. This allows the leader Watchdog node to retain \ 
the quorum/VIP even when some of watchdog nodes get Shutdown or disconnected. \ 
New PostgreSQL 14 SQL parser is imported. The Snapshot Isolation Mode is now \ 
ready for production. New sample configuration for the mode is provided in the \ 
configuration example section.
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Remove SHA1 distfile hashes
   2021-04-28 11:18:55 by Thomas Klausner | Files touched by this commit (11) | Package updated
Log message:
pgpool2: update to 4.2.2.

Based on a diff provided by Mustafa Dogan.

4.2.1 and 4.2.2 are bugfix releases.

4.2 contains new features and enhancements, including:

    Some items in the configuration file pgpool.conf are vastly
    enhanced for easier configuration and administration.

    Implement logging_collector for easier log management.

    Implement log_disconnections to collect disconnection logs.

    Implement pg_enc and pg_md5 to allow to register multiple
    passwords at once.

    Allow to show statistics of health check by using SHOW
    POOL_HEALTH_CHECK_STATS command, and also allow to show statistics
    of issued SQL by using SHOW POOL_BACKEND_STATS command.

    New PCP command pcp_reload_config is added.

    Now it is possible to omit write_function_list and
    read_only_function_list by looking at system catalog information.

    Add new clustering mode snapshot_isolation_mode which guarantees
    not only data modifications to multiple PostgreSQL but read

    Support LDAP authentication between clients and Pgpool-II.

    Add ssl_crl_file and ssl_passphrase_command to SSL configuration.

    Import PostgreSQL 13's SQL parser.
   2020-05-27 21:37:44 by Thomas Klausner | Files touched by this commit (60)
Log message:
*: reset MAINTAINER for fhajny on his request
   2020-01-18 22:51:16 by Jonathan Perkin | Files touched by this commit (1836)
Log message:
*: Recursive revision bump for openssl 1.1.1.
   2018-12-15 22:12:25 by Thomas Klausner | Files touched by this commit (67) | Package updated
Log message:
*: update email for fhajny