head 1.4; access; symbols pkgsrc-2024Q1:1.4.0.16 pkgsrc-2024Q1-base:1.4 pkgsrc-2023Q4:1.4.0.14 pkgsrc-2023Q4-base:1.4 pkgsrc-2023Q3:1.4.0.12 pkgsrc-2023Q3-base:1.4 pkgsrc-2023Q2:1.4.0.10 pkgsrc-2023Q2-base:1.4 pkgsrc-2023Q1:1.4.0.8 pkgsrc-2023Q1-base:1.4 pkgsrc-2022Q4:1.4.0.6 pkgsrc-2022Q4-base:1.4 pkgsrc-2022Q3:1.4.0.4 pkgsrc-2022Q3-base:1.4 pkgsrc-2022Q2:1.4.0.2 pkgsrc-2022Q2-base:1.4 pkgsrc-2022Q1:1.3.0.8 pkgsrc-2022Q1-base:1.3 pkgsrc-2021Q4:1.3.0.6 pkgsrc-2021Q4-base:1.3 pkgsrc-2021Q3:1.3.0.4 pkgsrc-2021Q3-base:1.3 pkgsrc-2021Q2:1.3.0.2 pkgsrc-2021Q2-base:1.3 pkgsrc-2021Q1:1.2.0.30 pkgsrc-2021Q1-base:1.2 pkgsrc-2020Q4:1.2.0.28 pkgsrc-2020Q4-base:1.2 pkgsrc-2020Q3:1.2.0.26 pkgsrc-2020Q3-base:1.2 pkgsrc-2020Q2:1.2.0.22 pkgsrc-2020Q2-base:1.2 pkgsrc-2020Q1:1.2.0.2 pkgsrc-2020Q1-base:1.2 pkgsrc-2019Q4:1.2.0.24 pkgsrc-2019Q4-base:1.2 pkgsrc-2019Q3:1.2.0.20 pkgsrc-2019Q3-base:1.2 pkgsrc-2019Q2:1.2.0.18 pkgsrc-2019Q2-base:1.2 pkgsrc-2019Q1:1.2.0.16 pkgsrc-2019Q1-base:1.2 pkgsrc-2018Q4:1.2.0.14 pkgsrc-2018Q4-base:1.2 pkgsrc-2018Q3:1.2.0.12 pkgsrc-2018Q3-base:1.2 pkgsrc-2018Q2:1.2.0.10 pkgsrc-2018Q2-base:1.2 pkgsrc-2018Q1:1.2.0.8 pkgsrc-2018Q1-base:1.2 pkgsrc-2017Q4:1.2.0.6 pkgsrc-2017Q4-base:1.2 pkgsrc-2017Q3:1.2.0.4 pkgsrc-2017Q3-base:1.2 pkgsrc-2017Q2:1.1.0.12 pkgsrc-2017Q2-base:1.1 pkgsrc-2017Q1:1.1.0.10 pkgsrc-2017Q1-base:1.1 pkgsrc-2016Q4:1.1.0.8 pkgsrc-2016Q4-base:1.1 pkgsrc-2016Q3:1.1.0.6 pkgsrc-2016Q3-base:1.1 pkgsrc-2016Q2:1.1.0.4 pkgsrc-2016Q2-base:1.1 pkgsrc-2016Q1:1.1.0.2 pkgsrc-2016Q1-base:1.1; locks; strict; comment @# @; 1.4 date 2022.05.18.11.20.35; author adam; state Exp; branches; next 1.3; commitid OCb1NDHRAGiWQwED; 1.3 date 2021.04.28.09.18.55; author wiz; state Exp; branches; next 1.2; commitid T5l1YL0c2lBGy2RC; 1.2 date 2017.08.17.07.46.05; author fhajny; state Exp; branches; next 1.1; commitid gpmLx8y8SQ2jrx3A; 1.1 date 2016.03.11.21.30.55; author fhajny; state Exp; branches; next ; commitid OJeWGV9ZzV4mQgYy; desc @@ 1.4 log @pgpool2: updated to 4.3.1 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 4.3.0 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. @ text @$NetBSD: patch-src_sample_pgpool.conf.sample,v 1.3 2021/04/28 09:18:55 wiz Exp $ Default pid file location. --- src/sample/pgpool.conf.sample.orig 2022-02-17 01:50:05.000000000 +0000 +++ src/sample/pgpool.conf.sample @@@@ -292,13 +292,13 @@@@ backend_clustering_mode = 'streaming_rep # FILE LOCATIONS #------------------------------------------------------------------------------ -#pid_file_name = '/var/run/pgpool/pgpool.pid' +#pid_file_name = '@@PGPOOL_PIDDIR@@/pgpool.pid' # PID file name # Can be specified as relative to the" # location of pgpool.conf file or # as an absolute path # (change requires restart) -#logdir = '/tmp' +#logdir = '@@PGPOOL_LOGDIR@@' # Directory of pgPool status file # (change requires restart) @@@@ -936,7 +936,7 @@@@ hostname0 = '' # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'. # Defaults to 1MB. # (change requires restart) -#memqcache_oiddir = '/var/log/pgpool/oiddir' +#memqcache_oiddir = '@@PGPOOL_LOGDIR@@/oiddir' # Temporary work directory to record table oids # (change requires restart) #cache_safe_memqcache_table_list = '' @ 1.3 log @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 consistency. 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. @ text @d1 1 a1 1 $NetBSD: patch-src_sample_pgpool.conf.sample,v 1.2 2017/08/17 07:46:05 fhajny Exp $ d5 3 a7 3 --- src/sample/pgpool.conf.sample.orig 2021-04-24 00:45:34.156306546 +0300 +++ src/sample/pgpool.conf.sample 2021-04-24 00:47:55.421086015 +0300 @@@@ -286,13 +286,13 @@@@ syslog_ident = 'pgpool' d11 2 a12 2 -pid_file_name = '/var/run/pgpool/pgpool.pid' +pid_file_name = '@@PGPOOL_PIDDIR@@/pgpool.pid' d18 2 a19 2 -logdir = '/tmp' +logdir = '@@PGPOOL_LOGDIR@@' d23 1 a23 1 @@@@ -894,7 +894,7 @@@@ memqcache_cache_block_size = 1MB d27 2 a28 2 -memqcache_oiddir = '/var/log/pgpool/oiddir' +memqcache_oiddir = '@@PGPOOL_LOGDIR@@/oiddir' d31 1 a31 1 cache_safe_memqcache_table_list = '' @ 1.2 log @Update databases/pgpool2 to 3.6.5, based on patches by Mustafa Dogan. Fixes pkg/52488. Release 3.6.5 - Fix for [pgpool-hackers: 2400] Garbage output - Importing the latest changes in the MemoryManager API from PostgreSQL code. - Fixing 0000306: Pgpool steals back MASTER status. - Fixing [pgpool-hackers: 2390]Problems with the relative paths in daemon mode - Adjust function name change in PostgreSQL 10 dev head. - Fix a posible hang with streaming replication and extended protocol. - Fix Pgpool-II hang when used by erlang applications. - Fix bug with sending bind message to wrong target node. - Fix query cache hang when used by node.js. - Deal with PostgreSQL 10 in streaming replication delay checking. - Fix query cache memory leak. - Fix extended query hang in certain case. - Fix for [pgpool-hackers: 2354] segfault with pg_md5. - Fix descriptions of white/black_memcache_table_list. - Fix corner case bug in Pgpool-II starting up. Release 3.6.4 - Fixing a few corner cases in the failover request handling of the watchdog. - Tightening up the watchdog cluster membership criteria. - Enhance document for load balancing. - Add node 0 failover test. - Fix Pgpool-II child process segfault reported in [pgpool-hackers: 2312]. Release 3.6.3 - Fix "show pool_cache" segfault when memcached is used. - Fix for some more code warnings. - Fixing some annoying compiler warnings. - Removing the function defined but not used warnings from pool_config_vatiable.c - Removing the references of obsolete debug_level configuration parameter. - Fixing a mistake in the watchdog code. - Fix for 0000299: Errors on the reloading of configuration. - Add pgpool_adm English and Japanese docs. - Fix document indentation. - Fix for 0000289: Inconsistent backend state. - Enhancing the handling of split-brain scenario by the watchdog. - Enhancing the watchdog internal command mechanism to handle multiple concurrent commands. - Fix compiler warnings. - Comment out unsupported Java method in new JDBC drivers to prevent regression failure. - Downgrade parse before bind log message to debug1. - Fix coverity warnings. - Fix for [pgpool-general: 5396] pam ldap failure. - Mention that SQL type commands cannot be used in extended query mode. - Consider SHOW command as kind of a read query. - Fix memory leak problem caused by commit adcb636. - Mega patch to fix "kind mismatch" (or derived) errors in streaming replication mode. - Fix for 0000296: PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. Release 3.6.2 - Add "Wants=network.target" to pgpool.service file. - Fix pcp_promote_node bug that fails promoting node 0. - Fix document error. - Pgpool-IIshould not perform ping test after bringing down the VIP. - Fix to release shared memory segments when Pgpool-IIexits. - Fix for [pgpool-general: 5315] pg_terminate_backend - Adding the missing ExecStop and ExecReload commands to the systemd service configuration file. - Fix for 281: "segmentation fault" when execute pcp_attach_node. - Fix load balancing bug in streaming replication mode. - Fix yet another kind mismatch error in streaming replication mode. - Fix do_query()hangs after close message. - Fixing stack smashing detected. - Fixing the issue with the watchdog process restart. - Fix query cache bug reported in pgpool-general-jp:1441. - Remove elog/ereport calls from signal handlers. - Fix bug failed to create INET domain socket in FreeBSD if listen_addresses = '*'. - Fix for 0000249: watchdog sometimes fails de-escalation. - Fix connection_life_time broken by authentication_timeout. - Fix authentication timeout that can occur right after client connecttions. Release 3.6.1 - Tightening up the watchdog security. - Add pgpool_adm extension in Pgpool-II RPM. - Fix occasional segfault when query cache is enabled. - Fix packet kind does not match error in extended protocol. - Fix a race condition in a signal handler. - Fix wrong minimum configuration value for client_idle_limit_in_recovery. - Allow to execute "make xslthtml" under doc.ja. @ text @d1 1 a1 1 $NetBSD: patch-src_sample_pgpool.conf.sample,v 1.1 2016/03/11 21:30:55 fhajny Exp $ d5 3 a7 3 --- src/sample/pgpool.conf.sample.orig 2017-07-10 08:56:18.000000000 +0000 +++ src/sample/pgpool.conf.sample @@@@ -210,13 +210,13 @@@@ syslog_ident = 'pgpool' d18 1 a18 1 -logdir = '/var/log/pgpool' d23 3 a25 3 @@@@ -709,7 +709,7 @@@@ memqcache_cache_block_size = 1048576 # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'. # Defaults to 1MB. d29 1 a29 1 # Temporary work directory to record table oids d31 1 a31 1 white_memqcache_table_list = '' @ 1.1 log @Import pgpool-II 3.5.0 as databases/pgpool2, based on wip/pgpool2. 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. @ text @d1 1 a1 1 $NetBSD$ d5 1 a5 1 --- src/sample/pgpool.conf.sample.orig 2015-04-08 07:58:44.000000000 +0000 d7 1 a7 1 @@@@ -211,10 +211,10 @@@@ debug_level = 0 d14 3 d23 1 a23 1 @@@@ -682,7 +682,7 @@@@ memqcache_cache_block_size = 1048576 @