-
Notifications
You must be signed in to change notification settings - Fork 13
/
NEWS
507 lines (337 loc) · 15.9 KB
/
NEWS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
===============================================================================
pgpoolAdmin 4.2
===============================================================================
* Version 4.2.0 2021/06/17
** New features
- Add support for Pgpool-II 4.2. (Bo Peng)
Added parameters are:
- backend_clustering_mode
- ssl_crl_file
- ssl_passphrase_command
- log_disconnections
- logging_collector
- log_directory
- log_filename
- log_file_mode
- log_truncate_on_rotation
- log_rotation_age
- log_rotation_size
- read_only_function_list
- write_function_list
- primary_routing_query_pattern_list
- dml_adaptive_object_relationship_list
- hostname
- pgpool_port
- heartbeat_hostname
- heartbeat_port
- cache_safe_memqcache_table_list
- cache_unsafe_memqcache_table_list
Deleted parameters are:
- replication_mode
- master_slave_mode
- master_slave_sub_mode
- white_function_list
- black_function_list
- black_query_pattern_list
- wd_hostname
- wd_port
- wd_heartbeat_port
- heartbeat_destination
- heartbeat_destination_port
- white_memqcache_table_list
- black_memqcache_table_list
- other_pgpool_hostname
- other_pgpool_port
- other_wd_port
===============================================================================
pgpoolAdmin 4.1
===============================================================================
* Version 4.1.0 2020/02/20
** New features
- Add support for Pgpool-II 4.1. (Bo Peng)
Added parameters are:
- reserved_connections
- backend_application_name
- ssl_ecdh_curve
- ssl_dh_params_file
- statement_level_load_balance
- auto_failback
- auto_failback_interval
- enable_consensus_with_half_votes
- enable_shared_relcache
- relcache_query_target
===============================================================================
pgpoolAdmin 4.0
===============================================================================
* Version 4.0.1 2018/12/20
** Bug fixes
- PgpoolAdmin has a vulnerability to allow an attacker to
login without properly checking the authorization.
Once getting into PgpoolAdmin, the attacker can control
Pgpool-II. Also it may be possible to obtain the superuser
role of a PostgreSQL database.
PgPool Global Development Group would like to thank Fotios Rogkotis
of DarkMatter for finding the security issue and giving us the
detailed studies on it. (CVE-2018-16203)
* Version 4.0.0 2018/10/19
** New features
- Add support for Pgpool-II 4.0. (Bo Peng)
Added parameters are:
- allow_clear_text_frontend_auth
- log_client_messages
- black_query_pattern_list
- disable_load_balance_on_write
- failover_on_backend_error
- detach_false_primary
Deleted parameters are:
- fail_over_on_backend_error
===============================================================================
pgpoolAdmin 3.7
===============================================================================
* Version 3.7.1 2018/02/05
** New features
- Add new PostgreSQL connect timeout parameter. (Bo Peng)
Sometimes no response from backend due to network reasons,
pgpoolAdmin will wait for long time. In this commit, we add
new PostgreSQL connection timeout parameter.
Patch is provide by Tuukka Kivilahti, and improved by me.
** Bug fixes
- Fix pgpool stop mode doesn't work correctly. (Bo Peng)
* Version 3.7.0 2017/11/22
** New features
- Add support for Pgpool-II 3.7. (Bo Peng)
Added parameters are:
- failover_when_quorum_exists
- failover_require_consensus
- enable_multiple_failover_requests_from_node
- health_check_period0
- health_check_timeout0
- health_check_user0
- health_check_password0
- health_check_database0
- health_check_max_retries0
- health_check_retry_delay0
- connect_timeout0
Deleted parameters are:
- debug_level
- Improve pgpool.conf config form. (Bo Peng)
- Add support for PHP7. (Bo Peng)
** Bug fixes
- Fix bug that detach node button doesn't work. (Bug 361) (Bo Peng)
===============================================================================
pgpoolAdmin 3.6
===============================================================================
* Version 3.6.2 2017/09/05
- Fix some notices in "pgpool.conf Setting". (Bo Peng)
- Fix bugs in js/pgconfig.js used for setting pgpool.conf. (Bo Peng)
[pgpool-general: 5660]
- Change pgpoolAdmin.spec to include missed js directory in pgpoolAdmin RPM. (Bo Peng)
- Fix PHP Notice: Undefined variable while installing pgpoolAdmin. (Bo Peng)
per bug219.
* Version 3.6.1 2017/04/28
- Add selection of version 3.6 in pgpoolAdmin install. (Bo Peng)
- Add selection of version 3.6 in pgpoolAdmin setting. (Bo Peng)
* Version 3.6.0 2017/02/28
- Fix incorrect display of watchdog status when using Pgpool-II 3.6.x. (Bo Peng)
- Redirect stdout, stderr to log file while starting Pgpool-II without
running in daemon mode. (Bo Peng)
- Fix superuser: unknown (Connection error) in pgpoolAdmin. (Bo Peng)
per bug276.
===============================================================================
pgpoolAdmin 3.5
===============================================================================
* Version 3.5.3 2016/06/17
- Fix readConfigParams() to treat the varliables with numbers. (Nozomi Anzai)
per bug187.
* Version 3.5.2 2016/04/26
- Fix to check "PCP Directory". (Nozomi Anzai)
* Version 3.5.1 2016/04/04
- Show the path to .pcppass (Nozomi Anzai)
- Fix not to confirm the status of "pcp_systemdb_info" command if the version
is 3.5 [pgpool-general: 4427] (Nozomi Anzai)
- Add chinese templates help (pengbo)
- Change the chinese message catalog (pengbo)
- Fix the argument's name (Nozomi Anzai)
http://www.pgpool.net/mantisbt/view.php?id=171
* Version 3.5.0 2016/01/29
pgpoolAdmin 3.5 adopts pgpool-II 3.5.
** New features
- Add new parameters for pgpool-II 3.5 (Nozomi Anzai)
if_cmd_path, health_check_database, pcp_listen_addresses, search_primary_node_timeout,
serialize_accept, sr_check_database, wd_de_escalation_command, wd_ipc_socket_dir,
wd_priority, wd_monitoring_interfaces_list
- Adopt to new pcp command usage (Nozomi Anzai)
- Adopt pcp_watchdog_info in ver3.5 (Nozomi Anzai)
- Add Chinese message catalogs (pengbo)
- Adopt Spanish translation (Nozomi Anzai)
Patch contributed by Rodrigo Ramirez Norambuena
** Bug fixes
- Add selected attribute to <select> of "pgpool-II version" (Nozomi Anzai)
- Modified installer to check if pgsql extension is loaded (Nozomi Anzai)
Patch contributed by Rodrigo Ramirez Norambuena
- Define a new error code "e1013" and fix to return it if pcp_watchdog_info failed
(Nozomi Anzai)
http://www.pgpool.net/mantisbt/view.php?id=149
===============================================================================
pgpoolAdmin 3.4
===============================================================================
* Version 3.4.1 2015/02/05
- Fix installer to allow to choose 3.4 version (Tatsuo Ishii)
-------------------------------------------------------------------------------
* Version 3.4.0 2014/11/07
pgpoolAdmin 3.4 adopts pgpool-II 3.4.
** New features
- Add new parameters for pgpool-II 3.4 (Nozomi Anzai)
- new:
listen_backlog_multiplier, connect_timeout, allow_sql_comments,
check_unlogged_table, database_redirect_preference_list,
app_name_redirect_preference_list, log_line_prefix, log_error_verbosity,
client_min_messages, log_min_messages
- deleted:
parallel_mode, system_db_hostname, system_db_port,
system_db_dbname, system_db_schema, system_db_user,
system_db_password, print_timestamp
===============================================================================
pgpoolAdmin 3.3
===============================================================================
* Version 3.3.1 2014/03/24
- Fix a bug that watchdug status is shown as "Unknown" when it's "Down"
(Yugo Nagata)
- Fix a bug that restart of PostgreSQL doesn't work (Yugo Nagata)
- Fix to get properly if the login user is a super user or not on backend
nodes. (Nozomi Anzai)
This problem could be occured especially when he isn't a super user.
Per [pgpool-general: 2340].
- Fix that pgpool_pgctl can be executed only when the login user is super
user in backend nodes.(Nozomi Anzai)
Previously, any login user was able to try to execute pgpool_pgctl()
which could stop/restart/reload a backend node even if he was not a super
user. Also pgpool_pgctl() was executed by sr_check_user or health_check_user,
but it wasn't reasonable. This update is that buttons of stop/restart/reload
are disabled when the login user isn't a super user and that pgpool_pg_ctl()
is executed by login user instead of sr_check_user or health_check_user
who don't have to be non-superuser. Per [pgpool-general: 2338].
-------------------------------------------------------------------------------
* Version 3.3 2013/07/30
pgpoolAdmin 3.3 adopts pgpool-II 3.3.
** New features
- Add new parameters for pgpool-II 3.3 (Nozomi Anzai)
wd_authkey, wd_escalation_command, clear_memqcache_on_escalation,
wd_lifecheck_method, wd_heartbeat_port, wd_heartbeat_keepalive,
wd_heartbeat_deadtime wd_lifecheck_dbname, wd_lifecheck_user,
wd_lifecheck_password, heartbeat_destination, heartbeat_destination_port,
heartbeat_device
- Add a watchdog statuse view in status page (Nozomi Anzai, Yugo Nagata)
This show watchdog statuses of pgpool-IIs and the virtual IP etc. when
watchdog is enabled.
- Add functionality to stop/reload/restart PostgreSQL from GUI
(Nozomi Anzai)
pgpool_pgctl function need to be installed in the backends. This function
is a new feature of pgpool-II 3.3 provided by pgpool_recovery extension.
In addition, a superuser whose name is same as the pgpoolAdmin's login user
also must exists in the backend.
- Add functionality to add/remove a backend from GUI (Nozomi Anzai)
- Show the hostname on which pgpoolAdmin is working in status page
(Andrew Bruce, Nozomi Anzai)
- Add fuctionality to show limited lines in log view (Yugo Nagata)
** Bug fixes
- Fix to not write deprecated parmeters to when updating pgpool.conf
(Yugo Nagata)
===============================================================================
pgpoolAdmin 3.2
===============================================================================
* Version 3.2.2 2013/2/8
- Fix typo: health_check_pasword -> health_check_password (Anzai)
- Fix the type of delay_threshold: bool -> integer (Anzai)
- Add pool_passwd parameter. (Nagata)
-------------------------------------------------------------------------------
* Version 3.2.1 2012/10/15
- Revise the default value of relcache_size from 0 to 256. (Nagata)
- Update Smarty to 3.1.12.
This version has a security fix for Cross-Site Scripting (XSS)
vulnerability. (Nagata)
-------------------------------------------------------------------------------
* Version 3.2 2012/08/03
pgpoolAdmin 3.2 adopts pgpool-II 3.2.
- Add new parameters and remove deleted parameters in pgpool-II 3.2.
(Anzai, Nagata)
- new:
[ Health Check ]
health_check_password, health_check_max_retries, health_check_retry_delay
[ On Memory Query Cache ]
memory_cache_enabled, memqcache_method, memqcache_memcached_host,
memqcache_memcached_port, memqcache_total_size, memqcache_max_num_cache,
memqcache_cache_block_size, memqcache_expire, memqcache_auto_cache_invalidation,
memqcache_maxcache, memqcache_oiddir,
white_memqcache_table_list, black_memqcache_table_list
[ Watchdog ]
use_watchdog, trusted_servers, ping_path, wd_interval, wd_life_point,
wd_lifecheck_query, delegate_IP, ifconfig_path, if_up_cmd, if_down_cmd,
arping_path, arping_cmd, wd_hostname, wd_port,
other_pgpool_hostname, other_pgpool_port, other_wd_port
[ Others ]
relcache_size, check_temp_table
- deleted:
enable_query_cache
- Support older versions of pgpool-II. (Anzai)
- pgpoolAdmin 3.1 was only for pgpool-II 3.1, however the latest
pgpoolAdmin is fixed bugs and sometimes enhanced.
So we decided adopting these 3 pgpool-II versions: 3.0, 3.1, 3.2.
- Now pgmgt.conf has new defined variable as the version of pgpool-II.
- Add "-C" option to the command "pgpool". (Anzai)
- Use health_check_password for health check. (Anzai)
- Update helps about pgpool.conf. Sync ones in the manual. (Anzai)
- Some visual enhances. (Anzai)
- Replace Smarty libralies to 3.1.8. (Anzai)
- And Fix a lot of Notice Errors invisible in Smarty 2.x.
===============================================================================
pgpoolAdmin 3.1
===============================================================================
* Version 3.1.1 2011/12/5
- Fix not to ignore changing boolean values in pgpool.conf. (Anzai)
- Fix not to ignore changing D option of pgpool command in pgmgt.conf.
(Anzai)
- At query cache page it somtimes happen "redeclare function" error,
so replace include() to require_once(). (Anzai)
- Update french document. (Guillaume Lelarge)
-------------------------------------------------------------------------------
* Version 3.1 2011/10/14
pgpoolAdmin 3.1 adopts pgpool-II 3.1.
- Replace functions deprecated in PHP 5.3 (Anzai)
- Sync pgpool.conf Setting with pgpool-II 3.1 (Anzai)
- Add new parameters and remove deleted parameters in pgpool-II 3.1 (Anzai)
- new:
follow_master_command, relcache_expire, backend_flag, sr_check_period,
sr_check_user, sr_check_password, log_destination,
syslog_facility, syslog_ident
- deleted:
pcp_timeout, backend_socket_dir
- Add promote button in Master/Slave mode with streaming replication (Anzai)
- This button is to execute pcp_promote_node.
- Other small changes for pgpool-II 3.1 (Anzai)
- When log_destination is syslog, Log button will be invisible.
- Allow regex value in black_function_list and white_function_list.
- Some fix (Anzai)
- Change to save boolean values in pgpool.conf with on/off format.
===============================================================================
pgpoolAdmin 3.0
===============================================================================
* Version 3.0.3 2011/03/11
- Update french translation, per a patch from Jean-Paul Argudo(Guillaume)
- Allow to accept '|' for pgpool logfile in the installation script.
This has been alredy possible in pgpool.conf(Tatsuo)
-------------------------------------------------------------------------------
* Version 3.0.1 2010/09/24
- Update embedded Smarty to 2.6.26(Tatsuo)
-------------------------------------------------------------------------------
* Version 3.0 2010/09/10
pgpoolAdmin 3.0 adopts pgpool-II 3.0.
- Add "Discard pgpool_status file(-D)" to pgpoolAdmin Setting. (Anzai)
- Sync pgpool.conf Setting with pgpool-II 3.0. (Anzai, Tatsuo)
- Add "Backend pid" (process if of PostgreSQL database server process) and
"Frontend connected"(1 if frontend actually connets) to Process Info.
(Tatsuo)
- Replace functions deprecated in PHP 5.3(Anzai)
- Refactor pgpool status/summary(Tatsuo)
- Fix connect/disconnect buttons disappering ini node status window.(Tatsuo)
===============================================================================