1 2009-10-04 18:15 t-ishii
3 * NEWS, configure.in, configure (V2_2_STABLE.[4,5,5]): Prepare
6 2009-10-04 18:15 t-ishii
8 * doc/pgpool-ja.html (V2_2_STABLE.8): Add release note for 2.2.5
10 2009-10-04 08:52 t-ishii
12 * doc/tutorial-en.html (V2_2_STABLE.1): Add sample to use
15 2009-10-03 21:45 t-ishii
17 * doc/tutorial-ja.html (V2_2_STABLE.1): Add sample to use
20 2009-10-03 21:39 t-ishii
22 * sample/pgpool_recovery_pitr (V2_2_STABLE.1): Enhance online
23 recovery 2nd stage script to sync sequence value
25 2009-10-03 20:55 t-ishii
27 * pool_proto_modules.h (V2_2_STABLE.5): Remove unnecessary
28 declaration "allow_close_transaction"
30 2009-10-02 16:56 t-ishii
32 * pool_proto_modules.c (V2_2_STABLE.13): Fix Parse() to use
33 wait_for_query_response() instead of synchronize().
35 2009-10-02 16:53 t-ishii
37 * pool_process_query.c (V2_2_STABLE.22): Fix comment
39 2009-09-26 18:14 t-ishii
41 * pool_proto_modules.c (V2_2_STABLE.12): Allow to print more
42 accurate query when Parse() detects kind mismatch errors.
44 2009-09-26 16:36 t-ishii
46 * pool_process_query.c (V2_2_STABLE.21): Fix reset_backend to deal
47 with DEALLOCATE error. In this case prepared objects are not removed
48 and reset_backend is infinitely called.
50 Fix do_command to guard against the case that after execution of an
51 SQL command, the backend does not return either N, E or C. This
52 should not happen but there was a report that it actually happend in
53 certain cases(maybe caused by asynchronized backend data?)
57 Subject: Re: [Pgpool-general] pgpool 2.2.4: DEALLOCATED children
58 From: Xavier Noguer Date: Fri, 25 Sep 2009 03:35:57 -0400
62 Patches by Xavier Noguer with minor tweak by Tatsuo Ishii.
64 2009-09-25 23:36 t-ishii
66 * pool_proto_modules.c (V2_2_STABLE.11): Make
67 allow_close_transaction to static and add comments.
69 Let execute CREATAE TEMP TABLE on every nodes in master/slave mode.
70 If not, subsequent Parse or Bind to use the table will fail. At
71 this point this doen't work since MASTER_SLAVE set to 0 in
72 ProcessFrontendResponse. More analysis is needed...
74 2009-09-25 16:35 t-ishii
76 * main.c (V2_2_STABLE.6): Fix write_pid_file. It forgot to write
77 out NULL termination of pid. Pgpool occasionally won't stop because
80 2009-09-23 20:39 t-ishii
82 * pool_process_query.c (V2_2_STABLE.20): Remove error checks for
83 pool_write(frontend), pool_flush(frontend) in
84 SimpleForwardToFrontend.
86 Check error for send_deallocate() in reset_backend. Otherwise
87 send_deallocate will be called infinitely. Per bug report from
88 Agustin Almonte Ferrada. See:
90 Subject: Re: [Pgpool-general] pgpool 2.2.4: DEALLOCATED children
91 From: Agustin Almonte Ferrada <aalmonte@antica.cl> To: Tatsuo Ishii
92 <ishii@sraoss.co.jp> Cc: pgpool-general@pgfoundry.org Date: Wed, 23
93 Sep 2009 01:55:54 -0400
95 2009-09-23 11:03 t-ishii
97 * pool_auth.c (V2_2_STABLE.2): Fix pool_read_kind and pool_read_int
98 so that the error message for kind is shown in hexadecimal. Other
99 part of pgpool-II already does this.
101 2009-09-17 20:17 t-ishii
103 * pool_process_query.c, pool_proto_modules.c, pool_proto_modules.h
104 (V2_2_STABLE.[19,10,4]): Teach do_command() to use
105 wait_for_query_response(). insert_lock() calls do_command() to
106 issue LOCK TABLE to lock tables having SERIAL column when
107 insert_lock is true. Problem is, insert_lock() waits forever in
108 do_command() if the target table is locked by someone else. This
109 patch should give a way insert_lock() to espcape from the situation.
111 2009-09-06 12:52 t-ishii
113 * child.c, pool.h (V2_2_STABLE.[8,5]): Fix connection_count_down()
114 so that it does decrement too much in some corner cases. If failed
115 to read a start up packet, or receive cancel request etc.,
116 connection_count_down() is called and goes back to the onnection
117 accept loop. Problem is, at the very beginning of the connection
118 accept loop, if we have received a signal, we call child_exit()
119 which calls connection_count_down() again. Problem report by
120 Ryoichi TANABE. See [pgpool-general-jp: 616] for more details.
122 Also unneccesary public declarations for connection_count_up() and
123 connection_count_down() are removed.
125 2009-08-24 13:58 t-ishii
127 * ChangeLog (tags: V2_2_4) (V2_2_STABLE.4): Prepare 2.2.4
129 2009-08-24 13:55 t-ishii
131 * NEWS, configure, doc/pgpool-ja.html (V2_2_STABLE.[3,4,7]) (utags:
132 V2_2_4): Prepare 2.2.4
134 2009-08-24 13:53 t-ishii
136 * configure.in (tags: V2_2_4) (V2_2_STABLE.4): Prepare 2.2.4.
138 2009-08-24 13:36 t-ishii
140 * TODO (tags: V2_2_4) (V2_2_STABLE.1): Add a few items
142 2009-08-22 13:19 t-ishii
144 * child.c, main.c, md5.c, pcp_child.c, pg_md5.c, pool_auth.c,
145 pool_config.c, pool_connection_pool.c, pool_error.c, pool_hba.c,
146 pool_ip.c, pool_params.c, pool_path.c, pool_process_query.c,
147 pool_proto_modules.c, pool_query_cache.c,
148 pool_rewrite_outfuncs.c, pool_rewrite_query.c, pool_sema.c,
149 pool_shmem.c, pool_signal.c, pool_stream.c, pool_system.c,
150 ps_status.c, recovery.c, strlcpy.c, pcp/md5.c
151 (V2_2_STABLE.[7,5,1,1,1,1,1,3,1,1,1,1,1,18,9,1,5,1,2,2,1,2,1,1,1,1,1])
152 (utags: V2_2_4): Remove unnecessary spaces and tabs at end of
153 line. Patch conributed by Jun Kuriyama.
155 2009-08-20 15:26 t-ishii
157 * pool_process_query.c (V2_2_STABLE.17): Fix possible bug
158 introduced in pgpool-II 2.2.2. Load balance control variables may
159 remain not be restored and subsequent DML/DDL call might sent to
162 2009-08-18 17:38 t-ishii
164 * pool_process_query.c, pool_proto_modules.c, pool_proto_modules.h
165 (tags: V2_2_4) (V2_2_STABLE.[16,8,3]): Change
166 wait_for_query_response() so that it sends NOTICE message to
167 frontend periodically. It appears that pgpool-II 2.2.3
168 unconditionaly sends param packet to client even it uses version 2
169 protocol, which is apparentlt wrong. Also tweak checking period from
170 1 second to 30 seconds since 1 second seems too aggressive.
172 2009-08-18 17:30 t-ishii
174 * child.c (V2_2_STABLE.6): Remove unneccessary call to
175 send_frontend_exit() in do_child().
177 2009-08-13 22:36 t-ishii
179 * child.c (V2_2_STABLE.5): Remove unnessary call of
180 send_frontend_exits() in die().
182 2009-08-13 22:34 t-ishii
184 * main.c (V2_2_STABLE.4): Block signals before forking children
185 rather after. Otherwise parent will be killed by failover signal if
186 it receives before establish signal handler. See [pgpool-general-jp:
187 586] for more details.
189 2009-08-11 22:53 t-ishii
191 * ChangeLog (tags: V2_2_3) (V2_2_STABLE.3): Prepare 2.2.3.
193 2009-08-11 22:52 t-ishii
195 * configure.in, configure (V2_2_STABLE.[3,3]) (utags: V2_2_3):
198 2009-08-11 22:48 t-ishii
200 * doc/pgpool-ja.html (tags: V2_2_3) (V2_2_STABLE.6): Fix
201 description of parallel query. Add release note for 2.2.3.
203 2009-08-11 22:23 t-ishii
205 * pool_connection_pool.c (tags: V2_2_3) (V2_2_STABLE.2): Fix
206 new_connection() so that it does leave garbage in
207 POOL_CONNECTION_POOL->slot[i]. This caused segfault in child_exit().
208 Bug report at [pgpool-general-jp: 586].
210 2009-08-07 14:27 y-mori
212 * pool_process_query.c, pool_rewrite_outfuncs.c
213 (V2_2_STABLE.[15,4]) (utags: V2_2_3): FIX parallel query
216 Subquery was used on larg or rarg.
217 Subquery was used on ON-Cluase.
218 Full OUTER JOIN was not optimized.
219 2. Fail_on_error=false was passed to the 3rd arguments of dblink.
221 2009-08-06 16:55 t-ishii
223 * pool_proto_modules.c (tags: V2_2_3) (V2_2_STABLE.7): Print last
224 query for kind mismatch error message even extended protocol is
225 used. Patch contributed by Akio Ishida.
227 2009-08-06 16:38 t-ishii
229 * pool_process_query.c (V2_2_STABLE.14): Fix buffer overrun error
230 which mangled kind mismatch error message in
231 pool_send_error_message(). Bug rpeort by Takahiro Itagaki at
232 [pgsql-jp: 39950]. Fix suggested by Akio Ishida at [pgsql-jp:
235 2009-08-01 20:40 t-ishii
237 * child.c (tags: V2_2_3) (V2_2_STABLE.4): Check
238 MASTER_CONNECTION(p)->sp) is non 0 before further referring to sp.
239 Current implementation may interrupt in the window, after setting p
240 and before setting sp. Per bug report from Jun Kuwamura.
242 2009-08-01 20:34 t-ishii
244 * pool_connection_pool.c (V2_2_STABLE.1): Fix pool_debug's mismatch
245 between data type and conversion specification for time_t. Check
246 MASTER_CONNECTION(p)->sp) is non 0 before further referring to sp.
247 Current implementation may interrupt in the window, after setting p
248 and before setting sp.
250 2009-07-30 16:46 t-ishii
252 * pool_process_query.c (V2_2_STABLE.13): Fix typo in comment
254 2009-07-28 14:52 y-mori
256 * doc/: pgpool-en.html (tags: V2_2_4, V2_2_3), pgpool-ja.html
257 (V2_2_STABLE.[3,5]): add restrictions for parallel mode
261 -USING CLAUSE at Join Expression
262 => auto convert to ON CLAUSE
264 2009-07-26 18:04 t-ishii
266 * pool_rewrite_outfuncs.c (V2_2_STABLE.3): Fix breakage by previous
267 commit. Patch by Guillaume Lelarge.
269 2009-07-26 12:01 t-ishii
271 * pool_process_query.c (V2_2_STABLE.12): Fix comment about load
274 2009-07-26 11:57 t-ishii
276 * pool_sema.c (tags: V2_2_3) (V2_2_STABLE.1): Fix various
277 pool_error/log format errors. Patch provided by Akio Ishida.
279 2009-07-24 21:30 y-mori
281 * pool_rewrite_outfuncs.c (V2_2_STABLE.2): fix: Join statment in
285 Accouts table is defined by dist_def,
286 the below query is executed as loadbalance.
294 WHERE a.aid =1 or a.aid=2;
296 2009-07-22 17:46 t-ishii
298 * child.c, main.c (tags: V2_2_3), pool.h (tags: V2_2_4, V2_2_3),
299 pool_process_query.c, pool_proto_modules.c,
300 pool_rewrite_outfuncs.c, pool_shmem.c (tags: V2_2_3)
301 (V2_2_STABLE.[3,3,4,11,6,1,1]): Fix various pool_error/log format
302 errors. Patch provided by Akio Ishida.
304 2009-07-22 14:33 t-ishii
306 * pool_process_query.c, pool_proto_modules.c, pool_proto_modules.h
307 (tags: V2_2_3) (V2_2_STABLE.[10,5,2]): Query cancel by statement
308 timeout does not generate "kind mismatch" error any more. How to
309 reproduce the test case:
311 Directory connect to PostgreSQL. T1: BEGIN; T1: LOCK TABLE t1;
313 T2: SET statement_timeout TO 5000; T2: UPDATE t1 SET ...
315 UPDATE query aborts and error message comes out on T2: ERROR:
316 canceling statement due to statement timeout
318 A side effect of this is, statement timeout works correctly (rather
319 than statement timeout value * # of node).
321 Note that to initiate T1 by directory connecting to slave node will
322 not work (still results in kind mismatch error). But I don't think
323 this could happend in the real world.
325 Also refactor error detecting modules (detect_deadlock_error and so
328 2009-07-21 18:48 t-ishii
330 * main.c (V2_2_STABLE.2): Check read(2) error in health_check().
331 This should detect case described in message below, i.e. postmaster
332 is blocked by SIGSTOP.
334 Subject: [Pgpool-general] Healt Check issues From: Vctrjsn@gmail.com
335 To: pgpool-general@pgfoundry.org Date: Sun, 05 Jul 2009 18:01:18
338 2009-07-21 12:59 t-ishii
340 * ChangeLog (V2_2_STABLE.2): Update Change. We are getting closer
343 2009-07-21 10:36 t-ishii
345 * pool.h, pool_proto_modules.c (V2_2_STABLE.[3,4]): Check frontend
346 connection while waiting for response from backend for extended
347 protocol (Execute()). Replace sychronize() with
348 wait_for_query_response(). Also tweak pool.h so that it includes
349 cancel packet's mazic proto number.
351 2009-07-21 09:26 t-ishii
353 * pool_process_query.c (V2_2_STABLE.9): Do not start transaction if
354 the command is CLUSTER with no argument
356 2009-07-20 20:47 t-ishii
358 * child.c, pool.h, pool_process_query.c, pool_proto_modules.c,
359 pool_proto_modules.h (V2_2_STABLE.[2,2,8,3,1]): Check frontend
360 connection while waiting for response from backend. This is done in
361 wait_for_query_response() by writing a dummy parameter status packet
362 to pgpool client every 1 second. If the write fails, a cancel packet
363 is sent to backend to free backend. This is usefull to prevent
364 pgpool child from waiting forever for backend response. Pgpool
365 client will diconnect to pgpool if the query takes too long. This is
366 typical use case for Web applications.
368 2009-07-15 14:14 t-ishii
370 * pool_process_query.c (V2_2_STABLE.7): Fix bug with prepared
371 statement deallocation:
373 Subject: [Pgpool-general] Pgpool probelms From: Nimesh Satam
374 <nimesh.satam@gmail.com> To: pgpool-general@pgfoundry.org Cc: Nimesh
375 Satam <nimesh.zedo@gmail.com> Date: Wed, 17 Jun 2009 11:31:37 +0530
377 This was caused a bug in reset_backend().
379 if (qcnt >= qn + prepared_list.cnt) {
380 reset_prepared_list(&prepared_list);
381 return 2; } send_deallocate(backend, &prepared_list, qcnt - qn);
384 Problem is, send_deallocate -> SimpleQuery("DEALLOCATE") calls
385 del_prepared_list, which will decrement prepared_list.cnt. In short,
386 incrementing of qcnt *and* decrementing of prepared_list.cnt happen
387 at the same time. So deallocate is only called 1/2 times than it
390 Bug analysis and fix provided by Akio Ishida.
392 2009-07-14 17:42 t-ishii
394 * sql/pgpool-recovery/pgpool-recovery.c (tags: V2_2_4, V2_2_3)
395 (V2_2_STABLE.2): Update copyright year
397 2009-07-14 17:39 t-ishii
399 * sql/pgpool-recovery/pgpool-recovery.c (V2_2_STABLE.1): PostgreSQL
400 8.4 needs to include utils/binutils.h
402 2009-06-26 13:59 t-ishii
404 * pool_process_query.c (V2_2_STABLE.6): Fix bug with
405 SimpleForwardToFrontend(). Clients using the extend protocol send
406 'H'(Flush) after each command. Problem is, SimpleForwardToFrontend
407 does not immediately forward 'C'(Command Complete) packet to
408 frontend. So the client sends 'H' and wait for 'C'. On the other
409 hand backend receives 'H' but reply back nothing since Command
410 complete has nothing to be returned. Both side stuck.
412 The fix is, forwarding 'C' packet immediately after receiving it
413 from backend. To prevent similar bugs happen in the future, I put
414 pool_flush(frontend) after calling SimpleForwardToFrontend in
415 pool_process_query() (other places already do this).
417 The extra pool_flush() might harm performance. So I did some tests
418 using pgbench -S, and found nothing has been changed regarding
419 performance after patching.
421 Bug report from Gavin Sherry along with patches for
422 SimpleForwardToFrontend().
424 2009-05-27 11:01 t-ishii
426 * pool.h, pool_process_query.c (V2_2_STABLE.[1,5]): Add
427 pool_set_timeout() to control pool_check_fd()'s behavior. This can
428 be used for various places. The first user is reset_backend() to
429 fix following scenario: Do COPY_FROM(for example pgbench -i) Cancel
430 pgbench pgpool waits for response from backend while sending reset
431 queries and hang. Backend waits for data coming from pgpool
434 BTW, I don't think PostgreSQL's befaviro for COPY_FROM is quite
435 correct since the doc stats:"Receipt of any other non-copy message
436 type constitutes an error that will abort the copy-in state as
437 described above" If my understanding correct, COPY_FROM should abort
438 copy-in state if it receives ABORT (issued in reset_backend). It
439 seems PostgreSQL is not implemented as stated in the doc...
441 2009-05-24 22:56 t-ishii
443 * sql/pgpool-recovery/Makefile (tags: V2_2_4, V2_2_3)
444 (V2_2_STABLE.1): Support pre 8.0 PostgreSQL which does not have
445 pg_config --pgxs option. Patch provided by Enrico Pirozzi with
446 slight modification by Tatsuo Ishii
448 2009-05-12 10:01 t-ishii
450 * doc/pgpool-en.html (V2_2_STABLE.2): Fix description of
453 2009-05-05 11:07 t-ishii
455 * configure.in, configure, NEWS (tags: V2_2_3)
456 (V2_2_STABLE.[2,2,2]) (utags: V2_2_2): prepare 2.2.2
458 2009-05-05 11:04 t-ishii
460 * doc/pgpool-ja.html (tags: V2_2_2) (V2_2_STABLE.4): Add 2.2.2
463 2009-05-02 17:48 t-ishii
465 * pool_process_query.c (tags: V2_2_2) (V2_2_STABLE.4): Fix
466 is_select_query() to test "sql" parameter is NULL. As of 2.2,
467 pgpool sets Portal->sql_string to NULL for SQL command PREPARE.
468 Usually this is ok, since in most cases SQL command EXECUTE follows
469 anyway. Problem is, some applications mix PREPARE with extended
470 protocol command "EXECUTE" and so on. Execute() seems to think this
471 never happens but it is not real. Someday we should extract actual
472 query string from PrepareStmt->query and set it to
475 2009-05-02 17:45 t-ishii
477 * pool_stream.c (tags: V2_2_3, V2_2_2) (V2_2_STABLE.1): Fix
478 pool_flush() so that it ignores error on frontend connection. This
479 is needed to continue processing with backend, otherwise we risk
482 2009-05-02 17:41 t-ishii
484 * child.c (tags: V2_2_2) (V2_2_STABLE.1): Call
485 pool_send_frontend_exits() before pool_discard_cp() when resetting
486 connection fails. This will avoid "unexpected EOF on client
487 connection" error on when pgpool client exits abnormaly
489 2009-05-01 09:39 t-ishii
491 * pool_proto_modules.c (tags: V2_2_2) (V2_2_STABLE.2): Add missing
494 2009-04-08 20:11 t-ishii
496 * pool_proto_modules.c (V2_2_STABLE): In master slave mode,
497 sometimes DEALLOCATE fails. This is caused by that the first
498 PREPARE was not executed on the slave. Patch contributed by
501 2009-04-25 16:20 t-ishii
503 * ChangeLog (tags: V2_2_2, V2_2_1) (V2_2_STABLE.1): prepare for
506 2009-04-25 16:16 t-ishii
508 * configure.in, configure (V2_2_STABLE.[1,1]) (utags: V2_2_1):
511 2009-04-25 16:12 t-ishii
513 * doc/pgpool-ja.html (tags: V2_2_1) (V2_2_STABLE.3): Add 2.2.1
516 2009-04-25 16:05 t-ishii
518 * NEWS (tags: V2_2_1) (V2_2_STABLE.1): Prepare 2.2.1
520 2009-04-08 20:11 t-ishii
522 * pool_proto_modules.c (tags: V2_2_1) (V2_2_STABLE.1): In master
523 slave mode, sometimes DEALLOCATE fails. This is caused by that the
524 first PREPARE was not executed on the slave. Patch contributed by
527 2009-04-03 22:49 t-ishii
529 * doc/: pgpool-en.html (tags: V2_2_2, V2_2_1), pgpool-ja.html
530 (V2_2_STABLE.[1,2]): Add documents about configuration reloading.
532 2009-04-03 19:21 t-ishii
534 * pgpool.spec, redhat/pgpool.conf.sample.patch, redhat/pgpool.init
535 (V2_2_STABLE.[1,1,1]) (utags: V2_2_1, V2_2_2, V2_2_3, V2_2_4):
536 Merge changes made on HEAD regarding RPM spec files
538 2009-03-23 10:13 devrim
540 * redhat/pgpool.conf.sample.patch (1.1): Add a patch which
541 configures sample conf file to match RPM and Red Hat defaults.
543 2009-03-14 12:39 t-ishii
545 * pool_process_query.c (tags: V2_2_1) (V2_2_STABLE.3): Fix
546 need_insert_lock so that it returns false if the protocol version is
547 2. insert_lock has not been working for V2 protocol anyway, so this
550 2009-03-08 23:58 gleu
552 * main.c, pgpool.8.in (tags: V2_2_4, V2_2_3) (V2_2_STABLE.[1,1])
553 (utags: V2_2_1, V2_2_2): Update usage function and man page.
555 2009-03-07 18:19 t-ishii
557 * pool_process_query.c (V2_2_STABLE.2): Add a comment to
558 need_insert_lock() if the query being used to check if the table has
559 SERIAL column is valid for PostgreSQL 7.3 to 8.3.
561 2009-03-07 08:54 t-ishii
563 * pool_process_query.c (V2_2_STABLE.1): Make excessive message
564 level in read_kind_from_backend from LOG to DEBUG.
566 2009-03-01 22:34 t-ishii
568 * doc/pgpool-ja.html (V2_2_STABLE.1): Fix release note for 2.2
570 2009-02-28 15:33 t-ishii
572 * Makefile.in (tags: V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0)
573 (V2_2_STABLE.1): Update Makefile.am
575 2009-02-28 15:33 t-ishii
577 * Makefile.am (tags: V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0)
578 (V2_2_STABLE.1): Add doc/load_balance.png, doc/load_balance.odp
580 2009-02-28 13:45 t-ishii
582 * ChangeLog (1.40), NEWS (1.28), TODO (1.18, V2_2_3, V2_2_2,
583 V2_2_1), configure (1.30) (utags: V2_2_0): Version 2.2
585 2009-02-28 13:40 t-ishii
587 * configure.in (1.27, V2_2_0): Version 2.2
589 2009-02-24 11:20 t-ishii
591 * pool_auth.c (1.15, V2_2_3, V2_2_2, V2_2_1), pool_process_query.c
592 (1.141) (utags: V2_2_0): Prpare for receiving parameter status
595 If postgresql.conf was changed and reloaded, PostgreSQL sends
596 parameter status packets asynchronously even those changed
597 parameters are not one of session_authorization etc., which is
598 marked as GUC_REPORT in guc.c(GUC_REPORT means parameter status
599 packet is sent if its value is changed).
601 After receiving those packets, they are discarded. I think this is
602 harmless since most of changes are not affected to the frontend
605 2009-02-21 19:00 t-ishii
607 * TODO (1.17), configure (1.29), ChangeLog (1.39) (utags:
608 V2_2_0_RC2): pgpool-II 2.2 RC2
610 2009-02-21 18:56 t-ishii
612 * configure.in (1.26, V2_2_0_RC2): pgpool 2.2 RC2
614 2009-02-21 18:52 t-ishii
616 * doc/load_balance.png (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
617 V2_2_0, V2_2_0_RC2): A load balance logic explanation figure
619 2009-02-21 18:47 t-ishii
621 * doc/: pgpool-en.html (1.35), pgpool-ja.html (1.59) (utags:
622 V2_2_0, V2_2_0_RC2): Add comment about rsync and autovacuum.
624 2009-02-20 10:34 t-ishii
626 * pool_process_query.c (1.140, V2_2_0_RC2): Fix
627 pool_send_frontend_exits() so that it checks the connection to
628 backend if it actually exists. This is needed, for example, in the
629 final stae of online recovery. pgpool child holds 1 connection to a
630 backend. After failback one more backend added but there's no
631 connection to the backend.
633 2009-02-17 18:50 t-ishii
635 * pool_process_query.c (1.139): Do not start internal transaction
636 if CREATE INDEX CONCURRENTLY
638 2009-02-17 15:16 devrim
640 * pgpool.spec (1.14, V2_2_0, V2_2_0_RC2): Update to 2.2 (Download
641 URL is broken, since we don't know yet the pgfoundry download URL
644 2009-02-15 14:35 t-ishii
646 * configure (1.28, V2_2_0_RC1): run autoconf
648 2009-02-15 14:32 t-ishii
650 * configure.in (1.25, V2_2_0_RC1): 2.2 RC1
652 2009-02-15 14:31 t-ishii
654 * ChangeLog (1.38, V2_2_0_RC1): Update Changelog
656 2009-02-15 14:29 t-ishii
658 * TODO (1.16, V2_2_0_RC1): Mention that two items were resolved
660 2009-02-15 14:26 t-ishii
662 * pgpool.conf.sample (1.26, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
663 V2_2_0_RC2), doc/pgpool-en.html (1.34), doc/pgpool-ja.html (1.58)
664 (utags: V2_2_0_RC1): Reflect the fact that DISCARD ALL holds
665 exclusive lock on pg_listener, thus will degrade performance.
667 2009-02-10 10:11 t-ishii
669 * pool_process_query.c (1.138, V2_2_0_RC1): Fix
670 is_internal_transaction_needed() so that DROP DATABASE does not
671 start internal transaction
673 2009-02-07 21:57 t-ishii
675 * configure (1.27, V2_2_0_BETA2): Run autoconf
677 2009-02-07 21:57 t-ishii
679 * configure.in (1.24, V2_2_0_BETA2): Update version
681 2009-02-07 21:52 t-ishii
683 * NEWS (1.27, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Update NEWS
685 2009-02-07 00:30 t-ishii
687 * pool_process_query.c (1.137, V2_2_0_BETA2): Add pid_file_name to
690 2009-02-05 17:24 t-ishii
692 * doc/pgpool-ja.html (1.57, V2_2_0_BETA2): Fix typo
694 2009-02-05 09:33 t-ishii
696 * ChangeLog (1.37, V2_2_0_BETA2): Run cvs2cl.pl -t --fsf
698 2009-02-05 09:30 t-ishii
700 * doc/pgpool-ja.html (1.56): Add more fix to release info
702 2009-02-05 09:26 t-ishii
704 * recovery.c (1.12, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
705 V2_2_0_RC1, V2_2_0_BETA2): Fix online recovery to wait for
706 failback done before allowing to accept connections from clients. It
707 was supposed to work like this but actually was not since the day 0
708 when online recovery was born. Without the fix there could be
709 potential data inconsistency among DB nodes.
711 2009-02-05 09:24 t-ishii
713 * main.c (1.45, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2):
716 2009-02-01 19:13 t-ishii
718 * NEWS (1.26): Add new item
720 2009-02-01 19:11 t-ishii
722 * pool_process_query.c (1.136): Start internal transaction if
723 necessary. Before we only started transaction INSERT, UPDATE, DELETE
724 and SELECT. Obviously we need to start transaction other than these,
725 for example CREATE TABLE. To avoid an overhead to look up large
726 number of statements (currently 70), we use bsearch() now.
728 2009-01-31 22:17 t-ishii
730 * doc/pgpool-ja.html (1.55): Update release note
732 2009-01-30 17:15 t-ishii
734 * test/jdbc/README.euc_jp (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
735 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Add comment how to
738 2009-01-30 09:06 y-mori
740 * pool_rewrite_query.c (1.13), pool_rewrite_query.h (1.8, V2_2_4)
741 (utags: V2_2_0, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1,
742 V2_2_2, V2_2_3): Add comment
744 2009-01-28 15:48 t-ishii
746 * NEWS (1.25): Add more items
748 2009-01-27 10:04 t-ishii
750 * COPYING (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
751 V2_2_0_RC1, V2_2_0_BETA2): Update copyright year
753 2009-01-25 20:13 t-ishii
755 * NEWS (1.24), TODO (1.15, V2_2_0_BETA2), configure (1.26),
756 configure.in (1.23), version.h (1.5, V2_2_4, V2_2_3, V2_2_2,
757 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2),
758 doc/pgpool-en.html (1.33, V2_2_0_BETA2), doc/pgpool-ja.html
759 (1.54) (utags: V2_2_0_BETA1): Prepare 2.2 beta1
761 2009-01-25 19:13 t-ishii
763 * main.c (1.44), pool.h (1.36, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
764 V2_2_0_RC1, V2_2_0_BETA2), pool_config.l (1.24, V2_2_4, V2_2_3,
765 V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2),
766 pgpool.conf.sample (1.25, V2_2_0_BETA2), pool_config.c (1.27,
767 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
768 V2_2_0_BETA2) (utags: V2_2_0_BETA1): Add pid_file_name directive
770 2009-01-25 13:32 t-ishii
772 * ChangeLog (1.36, V2_2_0_BETA1): ChangeLog is now generated by
773 using cvs2cl.pl -t --fsf
775 2009-01-25 09:09 t-ishii
777 * pool_rewrite_query.c (1.12, V2_2_0_BETA1): Remove unused static
778 function check_whereClause() Update Copyright year
780 2009-01-24 20:34 t-ishii
782 * pool.h (1.35): Include limit.h. This seems to be necessary Fedra
783 box. Update copyright year
785 2009-01-22 18:29 y-mori
787 * pool_stream.c (1.14, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
788 V2_2_0_BETA2, V2_2_0_BETA1): Fix different function name was used
789 in the error message.
791 2009-01-22 18:16 y-mori
793 * pool_process_query.c (1.135, V2_2_0_BETA1), pool_proto_modules.c
794 (1.6, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
795 V2_2_0_BETA1), pool_rewrite_query.c (1.11), pool_rewrite_query.h
796 (1.7, V2_2_0_BETA1): add the comment related to parallel query
798 2009-01-22 09:50 t-ishii
800 * child.c (1.26, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
801 V2_2_0_BETA2, V2_2_0_BETA1): Remove unnecessary function
802 declaration for child_exit()
804 Add comments to child_exit() which had no comments at all
806 Modify child_exit() so that it sends terminate mesagges before
807 exiting. This will prevent backend process from being idle waiting
808 for TCP keepalive event occurs. This is not good since a backend
809 process may hold locking on certain tables.
811 2009-01-22 09:45 t-ishii
813 * pool_process_query.c (1.134): Modify pool_send_frontend_exits()
814 so that it change fd to non block while sending terminate message
815 (X) to backend. This should prevent pgpool from being blocked while
816 sending data to socket.
818 2009-01-21 10:43 t-ishii
820 * pool_process_query.c (1.133): Add debug code and message
822 2009-01-18 22:54 t-ishii
824 * ps_status.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
825 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Fix FreeBSD case. patch
826 provided by Jun Kuriyama.
828 2009-01-14 23:54 t-ishii
830 * pool_process_query.c (1.132): Fix excessive debug statement
832 2009-01-07 22:33 t-ishii
834 * pool_process_query.c (1.131): Add new argument to detect_error()
835 so that it can recognize the error class (E or N). per bug report
836 from Daniel: From: Daniel.Crespo@l-3com.com To:
837 <pgpool-general@pgfoundry.org> Date: Tue, 6 Jan 2009 12:50:08 -0500
839 The bug was caused by detect_postmaster_down_error() not detecting
840 receive crash shutdown error.
842 Enbug by: Subject: [Pgpool-committers] pgpool - pgpool-II: Fix
843 detect_error() so that it ignores NOTICE. From:
844 t-ishii@pgfoundry.org (User T-ishii) To:
845 pgpool-committers@pgfoundry.org Date: Tue, 30 Dec 2008 01:05:37
848 2009-01-07 22:27 t-ishii
850 * pool_connection_pool.c (1.13, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
851 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pool_proto_modules.c
852 (1.5): Update copyright year
854 2009-01-02 18:38 t-ishii
856 * pool_process_query.c (1.130): Emit pool_error when detects kind
857 mismatch error. Before we only sent error messages to client, but
858 this will leave only on client, which may or may not be kept.
859 Leaving it on pgpool log should leave on pgpool side at least.
861 2008-12-31 23:45 t-ishii
863 * child.c (1.25), main.c (1.43): Fix typos in comments. Patch
864 contributed by Jun Kuriyama.
866 2008-12-31 23:42 t-ishii
868 * pool_sema.c (1.5, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
869 V2_2_0_BETA2, V2_2_0_BETA1): Enhance error message when failed to
870 create semaphores. Patch contributed by Jun Kuriyama.
872 2008-12-31 19:25 t-ishii
874 * pcp/: pcp.c (1.8), pcp.h (1.4), pcp_attach_node.c (1.3),
875 pcp_detach_node.c (1.3), pcp_node_count.c (1.3), pcp_node_info.c
876 (1.3), pcp_proc_count.c (1.4), pcp_proc_info.c (1.3),
877 pcp_recovery_node.c (1.4), pcp_stop_pgpool.c (1.3),
878 pcp_systemdb_info.c (1.3) (utags: V2_2_0, V2_2_0_BETA1,
879 V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3,
880 V2_2_4): Add -d (debug)option to pcp commands. patch contributed
883 2008-12-30 21:16 t-ishii
885 * pool.h (1.34), pool_process_query.c (1.129), pool_proto_modules.c
886 (1.4): Enhance "kind mismatch" error message to include original
887 query. This would not work for extended query, though.
889 2008-12-30 10:05 t-ishii
891 * pool_process_query.c (1.128): Fix detect_error() so that it
892 ignores NOTICE. Without this following error occurs, for example:
896 ERROR: kind mismatch among backends 0[N] 1[E]
898 2008-12-30 09:59 t-ishii
900 * child.c (1.24), main.c (1.42), pool.h (1.33), pool_auth.c (1.14,
901 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pool_type.h
902 (1.9, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
903 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Fix bug with query
904 cancel. It seems this has not been working since pgpool-II was born.
906 To fix this, now we have each connection's pid and cancel key in the
907 shared memory area. If a cancel packet is sent, the table is
908 searched by the pid and the cancel key. If found, the actual cancel
909 key is sent to each backend.
911 2008-12-27 16:26 t-ishii
913 * config.h.in (1.7, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
914 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Update
917 2008-12-23 21:26 t-ishii
919 * pool_process_query.c (1.127): Fix unnessary code(maybe copy &
920 paste error?) Take out internal transction starting code from
923 2008-12-23 21:24 t-ishii
925 * pool_proto_modules.c (1.3): Fix Query() so that it starts
926 transaction *before* checking insert lock is needed or not
928 2008-12-23 21:21 t-ishii
930 * child.c (1.23): Do not make a connection cache for postgres
933 2008-12-21 21:57 t-ishii
935 * pgpool.conf.sample (1.24): Change insert_lock's default value to
936 true. Since automatic SERIAL data type is implemented, always making
937 insert_lock to true is harmless.
939 2008-12-21 08:02 t-ishii
941 * pool.h (1.32), pool_config.c (1.26), pool_process_query.c
942 (1.126): If SERIAL data type is used(checked in system catalog)
943 and insert_lock is true(now default) then automatically lock the
946 2008-12-21 07:59 t-ishii
948 * pool_config.l (1.23): Now insert_lock is defaulted to be true
950 2008-12-20 20:21 t-ishii
952 * pool_process_query.c (1.125): Fix need_insert_lock() so that it
953 runs a little bit faster with no INSERT case.
955 2008-12-20 20:12 t-ishii
957 * pool_proto_modules.c (1.2): Enhance and fix comments related to
960 2008-12-13 20:25 t-ishii
962 * parser/gram.c (1.10, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0),
963 Makefile.am (1.21), Makefile.in (1.25), parser/gram.h (1.9,
964 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0) (utags: V2_2_0_BETA1,
965 V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2): Update generated files
967 2008-12-13 20:23 t-ishii
969 * pool_process_query.c (1.124), pool_proto_modules.c (1.1),
970 pool_proto_modules.h (1.1, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
971 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Refactor
972 pool_process_query.c. Now it is devided into pool_process_query.c
973 and pool_proto_modules.c. Also pool_proto_modules.h added which is
974 a companion header file.
976 2008-12-13 20:21 t-ishii
978 * main.c (1.41): Fix comment
980 2008-12-13 17:20 t-ishii
982 * pool_process_query.c (1.123): Fix Execute() to avoid kind
983 mismatch error caused by "SET TRANSACTION ISOLATION LEVEL must be
984 called before any query".
986 2008-12-13 17:13 t-ishii
988 * pool_process_query.c (1.122): Avoid kind mismatch error caused by
989 "SET TRANSACTION ISOLATION LEVEL must be called before any query".
990 This could happen in following scenario:
994 * M:S1:SELECT 1; <-- only sent to MASTER
995 * M:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
996 * S:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
998 * S: <-- ok since no previous SELECT is sent. kind mismatch error
1001 Fix ReadyForQuery() by calling pool_unread if backend after
1002 do_error_command executed not returns read for query packet.
1006 2008-12-08 22:48 t-ishii
1008 * pool_process_query.c (1.121): Check serialization failure error
1009 and abort all nodes if so. Otherwise we allow data inconsistency
1010 among DB nodes. See following scenario: (M:master, S:slave)
1012 M:S1:BEGIN; M:S2:BEGIN; S:S1:BEGIN; S:S2:BEGIN; M:S1:SET TRANSACTION
1013 ISOLATION LEVEL SERIALIZABLE; M:S2:SET TRANSACTION ISOLATION LEVEL
1014 SERIALIZABLE; S:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
1015 S:S2:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; M:S1:UPDATE t1
1016 SET i = i + 1; S:S1:UPDATE t1 SET i = i + 1; M:S2:UPDATE t1 SET i =
1017 i + 1; <-- blocked S:S1:COMMIT; M:S1:COMMIT; M:S2:ERROR: could not
1018 serialize access due to concurrent update S:S2:UPDATE t1 SET i = i +
1019 1; <-- success in UPDATE and data becomes inconsistent!
1021 2008-12-08 21:38 t-ishii
1023 * pool_process_query.c (1.120): Forget to add free_string()
1025 2008-12-08 21:32 t-ishii
1027 * pool_process_query.c (1.119): Fix uninitialized variable in
1028 read_kind_from_backend. Also refactor to make it more effective and
1029 readable. Add lots of comments and enhance error message to display
1032 2008-12-05 23:38 t-ishii
1034 * pool_process_query.c (1.118): Fix client_idle_limit_in_recovery
1035 handling not to hang when goes into 2nd stage. Also fix grammatical
1038 2008-11-27 09:30 t-ishii
1040 * pool_auth.c (1.13): Fix thoughtless coding in MD5 case checking.
1041 We should have considered raw mode case. Bug pointed out by Duco
1042 Fijma. See discussions below for more details. Subject:
1043 [Pgpool-general] MD5 authentication in "raw mode" From: Duco Fijma
1044 <duco@fijma.net> To: pgpool-general@pgfoundry.org Date: Tue, 25 Nov
1047 2008-11-15 16:10 t-ishii
1049 * pool_process_query.c (1.117): Fix pool_discard_packet. Missing
1050 statement in the last commit.
1052 2008-11-15 15:15 t-ishii
1054 * pool_process_query.c (1.116): Fix do_error_command. If mistakely
1055 assumed that after sending an error query, always ReadyForQuery came
1056 right after that. If some debugging or logging verboseness is set,
1057 PostgreSQL might sends NOTICE before ReadyForQuery.
1059 2008-11-12 22:42 t-ishii
1061 * pool_process_query.c (1.115): Fix do_command in case of notice
1062 message sent right after Complete command response. See threads in
1065 Subject: Re: [Pgpool-general] Pgpool-II - replication problems From:
1066 "nir osovsky" <nosovsky1@gmail.com>
1070 2008-11-10 09:58 t-ishii
1072 * pool_process_query.c (1.114): Enhance error message in do_command
1074 2008-11-07 18:20 t-ishii
1076 * ChangeLog (1.35), Makefile.in (1.24), aclocal.m4 (1.16, V2_2_4,
1077 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1078 V2_2_0_BETA2, V2_2_0_BETA1), configure (1.25), pgpool.conf.sample
1079 (1.23), pool.h (1.31), pool_config.c (1.25), pool_config.l
1080 (1.22), pool_process_query.c (1.113), pool_stream.c (1.13),
1081 doc/pgpool-en.html (1.32), doc/pgpool-ja.html (1.53),
1082 parser/Makefile.in (1.16, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1083 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1),
1084 pcp/Makefile.in (1.15, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1085 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Add
1086 client_idle_limit_in_recovery
1088 2008-10-31 14:21 t-ishii
1090 * doc/load_balance.odp (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1091 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Add
1092 a flow chart which explains load balance/replication/send to master
1095 2008-10-31 10:31 t-ishii
1097 * doc/: pgpool-en.html (1.31), pgpool-ja.html (1.52): Fix wording
1098 Fix description for replicate_select and "condition for load
1101 2008-10-31 10:28 t-ishii
1103 * pgpool.conf.sample (1.22): Fix incorrect comment for
1106 2008-09-05 13:25 t-ishii
1108 * main.c (1.40): Fix and enhance comments
1110 2008-08-29 14:17 t-ishii
1112 * pool_process_query.c (1.112): Allow to load balance DECLARE,
1113 FETCH and CLOSE. Also fix comments.
1115 2008-08-29 11:54 t-ishii
1117 * main.c (1.39): Fix bug in fork_a_child which mistakely closed
1118 pipe fds which are not created yet at the startup time
1120 2008-08-28 21:37 t-ishii
1122 * pool_process_query.c (1.111): Fix/enhance log messages and
1125 2008-08-28 21:35 t-ishii
1128 - Close all file descriptors when running in daemon mode. Otherwise
1129 we inherit socket from apache when it's started by pgpoolAdmin.
1130 This results in that port 80 is occupied for example. Pach
1131 provided by Akio Ishida. Also add chdir("/"). This always good for
1134 - Always fail over and restart all children. Before we do not
1135 restart if master has not been changed. This was wrong. If we have
1136 trouble with network cable or something, TCP/IP stack keeps on
1137 retrying for long time and the only way to prevent it is restarting
1140 2008-07-23 17:50 y-asaba
1142 * NEWS (1.23), configure (1.24), configure.in (1.22),
1143 doc/pgpool-ja.html (1.51) (utags: V2_1_0): Prepare for 2.1.
1145 2008-07-08 16:53 y-mori
1147 * ChangeLog (1.34, V2_1_0), NEWS (1.22) (utags: V2_1_0_RC1):
1148 Prepare for pgpool-II 2.1 RC1.
1149 -add comment to ChangeLog NEWS
1151 2008-07-08 16:41 y-mori
1153 * NEWS (1.21): FIX indent
1155 2008-07-08 16:37 y-mori
1157 * doc/pgpool-ja.html (1.50, V2_1_0_RC1): Update release note
1158 parallel query bug fix comment
1160 2008-07-08 16:21 y-asaba
1162 * Makefile.in (1.23, V2_1_0), aclocal.m4 (1.15, V2_1_0), configure
1163 (1.23), configure.in (1.21), parser/Makefile.in (1.15, V2_1_0),
1164 pcp/Makefile.in (1.14, V2_1_0) (utags: V2_1_0_RC1): Prepare for
1167 2008-07-04 22:00 y-mori
1169 * pool_rewrite_outfuncs.c (1.15, V2_2_2, V2_2_1, V2_2_0,
1170 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1171 V2_1_0_RC1): FIX: query rewrite of DISTINCT ON
1173 2008-07-04 14:27 y-mori
1175 * pool.h (1.30, V2_1_0, V2_1_0_RC1), pool_process_query.c (1.110,
1176 V2_1_0, V2_1_0_RC1), pool_rewrite_outfuncs.c (1.14),
1177 pool_rewrite_query.c (1.10, V2_1_0, V2_1_0_RC1), pool_stream.c
1178 (1.12, V2_1_0, V2_1_0_RC1): FIX: join partitioned tables
1180 Delete: pool_read_parallel
1182 2008-07-01 21:26 y-mori
1184 * pool_rewrite_outfuncs.c (1.13): fix: Converting JOIN expression
1185 from USING to ON in query rewriting at parallel mode
1187 2008-06-30 16:05 y-mori
1189 * pool_process_query.c (1.109): Fix Hung up when two or more insert
1190 statment was executed in parallel mode
1192 2008-05-30 16:18 y-asaba
1194 * pool_process_query.c (1.108): Fixed segfault if client protocol
1197 2008-05-22 23:36 y-asaba
1199 * main.c (1.37, V2_1_0, V2_1_0_RC1): If a backend raised FATAL
1200 error while health checking, do not send a Terminate message.
1201 Because sending the message fails with EPIPE.
1203 2008-05-08 12:02 y-asaba
1205 * child.c (1.22, V2_1_0, V2_1_0_RC1): Fix segfault if all weight
1206 values are zero and master node is down. Perf report by Michael
1209 2008-05-04 14:04 y-asaba
1211 * sql/pgpool-recovery/pgpool-recovery.c (1.6, V2_2_2, V2_2_1,
1212 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1213 V2_1_0, V2_1_0_RC1): Use snprintf().
1215 2008-04-12 03:09 devrim
1217 * pgpool.spec (1.13, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1218 V2_1_0, V2_1_0_RC1): Sync with community spec file. Fix
1221 2008-04-09 16:45 y-asaba
1223 * redhat/pgpool.init (1.4, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1224 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1):
1225 * Remove non-ascii character.
1226 * Fix the daemon stdio redirection.
1228 Per report by kabe-san.
1230 2008-04-09 16:03 y-asaba
1232 * sample/replicate_def_pgbench.sql (1.2, V2_2_4, V2_2_3, V2_2_2,
1233 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1234 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): Fix SQL error.
1236 2008-04-09 16:01 y-asaba
1238 * sql/system_db.sql (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1239 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1240 V2_1_0_RC1): Drop replicate_def table if exists.
1242 2008-04-09 15:26 devrim
1244 * redhat/pgpool.init (1.3):
1245 - Honor /etc/sysconfig/pgpool settings. Previously we could never
1246 customize PGPOOLPID=/var/run/pgpool.pid et al.
1247 - Remaining hardcoded paths replaced by customizable variables
1248 such as $PGPOOLCONF .
1250 2008-04-09 15:22 y-asaba
1252 * Makefile.am (1.20, V2_1_0, V2_1_0_RC1), Makefile.in (1.22): Add
1253 sample/replicate_def_pgbench.sql into a release tar ball.
1255 2008-04-07 01:49 devrim
1257 * pgpool.spec (1.12): Update to 2.1 beta2
1259 2008-04-04 13:32 y-asaba
1261 * NEWS (1.20), doc/pgpool-ja.html (1.49) (utags: V2_1_0_BETA2):
1262 Update 2.1 release note.
1264 2008-04-03 22:10 y-asaba
1266 * pool_process_query.c (1.107, V2_1_0_BETA2): Fix hang up in
1269 We sended a syntax error query to abort a transaction if
1270 replicate_select was true. However, the query was sended over Query
1271 message. In extended query mode, we *must* send the query over
1272 Execute message. Because postgres discards messages until a Sync is
1273 reached when an error is detected.
1275 2008-04-03 14:44 y-asaba
1277 * ChangeLog (1.33, V2_1_0_BETA2): Add.
1279 2008-04-03 14:30 y-asaba
1281 * pool_process_query.c (1.106): Do not close a internal transaction
1282 when Sync message is received after receiving Parse message. This
1283 hack is for PHP-PDO.
1285 2008-04-02 11:48 y-asaba
1287 * NEWS (1.19), doc/pgpool-ja.html (1.48): Update release note.
1289 2008-04-01 17:31 y-asaba
1291 * configure (1.22), configure.in (1.20) (utags: V2_1_0_BETA2):
1292 Prepare for 2.1 beta2.
1294 2008-04-01 10:12 y-asaba
1296 * pool_rewrite_outfuncs.c (1.12, V2_1_0_BETA2): Fix "AS" handling
1297 in FROM clause. Patch contributed by sho-san.
1299 2008-03-31 17:27 y-asaba
1301 * pgpool.8.in (1.4, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1302 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Enhance manpage.
1303 patch contributed by kabe-san.
1304 - no hypenation, no justify for better greppability
1305 - have explicit subsection for [noargs], stop, switch for
1307 - some phrases rewritten to suit manpages
1310 2008-03-31 17:07 y-asaba
1312 * ChangeLog (1.32): Add items.
1314 2008-03-31 13:19 t-ishii
1316 * TODO (1.14, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Add Docs section
1317 and add an item (writelibpcp docs)
1319 2008-03-31 11:56 y-asaba
1321 * NEWS (1.18), doc/pgpool-ja.html (1.47): Add a item into 2.1
1324 2008-03-28 01:06 y-asaba
1326 * child.c (1.21), pool_hba.c (1.5, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1327 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1328 V2_1_0_RC1) (utags: V2_1_0_BETA2): Use child_exit() instead of
1331 2008-03-28 01:04 y-asaba
1333 * pcp_child.c (1.11, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
1334 V2_2_0_RC1, V2_2_0_BETA2), recovery.c (1.11) (utags: V2_1_0,
1335 V2_1_0_BETA2, V2_1_0_RC1, V2_2_0_BETA1): Fix a race condition
1336 between SIGUSR2 signal and pause().
1338 2008-03-28 01:01 y-asaba
1340 * pool_connection_pool.c (1.12, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2):
1341 Fix core dump with the following scenario.
1343 2. create connection pool
1345 4. reuse the connection pool
1347 2008-03-27 17:26 y-asaba
1349 * doc/pgpool-ja.html (1.46): Remove a wrong restriction.
1351 2008-03-27 16:54 y-asaba
1353 * doc/: pgpool-en.html (1.30, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2),
1354 pgpool-ja.html (1.45), pgpool.css (1.6, V2_2_4, V2_2_3, V2_2_2,
1355 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1356 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2), tutorial-en.html
1357 (1.6, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
1358 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
1359 V2_1_0_BETA2), tutorial-ja.html (1.5, V2_2_4, V2_2_3, V2_2_2,
1360 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1361 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Add copyright.
1363 2008-03-27 16:24 y-asaba
1365 * doc/: tutorial-en.html (1.5), tutorial-ja.html (1.4): Add an
1366 example to rotate pgpool log files.
1368 2008-03-27 11:53 y-asaba
1370 * pool_process_query.c (1.105): Improve network I/O routine.
1372 2008-03-27 11:51 t-ishii
1374 * doc/pgpool-en.html (1.29): Add description about the timing of
1375 recovery command invocation
1377 2008-03-27 11:49 t-ishii
1379 * TODO (1.13): Add TODO items
1381 2008-03-26 18:18 t-ishii
1383 * doc/pgpool-ja.html (1.44): Add description about the timing of
1384 recovery command invocation
1386 2008-03-25 14:15 t-ishii
1388 * TODO (1.12): Add more TODO
1390 2008-03-25 10:00 t-ishii
1392 * TODO (1.11): Translate into English
1394 2008-03-20 17:33 t-ishii
1396 * doc/: pgpool-en.html (1.28), pgpool-ja.html (1.43): Enhance
1397 reset_query_list description.
1399 2008-03-20 16:33 t-ishii
1401 * doc/: pgpool-en.html (1.27), pgpool-ja.html (1.42): Add info
1402 about pgpool-II download page.
1404 2008-03-18 17:39 y-asaba
1406 * pgpool.conf.sample (1.21, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2):
1407 Remove ";" in recovery_timeout.
1409 2008-03-14 16:09 y-asaba
1411 * doc/: pgpool-en.html (1.26), pgpool-ja.html (1.41) (utags:
1413 * Changed title from README to user manual.
1414 * Emphasized load balancing note.
1416 2008-03-14 16:06 y-asaba
1418 * doc/pgpool.css (1.5, V2_1_0_BETA1): Add <h4> style.
1420 2008-03-14 15:57 y-asaba
1422 * NEWS (1.17, V2_1_0_BETA1): Reviewed.
1424 2008-03-14 15:53 y-asaba
1426 * doc/pgpool-en.html (1.25): Updated English documentation.
1428 2008-03-14 15:30 y-asaba
1430 * doc/pgpool-ja.html (1.40): Add recovery_timeout description.
1432 2008-03-14 14:45 y-asaba
1434 * NEWS (1.16): Added 2.1 beta release note. I hope to review it.
1436 2008-03-14 11:43 y-asaba
1438 * doc/pgpool-ja.html (1.39): Added 2.1 release note.
1440 2008-03-14 11:00 y-asaba
1442 * pgpool.conf.sample (1.20, V2_1_0_BETA1): Add comment for '%M'
1445 2008-03-14 10:35 y-asaba
1447 * ChangeLog (1.31, V2_1_0_BETA1): Add entries.
1449 2008-03-13 22:11 y-asaba
1451 * pool_process_query.c (1.104, V2_1_0_BETA1):
1452 * Fixed kind mismatch error in master slave mode with following
1453 scenario. This bug was introduced in pgpool-II v2.0.
1456 SET client_encoding TO SJIS;
1458 * Fixed load balancing in master slave mode. This bug was introduced
1461 2008-03-13 16:01 y-asaba
1463 * pg_md5.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
1464 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
1465 V2_1_0_BETA2, V2_1_0_BETA1): Fix compile error on FreeBSD. Per
1466 report by ISHIDA Akio.
1468 2008-03-13 12:46 y-asaba
1470 * ylwrap (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
1471 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
1472 V2_1_0_BETA2, V2_1_0_BETA1): Add ylwrap generated by automake
1475 2008-03-13 03:22 devrim
1477 * pgpool.spec (1.11, V2_1_0_BETA2, V2_1_0_BETA1): Update to 2.1
1480 2008-03-12 21:33 y-asaba
1482 * configure (1.21), configure.in (1.19) (utags: V2_1_0_BETA1):
1485 2008-03-12 18:33 t-ishii
1487 * pgpool.conf.sample (1.19): Fix comments for load_balance_mode
1488 which were no longer true.
1490 2008-03-12 18:32 y-asaba
1492 * pool_config.c (1.24, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1493 V2_1_0_BETA1): Run flex v2.5.33
1495 2008-03-12 18:32 y-asaba
1497 * version.h (1.4, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1):
1498 Change version string.
1500 2008-03-12 18:31 y-asaba
1502 * child.c (1.20, V2_1_0_BETA1), pool_process_query.c (1.103): If
1503 load_balance_mode is false, then pgpool does not calculate load
1506 2008-03-12 14:06 y-asaba
1508 * main.c (1.36, V2_1_0_BETA2, V2_1_0_BETA1): health_check_timeout
1509 did not work correctly. Report and patch by Kenichi Sawada.
1511 2008-03-12 14:00 y-asaba
1513 * main.c (1.35): Improve bind(2) and unlink(2) error message.
1514 Patch contributed by Jun Kuriyama.
1516 2008-03-12 13:53 y-asaba
1518 * pcp/pcp_recovery_node.c (1.3, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1519 V2_1_0_BETA1): Fix typos in pcp_recovery_node.c usage. Patch
1520 contributed by Jun Kuriyama.
1522 2008-03-12 13:51 y-asaba
1524 * Makefile.in (1.21, V2_1_0_BETA2, V2_1_0_BETA1), aclocal.m4 (1.14,
1525 V2_1_0_BETA2, V2_1_0_BETA1), config.h.in (1.6, V2_1_0,
1526 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), configure (1.20),
1527 configure.in (1.18), parser/Makefile.in (1.14, V2_1_0_BETA2,
1528 V2_1_0_BETA1), pcp/Makefile.in (1.13, V2_1_0_BETA2,
1529 V2_1_0_BETA1): Support set_ps_display on FreeBSD. Patch
1530 contributed by ISHIDA Akio.
1532 2008-03-12 12:54 t-ishii
1534 * pool_auth.c (1.12, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1535 V2_1_0_BETA1): Add detailed error messages when auth phase fail.
1538 pool_read_message_length: message length (8 ) in slot 1 does not
1539 match with slot 0(12)
1541 is confusing and does very little help.
1543 2008-03-12 11:01 y-asaba
1545 * pool_process_query.c (1.102): Fixed DEALLOCATE ALL processing.
1547 2008-03-11 12:04 y-asaba
1549 * ChangeLog (1.30): Added entries.
1551 2008-03-11 11:54 y-asaba
1553 * main.c (1.34), doc/pgpool-en.html (1.24), doc/pgpool-ja.html
1555 * Add '%M'format to obtain old master node ID into failover_command
1556 and failback_command.
1558 * When master node was down, killed all children process during
1559 executing failover_command.
1561 * Fixed SIGSEGV if backend0 was undefined.
1563 2008-03-11 11:49 y-asaba
1565 * pool_process_query.c (1.101): Fixed hang up if a node was
1566 executed immediate shutdown.
1568 2008-03-11 00:08 t-ishii
1570 * pool_auth.c (1.11): Fix using uninialized varible in
1571 pool_read_message_length()
1573 2008-03-10 13:37 t-ishii
1575 * pool_process_query.c (1.100): [no log message]
1577 2008-03-04 16:58 y-asaba
1579 * ChangeLog (1.29): Add entries.
1581 2008-03-03 12:39 y-asaba
1583 * pool_process_query.c (1.99): Fix hang up after processing "show
1584 pool_status". Per report by ISHIDA Akio.
1586 2008-02-29 13:49 yamaguti
1588 * ChangeLog (1.28): added entry for the change in pg_md5.c
1590 2008-02-29 13:40 yamaguti
1593 * implement password prompt with option "-p" (patch contributed by
1596 * disable ECHO while reading password from stdin
1598 2008-02-26 18:55 y-asaba
1602 - Add -v option, which prints version info.
1604 2008-02-25 20:22 y-asaba
1606 * recovery.c (1.10, V2_1_0_BETA1): Improve error message.
1608 2008-02-25 11:58 y-asaba
1610 * pool_process_query.c (1.98): Fix asynchronous query handling.
1612 When ReadyForQuery message was received, pgpool set off
1613 loadbalancing flag, internal transaction flag and so on. If client
1614 sended a Query message before receiving the ReadyForQuery message,
1615 pgpool reported error message.
1617 So, we block the Query message while backend nodes process a query.
1619 2008-02-20 19:12 y-asaba
1621 * pool_process_query.c (1.97): Return TRUE in is_select_query() if
1622 a query is "COPY TO STDOUT". kind mismatching error was caused by
1623 pg_dump or pg_dumpall. Per report by Bruno Lustosa.
1625 2008-02-19 14:54 y-asaba
1627 * Makefile.in (1.20), aclocal.m4 (1.13), configure (1.19),
1628 configure.in (1.17): Stamp 2.1-devel. We hope to release 2.1 on
1631 2008-02-19 14:46 y-asaba
1633 * pool_process_query.c (1.96): Fix HINT clause handling in extended
1634 query protocol. pgpool did not replicate the following query with
1635 extended query protocol.
1637 /* REPLICATION */ SELECT func();
1639 Per report by Sagar Thapa.
1641 2008-02-19 14:18 y-asaba
1643 * pool_process_query.c (1.95): Fix misspell. Patch contributed by
1646 2008-02-18 18:58 y-asaba
1648 * pool_stream.c (1.11, V2_1_0_BETA2, V2_1_0_BETA1): Add error
1651 2008-02-15 18:43 y-asaba
1653 * main.c (1.32): Polling signals per 3 secs when health check is
1656 2008-02-15 18:36 y-asaba
1658 * main.c (1.31): Fix zombie process problem. "switching" flag did
1659 not clear when invalid node ID was detached.
1661 2008-02-15 15:19 y-asaba
1663 * pool_process_query.c (1.94): Fix DISCARD statement handling.
1665 2008-02-15 13:04 y-asaba
1667 * main.c (1.30): Fix compiler warning.
1669 2008-02-14 14:48 y-asaba
1671 * main.c (1.29): Add comment.
1673 2008-02-14 14:24 y-asaba
1675 * ChangeLog (1.27): Add ChangeLog items.
1677 2008-02-14 14:09 y-asaba
1679 * main.c (1.28): Fix a failover bug that pgpool did not determine a
1680 next master node in raw_mode.
1682 2008-02-14 14:05 y-asaba
1684 * pool_connection_pool.c (1.11, V2_1_0_BETA1): Do not create
1685 connection cache to standby nodes in raw_mode. As a result, we can
1686 use pgpool-II + warm standby with raw_mode.
1688 2008-02-12 20:16 y-asaba
1690 * child.c (1.19), pgpool.conf.sample (1.18), pool.h (1.29,
1691 V2_1_0_BETA2, V2_1_0_BETA1), pool_config.c (1.23), pool_config.l
1692 (1.21, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1693 pool_process_query.c (1.93), pool_stream.c (1.10),
1694 doc/pgpool-en.html (1.23), doc/pgpool-ja.html (1.37): Remove
1695 "replication_timeout" parameter.
1697 This parameter was enabled if replication_strict = false. However
1698 replication_strict was already removed.
1700 2008-02-12 16:29 yamaguti
1702 * pool.h (1.28): Fix a bug in raw mode where only 1 of multiple
1703 nodes were recognized by pgpool.
1705 2008-02-08 19:57 y-asaba
1707 * pool_stream.c (1.9): Fix wrong timeout handling in pool_read2()
1708 and pool_read_string().
1710 2008-02-08 17:10 yamaguti
1712 * pcp/pcp.c (1.7, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1):
1713 Disabled PCP client's timeout.
1715 PCP commands still take timeout option, but ignores and set
1718 2008-02-08 15:47 y-asaba
1720 * sql/pgpool-recovery/pgpool-recovery.c (1.5, V2_1_0_BETA2,
1721 V2_1_0_BETA1): PostgreSQL superuser can *only* execute
1722 pgpool_recovery and pgpool_remote_start functions because of
1725 2008-02-08 15:47 yamaguti
1727 * main.c (1.27), pcp_child.c (1.10, V2_1_0_BETA1), recovery.c
1728 (1.9): Implemented configuration file "reload" function into PCP.
1730 2008-02-08 13:11 yamaguti
1732 * recovery.c (1.8): Use "recovery_timeout" to decide how long
1733 pgpool should wait before online-recovery fails.
1735 2008-02-08 13:10 yamaguti
1737 * pgpool.conf.sample (1.17), pool.h (1.27), pool_config.c (1.22),
1738 pool_config.l (1.20): added a new configuration parameter
1741 pgpool waits so many seconds, specified by recovery_timeout, for:
1743 1) all client connections are closed before the 2nd stage
1744 2) a remote host to start up in the final stage
1746 Note that "recovery_timeout = 0" means NO WAIT; not no timeout.
1748 2008-02-05 19:05 y-asaba
1750 * pool_auth.c (1.10): Fix minor bug introduced by previous commit.
1752 2008-02-05 18:57 y-asaba
1754 * pool_auth.c (1.9): Fix authentication error when master was down.
1756 2008-02-05 11:13 y-asaba
1758 * pool_process_query.c (1.92): Remove unneccesary flushing output
1761 2008-01-29 11:01 y-asaba
1763 * doc/pgpool-ja.html (1.36): Add description of recovery script.
1765 2008-01-29 10:56 y-asaba
1767 * ChangeLog (1.26), child.c (1.18), main.c (1.26), pcp_child.c
1768 (1.9), pool.h (1.26), pool_auth.c (1.8), pool_config.c (1.21),
1769 pool_config.l (1.19), pool_connection_pool.c (1.10), pool_error.c
1770 (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1771 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1772 V2_1_0_BETA1), pool_hba.c (1.4, V2_1_0_BETA1), pool_ip.c (1.2,
1773 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1774 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1775 V2_1_0_BETA1), pool_ip.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1776 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1777 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_ipc.h (1.3,
1778 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1779 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1780 V2_1_0_BETA1), pool_params.c (1.3, V2_2_3, V2_2_2, V2_2_1,
1781 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1782 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_path.c
1783 (1.2, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1784 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1785 V2_1_0_BETA1), pool_path.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1786 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1787 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1788 pool_process_query.c (1.91), pool_query_cache.c (1.9, V2_2_3,
1789 V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1790 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1791 pool_rewrite_query.c (1.9, V2_1_0_BETA2, V2_1_0_BETA1),
1792 pool_rewrite_query.h (1.6, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1793 V2_1_0_BETA1), pool_sema.c (1.4, V2_1_0, V2_1_0_RC1,
1794 V2_1_0_BETA2, V2_1_0_BETA1), pool_shmem.c (1.3, V2_2_2, V2_2_1,
1795 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1796 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_signal.c
1797 (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1798 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1799 V2_1_0_BETA1), pool_signal.h (1.4, V2_2_4, V2_2_3, V2_2_2,
1800 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1801 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1802 pool_stream.c (1.8), pool_system.c (1.5, V2_2_3, V2_2_2, V2_2_1,
1803 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1804 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_type.h
1805 (1.8, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1806 ps_status.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1807 V2_1_0_BETA1), recovery.c (1.7), strlcpy.c (1.2, V2_2_3, V2_2_2,
1808 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1809 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1810 COPYING (1.3, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1811 V2_1_0_BETA1), pcp/Makefile.in (1.12), pcp/pcp.c (1.6), pcp/pcp.h
1812 (1.3, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1813 pcp/pcp_attach_node.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1814 V2_1_0_BETA1), parser/Makefile.in (1.13), parser/copyfuncs.c
1815 (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
1816 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
1817 V2_1_0_BETA2, V2_1_0_BETA1), parser/gram.c (1.9, V2_1_0,
1818 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_detach_node.c
1819 (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1820 pcp/pcp_error.c (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1821 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1822 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_node_count.c
1823 (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1824 pcp/pcp_node_info.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1825 V2_1_0_BETA1), pcp/pcp_proc_count.c (1.3, V2_1_0, V2_1_0_RC1,
1826 V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_proc_info.c (1.2, V2_1_0,
1827 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_recovery_node.c
1828 (1.2), pcp/pcp_stop_pgpool.c (1.2, V2_1_0, V2_1_0_RC1,
1829 V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_stream.c (1.4, V2_2_4,
1830 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1831 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1832 V2_1_0_BETA1), pcp/pcp_stream.h (1.2, V2_2_4, V2_2_3, V2_2_2,
1833 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1834 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1835 pcp/pcp_systemdb_info.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1836 V2_1_0_BETA1), sql/pgpool-recovery/pgpool-recovery.c (1.4),
1837 parser/gram.h (1.8, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1838 V2_1_0_BETA1), parser/gram.y (1.5, V2_2_4, V2_2_3, V2_2_2,
1839 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1840 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1841 parser/keywords.c (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1842 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1843 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/keywords.h (1.3,
1844 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1845 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1846 V2_1_0_BETA1), parser/list.c (1.3, V2_2_4, V2_2_3, V2_2_2,
1847 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1848 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1849 parser/makefuncs.c (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1850 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1851 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/makefuncs.h (1.3,
1852 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1853 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1854 V2_1_0_BETA1), parser/memnodes.h (1.2, V2_2_4, V2_2_3, V2_2_2,
1855 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1856 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1857 parser/nodes.c (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1858 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1859 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/nodes.h (1.3,
1860 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1861 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1862 V2_1_0_BETA1), parser/outfuncs.c (1.6, V2_2_4, V2_2_3, V2_2_2,
1863 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1864 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1865 parser/parsenodes.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1866 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1867 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/parser.h (1.3,
1868 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1869 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1870 V2_1_0_BETA1), parser/pg_list.h (1.3, V2_2_4, V2_2_3, V2_2_2,
1871 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1872 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1873 parser/pool_memory.c (1.10, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1874 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1875 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1876 parser/pool_memory.h (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1877 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1878 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1879 parser/pool_parser.h (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1880 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1881 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1882 parser/pool_string.c (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1883 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1884 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1885 parser/pool_string.h (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
1886 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
1887 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1888 parser/primnodes.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1889 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1890 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/scan.c (1.8,
1891 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1892 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1893 V2_1_0_BETA1), parser/scan.l (1.5, V2_2_4, V2_2_3, V2_2_2,
1894 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1895 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
1896 parser/scansup.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
1897 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
1898 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/value.c (1.3,
1899 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1900 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1901 V2_1_0_BETA1), parser/value.h (1.3, V2_2_4, V2_2_3, V2_2_2,
1902 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
1903 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1):
1906 2008-01-28 11:31 y-asaba
1908 * ChangeLog (1.25): Add item.
1910 2008-01-28 11:26 y-asaba
1912 * pool_process_query.c (1.90): Change log level of the following
1913 message from ERROR to LOG.
1915 ProcessFrontendResponse: failed to read kind from frontend. fronend
1918 This means that pgpool detects unexpected EOF. This is not pgpool's
1921 2008-01-25 18:49 y-asaba
1923 * ChangeLog (1.24): Add item.
1925 2008-01-25 16:20 y-asaba
1927 * pool_process_query.c (1.89): Load balancing node was changed
1928 after processing transaction. For example,
1930 SELECT 1; <-- node 1
1932 SELECT 2; <-- node 0(master)
1934 SELECT 3; <-- node 0(master)
1936 "SELECT 3" was sended to a master node, not a load balancing node.
1938 VALID_BACKEND macro does not check node validation if
1939 in_load_balancing is 1. So we do not use VALID_BACKEND macro to
1940 check whether load balancing node is down.
1942 2008-01-19 18:49 y-asaba
1944 * pool_process_query.c (1.88): Add comments.
1946 2008-01-15 11:10 y-asaba
1948 * pool_process_query.c (1.87): Remove unused variable.
1950 2008-01-11 12:11 y-asaba
1952 * pool_process_query.c (1.86): Add comments.
1954 2008-01-11 11:30 y-asaba
1956 * ChangeLog (1.23), main.c (1.25), pool_hba.c (1.3),
1957 pool_process_query.c (1.85), parser/parser.c (1.5, V2_2_4,
1958 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
1959 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
1960 V2_1_0_BETA1), parser/pool_memory.c (1.9), parser/pool_memory.h
1961 (1.4): Fix memory leak at prepared statement list.
1963 pgpool caches a parse tree in prepared statement list. The parse
1964 tree copy deeply, but we freed only the top node of the parse tree.
1966 2008-01-09 18:10 y-asaba
1968 * recovery.c (1.6): Refactoring recovery code.
1970 2008-01-08 13:31 y-asaba
1972 * main.c (1.24): Fix compile error.
1974 2008-01-08 11:20 y-mori
1976 * doc/: tutorial-en.html (1.4), tutorial-ja.html (1.3) (utags:
1977 V2_1_0_BETA1): FIX tutorial
1978 Because replicate_def table is confused dist_def table when a
1979 parallel mode is set according to the tutorial, data is not
1982 2008-01-02 17:32 t-ishii
1984 * main.c (1.23): Fix bug in previous commit Fix typo
1986 2007-12-27 12:00 y-asaba
1988 * ChangeLog (1.22): Add ChangeLog items.
1990 2007-12-27 11:21 y-asaba
1992 * main.c (1.22), pgpool.conf.sample (1.16), doc/pgpool-en.html
1993 (1.22), doc/pgpool-ja.html (1.35): Allow '%m' character to obtain
1994 master node id in failover_command and failback_command.
1996 2007-12-26 16:05 y-asaba
1998 * doc/: pgpool-en.html (1.21), pgpool-ja.html (1.34): Add
1999 multi-statement restriction.
2001 2007-12-26 11:40 y-asaba
2003 * pool_process_query.c (1.84): Fix internal transaction handling in
2004 extended query protocol. pgpool did not send "COMMIT" to close an
2005 internal transaction block.
2007 2007-12-22 09:11 t-ishii
2009 * recovery.c (1.5): Add lots of pool_log to show the recovery steps
2011 2007-12-11 12:59 t-ishii
2013 * main.c (1.21): Change "starting health checking" and "retrying %d
2014 th health checking" log messages to DEBUG messages since they are
2017 2007-12-07 15:35 y-asaba
2019 * TODO (1.10, V2_1_0_BETA1): TODO: Add replication function list.
2021 2007-12-07 14:08 y-asaba
2023 * child.c (1.17), config.h.in (1.5), configure (1.18), configure.in
2024 (1.16), pcp_child.c (1.8), pool_config.c (1.20), pool_config.l
2025 (1.18), pcp/pcp.c (1.5): Fix compile error and warning on Solaris
2028 2007-12-06 13:59 y-mori
2030 * pool_rewrite_query.c (1.8): FIX: INSERT statment in a parallel
2031 mode How to count the Value Clause list was wrong
2033 2007-12-05 17:15 y-asaba
2035 * pool_stream.c (1.7): Improve buffering algorithm in pool_write().
2037 2007-12-03 10:47 y-asaba
2039 * pool_process_query.c (1.83): Don't output log if PostgreSQL send
2040 a warning message in do_command().
2042 2007-12-02 11:45 y-asaba
2044 * pool_process_query.c (1.82): Fix segmentation fault if
2045 CloseComplete command was received.
2047 2007-12-01 23:50 y-asaba
2049 * pool_process_query.c (1.81): Fix memory leak when PREPARE or
2050 DEALLOCATE is failed.
2052 2007-12-01 22:26 y-asaba
2054 * pool_process_query.c (1.80): Remove debug log.
2056 2007-11-30 16:38 y-mori
2058 * pool_rewrite_query.c (1.7): Fix: The INSERT statment did not
2059 correspond to the parser of postgresql 8.3 that pgpool-II 2.0 had.
2060 Therefore, the following errors occur if INSERT is done in a
2063 ERROR: pgpool2 sql restriction
2064 DETAIL: cannot use SElectStmt in InserStmt
2066 2007-11-24 22:04 t-ishii
2068 * doc/: pgpool-en.html (1.20), pgpool-ja.html (1.33): Fix english
2069 docs. Add a link to tutorial.
2071 2007-11-23 09:14 t-ishii
2073 * pool_config.c (1.19), pool_config.l (1.17): Add missing
2074 replicate_select entry. per bug report on [pgsql-jp: 38968].
2076 2007-11-22 04:35 devrim
2078 * pgpool.spec (1.10): Update to 2.0.1
2080 2007-11-21 19:18 y-asaba
2082 * configure (1.17), configure.in (1.15) (utags: V2_0_1): Prepare
2085 2007-11-21 19:09 y-asaba
2087 * NEWS (1.15), doc/pgpool-ja.html (1.32) (utags: V2_0_1): Release
2088 note for pgpool-II 2.0.1.
2090 2007-11-21 18:39 y-asaba
2092 * ChangeLog (1.21, V2_0_1): update.
2094 2007-11-21 18:37 y-asaba
2096 * pool_process_query.c (1.79, V2_0_1): Fix segmentation fault when
2097 UPDATE or DELETE is executed. The bug is critical so we must
2098 release 2.0.1 as soon as possible.
2100 2007-11-21 13:47 y-asaba
2102 * recovery.c (1.4, V2_0_1): Use snprintf() instead of sprintf().
2104 2007-11-21 10:47 y-asaba
2106 * pool_process_query.c (1.78): Send a syntax error query to a
2107 master node when master_slave is true.
2109 2007-11-16 14:29 y-mori
2111 * doc/: pgpool-en.html (1.19, V2_0_1), pgpool-ja.html (1.31)
2112 (utags: V2_0_0): ADD: documents (Setting method of Query cache)
2114 2007-11-16 11:52 y-asaba
2116 * pool_auth.c (1.7, V2_0_1, V2_0_0): Fix segmentation fault in a
2117 password authentication when a node is down.
2119 2007-11-16 10:56 y-asaba
2121 * ChangeLog (1.20, V2_0_0): pgpool-II 2.0
2123 2007-11-16 10:51 y-asaba
2125 * Makefile.in (1.19, V2_0_1), aclocal.m4 (1.12, V2_0_1), configure
2126 (1.16), parser/Makefile.in (1.12, V2_0_1), parser/gram.c (1.8,
2127 V2_0_1), parser/gram.h (1.7, V2_0_1), pcp/Makefile.in (1.11,
2128 V2_0_1) (utags: V2_0_0): Prepare for pgpool-II 2.0.
2130 2007-11-16 10:39 y-asaba
2132 * doc/: pgpool-en.html (1.18), pgpool-ja.html (1.30):
2133 - Fix the sample script of online recovery.
2134 - Add note about timeout of pcp_recovery_node.
2136 2007-11-16 09:20 gleu
2138 * doc/pgpool-en.html (1.17): Typo fix.
2140 2007-11-15 09:39 y-mori
2142 * pool_rewrite_outfuncs.c (1.11, V2_1_0_BETA1),
2143 pool_rewrite_query.h (1.5) (utags: V2_0_0, V2_0_1): FIX: It
2144 corresponed to the following Queries. ex) select * from (select
2145 a,b,c from t1) as t2(d,e,f) ~~~~~
2147 2007-11-14 16:46 y-mori
2149 * pool_process_query.c (1.77, V2_0_0): FIX: The load-balnace was
2150 not functioning in a parallel mode
2152 2007-11-14 13:59 y-mori
2154 * pool_rewrite_outfuncs.c (1.10): FIX:
2155 It made a mistake in the processing of OUTER JOIN (syntax of C
2158 2007-11-14 12:59 y-mori
2160 * pool.h (1.25, V2_0_1, V2_0_0), pool_process_query.c (1.76),
2161 pool_stream.c (1.6, V2_0_1, V2_0_0): fix:
2162 -When the setting of replication_timeout was effective,
2163 SELECT that the execution time is long did the time-out
2164 in only a parallel mode.
2166 -A wrong number was displayed when replicated table was
2167 updated or deleted in only a parallel mode.
2169 2007-11-13 10:44 y-asaba
2171 * configure.in (1.14, V2_0_0): Prepare for pgpool-II 2.0.
2173 2007-11-13 03:12 devrim
2175 * doc/pgpool-en.html (1.16): Removed some garbage chars Fixed
2176 indendation of some paragraphs Fixed some typos
2178 There seems a lot to do btw.
2180 2007-11-12 18:04 y-asaba
2182 * NEWS (1.14, V2_0_0), doc/pgpool-ja.html (1.29): Prepare for
2185 2007-11-12 18:02 y-asaba
2187 * doc/pgpool-ja.html (1.28): Fix typo.
2189 2007-11-12 17:34 y-mori
2191 * doc/tutorial-en.html (1.3, V2_0_1, V2_0_0): add: pgpoo-II 2.0
2192 tutorial -parallel-query section
2194 2007-11-12 15:40 y-mori
2196 * doc/: pgpool-en.html (1.15), pgpool-ja.html (1.27): add:
2197 pgpool-II 2.0 manual.
2198 -add parallel-query section
2204 2007-11-09 16:25 y-mori
2206 * doc/: pgpool-ja.html (1.26), pgpool.css (1.4, V2_0_1, V2_0_0),
2207 tutorial-ja.html (1.2, V2_0_1, V2_0_0): pgpoo-ll 2.0 manual &
2209 - Add parallel query section
2211 2007-11-09 15:09 y-mori
2213 * sample/replicate_def_pgbench.sql (1.1, V2_1_0_BETA2,
2214 V2_1_0_BETA1, V2_0_1, V2_0_0): ADD Sample SQL file
2216 2007-11-09 13:56 y-mori
2218 * sql/system_db.sql (1.2, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1,
2219 V2_0_0): ADD "replicate_def" table in "pgpool_catalog" schema
2221 2007-11-09 13:41 y-asaba
2223 * pgpool.8.in (1.3, V2_1_0_BETA1, V2_0_1, V2_0_0): Add reload
2226 2007-11-09 13:37 y-asaba
2228 * main.c (1.20, V2_0_1, V2_0_0): Add pgpool reload in usage().
2230 2007-11-09 12:00 y-asaba
2232 * Makefile.am (1.19), test/jdbc/README.euc_jp (1.1, V2_2_0_BETA1,
2233 V2_1_0, V2_1_0_RC1) (utags: V2_0_0, V2_0_1, V2_1_0_BETA1,
2234 V2_1_0_BETA2): Add README.euc_jp
2236 2007-11-08 10:43 y-asaba
2238 * doc/pgpool-en.html (1.14): pgpool-II 2.0 manual.
2239 - Add online recovery section.
2240 - Add new parameters.
2242 TODO: review my English...
2244 2007-11-07 19:05 y-asaba
2246 * pool_process_query.c (1.75): Send Sync message before calling
2249 2007-11-07 15:35 y-mori
2251 * pool_rewrite_outfuncs.c (1.9): fix: join rule for /*NOT*/SQL99
2252 type join,CROSS JOIN and NATURAL JOIN
2254 2007-11-06 16:07 y-asaba
2256 * test/jdbc/InsertTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2257 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2258 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2259 test/jdbc/RunTest.java (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2260 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2261 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2262 test/jdbc/pgpool.properties (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2263 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2264 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2265 test/jdbc/prepare.sql (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2266 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2267 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2268 test/jdbc/expected/insert (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2269 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2270 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2271 Makefile.am (1.18): Add INSERT statement test.
2273 2007-11-05 14:26 y-asaba
2275 * pool_process_query.c (1.74): Fix insert_lock with extended query
2278 2007-11-05 11:08 y-asaba
2280 * pool_process_query.c (1.73): Use FD_SETSIZE instead of 1024 at
2281 set_fd, isset_fd and zero_fd.
2283 2007-11-05 10:41 y-asaba
2285 * pool_process_query.c (1.72): Ignore white space in
2288 2007-11-02 18:20 y-mori
2290 * pool_process_query.c (1.71): Fix: compile error at FreeBSD4.1
2292 2007-11-02 01:57 devrim
2294 * pgpool.spec (1.9, V2_0_1, V2_0_0): Update spec file for 2.0 beta1
2296 2007-11-01 19:14 y-asaba
2298 * Makefile.am (1.17): Fix compile error with SUN's cc.
2300 2007-11-01 19:11 y-asaba
2302 * configure.in (1.13), pool_process_query.c (1.70),
2303 parser/Makefile.am (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2304 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2305 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2306 pcp/Makefile.am (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2307 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2308 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0): Fix
2309 compile error with SUN's cc.
2311 2007-11-01 17:17 y-asaba
2313 * pcp/pcp_proc_count.c (1.2, V2_0_1, V2_0_0): Fix warning with
2316 2007-11-01 11:08 t-ishii
2318 * Makefile.in (1.18, V2_0_0_BETA1): Rerun autoconf
2320 2007-11-01 11:01 y-asaba
2322 * Makefile.am (1.16, V2_0_0_BETA1): Remove test.diff
2324 2007-11-01 10:45 t-ishii
2326 * Makefile.in (1.17), aclocal.m4 (1.11, V2_0_0_BETA1), configure
2327 (1.15, V2_0_0_BETA1), pool_config.c (1.18, V2_0_1, V2_0_0,
2328 V2_0_0_BETA1), parser/Makefile.in (1.11, V2_0_0_BETA1),
2329 pcp/Makefile.in (1.10, V2_0_0_BETA1): Run autoconf
2331 2007-10-31 19:45 y-asaba
2333 * NEWS (1.13), pgpool.conf.sample (1.15, V2_0_1, V2_0_0), pool.h
2334 (1.24), pool_config.l (1.16, V2_0_1, V2_0_0),
2335 pool_process_query.c (1.69), doc/pgpool-en.html (1.13),
2336 doc/pgpool-ja.html (1.25) (utags: V2_0_0_BETA1): Remove
2337 replicate_strict derective. pgpool-II 2.x always set to true.
2339 2007-10-31 19:13 y-asaba
2341 * ChangeLog (1.19, V2_0_0_BETA1): pgpool-II 2.0 beta1
2343 2007-10-31 18:41 y-mori
2345 * test/pdo-test/README.euc_jp (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2346 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2347 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2348 V2_0_0_BETA1): ADD: pdo test program manual(Japanese)
2350 2007-10-31 15:10 y-asaba
2352 * doc/pgpool-ja.html (1.24): Add comments about reloadable
2355 2007-10-31 13:15 y-asaba
2357 * pool_config.l (1.15): Allow to reload pcp_timeout.
2359 2007-10-31 12:49 y-mori
2361 * pool_rewrite_outfuncs.c (1.8, V2_0_0_BETA1): FIX: "IN" predicate
2364 2007-10-31 12:31 y-asaba
2366 * NEWS (1.12): pgpool-II 2.0(beta1) release note.
2368 2007-10-30 21:44 t-ishii
2370 * pool_auth.c (1.6, V2_0_0_BETA1): Fix confusing variable name
2371 Enhance error message Check unsupported auth method
2373 2007-10-30 16:13 y-asaba
2375 * pool_process_query.c (1.68): Fix segfault with "SHOW
2378 2007-10-30 16:09 y-asaba
2380 * Makefile.am (1.15): Remove gprof option.
2382 2007-10-30 15:58 y-asaba
2384 * doc/: pgpool-ja.html (1.23), pgpool.css (1.3, V2_0_0_BETA1):
2385 Improve online-recovery documentation.
2387 2007-10-30 11:35 y-asaba
2389 * configure.in (1.12, V2_0_0_BETA1): Prepare for pgpool-II 2.0
2392 2007-10-30 11:11 y-asaba
2394 * pool_auth.c (1.5): Previous commit did not support V2 protocol.
2396 2007-10-30 10:53 y-asaba
2398 * pool_auth.c (1.4): Send the following error message to frontend
2399 if client auth method is md5 password in replication, master-slave
2402 MD5 authentication is unsupported in replication, master-slave and
2405 2007-10-29 17:12 y-asaba
2407 * Makefile.am (1.14): Merge V1_STABLE branch.
2409 2007-10-29 15:55 y-asaba
2411 * pgpool.spec (1.8, V2_0_0_BETA1): Merge V1_STABLE branch.
2413 2007-10-29 15:28 y-asaba
2415 * redhat/: pgpool.init (1.2), pgpool.sysconfig (1.2, V2_2_4,
2416 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2417 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1) (utags: V2_0_0,
2418 V2_0_0_BETA1, V2_0_1, V2_1_0_BETA1, V2_1_0_BETA2): Merge redhat
2419 scripts from V1_STABLE branch.
2421 2007-10-29 15:09 y-asaba
2423 * doc/pgpool-ja.html (1.22): Fix insert_lock description.
2425 2007-10-29 14:52 y-asaba
2427 * doc/pgpool-ja.html (1.21): Add new directives and update
2428 description of online recovery.
2430 2007-10-29 14:50 y-asaba
2432 * pgpool.conf.sample (1.14), pool.h (1.23), pool_config.l (1.14),
2433 pool_process_query.c (1.67), recovery.c (1.3, V2_0_0,
2434 V2_0_0_BETA1): Add new directives "recovery_1st_stage_command"
2435 and "recovery_2nd_stage_command".
2437 pgpool don't block client connections and data update operations
2438 while executing recovery_1st_stage_command. In
2439 recovery_2nd_stage_command, pgpool block them.
2441 If you recover by PITR, the first stage command get a base backup.
2442 Then you switch XLOG in the second stage command.
2444 2007-10-29 13:37 y-asaba
2446 * sql/pgpool-recovery/: pgpool-recovery.c (1.3),
2447 pgpool-recovery.sql.in (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2448 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2449 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1) (utags: V2_0_0,
2450 V2_0_0_BETA1, V2_0_1): Change pgpool_recovery signature from
2451 pgpol_recovery(text, text) to pgpool_recovery(text, text, text). The
2452 first argument is script name.
2454 * pgpool_recovery arguments:
2456 #2: remote host name
2457 #3: remote database cluster path
2460 command status (= "$?" value)
2462 2007-10-29 13:16 y-mori
2464 * pool_process_query.c (1.66), pool_rewrite_outfuncs.c (1.7),
2465 pool_rewrite_query.h (1.4, V2_0_0_BETA1), parser/outfuncs.c (1.5,
2466 V2_0_1, V2_0_0, V2_0_0_BETA1): add optimization of aggregate
2467 function and group by clause in parallel mode
2469 2007-10-29 10:20 t-ishii
2471 * Makefile.in (1.16), pgpool.conf.sample (1.13), pool.h (1.22),
2472 pool_config.c (1.17), pool_config.l (1.13), pool_process_query.c
2473 (1.65), parser/gram.c (1.7, V2_0_0_BETA1), parser/scan.c (1.7,
2474 V2_0_1, V2_0_0, V2_0_0_BETA1): Change child_idle_limit to
2477 2007-10-26 20:28 y-asaba
2479 * pool_process_query.c (1.64): All signals are blocked while
2480 sending a "COMMIT" command.
2482 2007-10-26 16:41 y-asaba
2484 * pool_process_query.c (1.63): Check return value of pool_flush().
2486 2007-10-23 16:32 y-asaba
2488 * sql/pgpool-recovery/pgpool-recovery.c (1.2): Change error
2491 2007-10-23 13:44 y-asaba
2493 * Makefile.am (1.13), doc/pgpool-ja.html (1.20),
2494 sample/pgpool_recovery_pitr (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2495 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2496 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2497 V2_0_0_BETA1): Add online recovery script using pitr.
2499 2007-10-22 17:59 y-asaba
2501 * test/jdbc/.cvsignore (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2502 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2503 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2504 V2_0_0_BETA1): Add .cvsignore file.
2506 2007-10-22 17:55 y-asaba
2508 * Makefile.am (1.12): Add test/jdbc/* into tar ball.
2510 2007-10-22 17:47 y-asaba
2512 * test/jdbc/: AutoCommitTest.java (1.1, V2_2_4, V2_2_3, V2_2_2,
2513 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2514 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2515 V2_0_1, V2_0_0), BatchTest.java (1.1, V2_2_4, V2_2_3, V2_2_2,
2516 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2517 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2518 V2_0_1, V2_0_0), ColumnTest.java (1.1, V2_2_4, V2_2_3, V2_2_2,
2519 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2520 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2521 V2_0_1, V2_0_0), LockTest.java (1.1, V2_2_4, V2_2_3, V2_2_2,
2522 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2523 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2524 V2_0_1, V2_0_0), PgpoolTest.java (1.1, V2_2_4, V2_2_3, V2_2_2,
2525 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2526 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2527 V2_0_1, V2_0_0), RunTest.java (1.1), SelectTest.java (1.1,
2528 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2529 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2530 V2_1_0_BETA1, V2_0_1, V2_0_0), UpdateTest.java (1.1, V2_2_4,
2531 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2532 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2533 V2_1_0_BETA1, V2_0_1, V2_0_0), pgpool.properties (1.1),
2534 prepare.sql (1.1), run.sh (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2535 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2536 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2537 expected/autocommit (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2538 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2539 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2540 expected/batch (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2541 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2542 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2543 expected/column (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2544 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2545 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2546 expected/lock (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2547 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2548 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2549 expected/select (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2550 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2551 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
2552 expected/update (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2553 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2554 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0) (utags:
2555 V2_0_0_BETA1): Add test program using Java+JDBC driver.
2557 2007-10-22 13:23 y-asaba
2559 * NEWS (1.11), doc/pgpool-ja.html (1.19): Merge from V1_STABLE
2562 2007-10-18 18:55 y-asaba
2564 * pool_query_cache.c (1.8, V2_0_1, V2_0_0, V2_0_0_BETA1): Although
2565 the second argument of PQunescapeBytea() requires size_t which size
2566 is 8 byte in 64bit machine, pgpool passed 4 byte variable. It
2567 caused segfault. So fixed passing size_t variable.
2569 2007-10-18 18:52 y-mori
2571 * test/pdo-test/: collections.inc (1.1), def.inc (1.1), log.txt
2572 (1.1), pdotest.php (1.1), regsql.inc (1.1), SQLlist/test1.sql
2573 (1.1), SQLlist/test2.sql (1.1), mod/database.inc (1.1),
2574 mod/def.inc (1.1), mod/errorhandler.inc (1.1) (utags: V2_0_0,
2575 V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2,
2576 V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1,
2577 V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4): ADD: extend protocol
2580 2007-10-18 17:24 y-asaba
2582 * sample/pgpool_recovery (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2583 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2584 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2585 V2_0_0_BETA1): execute rsync as background jobs.
2587 2007-10-18 13:48 y-asaba
2589 * sample/pgpool_recovery (1.2):
2590 * Add --update option.
2591 * Sync pg_twophase directory.
2593 2007-10-18 11:54 y-asaba
2595 * pool_process_query.c (1.62): Fix compile warning on Solaris.
2597 2007-10-18 10:21 y-asaba
2599 * pool_config.c (1.16), pool_config.l (1.12): Set failback_command
2600 default value to empty string;
2602 2007-10-17 19:23 y-asaba
2604 * main.c (1.19, V2_0_0_BETA1): Fix segfault when failover_command
2607 2007-10-17 15:31 y-mori
2609 * pool_rewrite_outfuncs.c (1.6): FIX: lost alias name of column in
2610 query rewriting when it was used at GRUP BY CLAUSE..etc
2612 2007-10-17 12:00 y-mori
2614 * pool.h (1.21), pool_process_query.c (1.61),
2615 pool_rewrite_outfuncs.c (1.5): Fix: compiler's warning
2617 2007-10-16 12:44 y-asaba
2619 * pool_process_query.c (1.60): Fix hang up in load balancing mode.
2621 2007-10-15 22:56 y-mori
2623 * pool_rewrite_outfuncs.c (1.4): fix Type Casting of Constant value
2626 2007-10-15 21:56 y-mori
2628 * pool_process_query.c (1.59): FIX wrong file descriptor was used
2629 at pool_prallel_exec
2631 2007-10-15 19:38 y-mori
2633 * pool_process_query.c (1.58), pool_rewrite_query.c (1.6, V2_0_1,
2634 V2_0_0, V2_0_0_BETA1): FIX insert rule in parallel mode
2636 2007-10-15 19:20 y-asaba
2638 * test/parser/: expected/create.out (1.2), expected/select.out
2639 (1.2), input/select.sql (1.3) (utags: V2_0_0, V2_0_0_BETA1,
2640 V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0,
2641 V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1,
2642 V2_2_2, V2_2_3, V2_2_4): Add test cases.
2644 2007-10-15 19:18 y-asaba
2646 * parser/outfuncs.c (1.4): Support interval operator.
2648 2007-10-15 18:51 y-asaba
2650 * parser/: gram.y (1.4), scan.l (1.4) (utags: V2_0_0, V2_0_0_BETA1,
2651 V2_0_1): Fix core dump with the following SQL.
2652 SELECT * FROM tbl LIMIT 1,0;
2654 2007-10-15 16:05 y-asaba
2656 * pool_process_query.c (1.57): Fix invalid memory access when
2657 pgpool processed DEALLOCATE statement.
2659 2007-10-15 15:56 y-mori
2661 * pool_config.c (1.15), pool_process_query.c (1.56),
2662 pool_rewrite_outfuncs.c (1.3), pool_rewrite_query.c (1.5),
2663 pool_rewrite_query.h (1.3), pool_system.c (1.4, V2_0_1, V2_0_0,
2664 V2_0_0_BETA1), pool_type.h (1.7, V2_0_1, V2_0_0, V2_0_0_BETA1):
2665 ADD query rewriting to main trunc
2667 2007-10-15 15:11 y-asaba
2669 * parser/pool_memory.c (1.8, V2_0_1, V2_0_0, V2_0_0_BETA1): Fix
2670 core dump with a large SQL.
2672 2007-10-12 21:27 t-ishii
2674 * pgpool.conf.sample (1.12), pool.h (1.20), pool_config.c (1.14),
2675 pool_process_query.c (1.55), parser/scan.c (1.6): Add pool_status
2676 entry for child_idle_limit Fix comments
2678 2007-10-12 18:15 y-asaba
2680 * pgpool.conf.sample (1.11): Add new directive
2681 "authentication_timeout" into pgpool.conf.sample.
2683 2007-10-12 15:56 y-asaba
2685 * doc/pgpool-ja.html (1.18): Add authentication_timeout.
2687 2007-10-12 14:55 y-asaba
2689 * main.c (1.18): Fix compiler warning.
2691 2007-10-12 14:30 y-asaba
2693 * parser/: parser.c (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1),
2694 pool_parser.h (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1), scan.l (1.3):
2695 Fix scanner's error handling. If there was a unterminated
2696 double-quote identifier, scanner entered infinite-loop.
2698 2007-10-12 13:51 y-asaba
2700 * child.c (1.16, V2_0_1, V2_0_0, V2_0_0_BETA1), pool.h (1.19),
2701 pool_config.c (1.13), pool_config.l (1.11), pool_process_query.c
2702 (1.54): Add new directive "authentication_timeout". The directive
2703 means the maximum time in seconds to complete client authentication.
2704 The default value is 60.
2706 2007-10-12 13:50 y-asaba
2708 * TODO (1.9, V2_0_1, V2_0_0, V2_0_0_BETA1): Remove some items.
2710 2007-10-12 13:39 y-asaba
2712 * test/parser/input/select.sql (1.2): Add test cases.
2714 2007-10-12 13:38 y-asaba
2716 * parser/outfuncs.c (1.3): Support for XmlExprt object.
2718 2007-10-12 13:35 y-asaba
2720 * pcp_child.c (1.7, V2_0_1, V2_0_0, V2_0_0_BETA1): recovery request
2721 can be accepted only in replication mode.
2723 2007-10-12 13:34 t-ishii
2725 * Makefile.am (1.11), Makefile.in (1.15), pgpool.conf.sample
2726 (1.10), pool.h (1.18), pool_config.c (1.12), pool_config.l
2727 (1.10), pool_process_query.c (1.53), parser/Makefile.am (1.3,
2728 V2_0_0_BETA1), parser/Makefile.in (1.10), parser/gram.c (1.6),
2729 parser/gram.h (1.6, V2_0_0_BETA1): Add child_idle_limit. # If
2730 child_idle_limit is n (n > 0), the child is forced to be #
2731 disconnected after n seconds idle between transactions. # 0 means
2734 Need to work on show pool_status and docs.
2736 2007-10-11 17:32 y-asaba
2738 * child.c (1.15), pool.h (1.17): Check startup packet length. If
2739 the length is greater than 10,000 byte, pgpool reject the
2742 2007-10-11 10:49 y-asaba
2744 * TODO (1.8): Add graceful {shutodwn, attach, detach} into TODO
2747 * TODO for TODO list translate Japanse into English.
2749 2007-10-04 13:17 y-asaba
2751 * doc/: pgpool-ja.html (1.17), pgpool.css (1.2): Update Japanse
2753 - Add release note for pgpool-II 2.0
2754 - Add failover_command and failback_command description
2756 2007-10-04 12:00 y-asaba
2758 * doc/pgpool-en.html (1.12): Merge V1_STABLE branch.
2760 2007-10-04 11:36 y-asaba
2762 * version.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Change
2763 PGPOOLVERSION to "hikitsuboshi".
2765 2007-10-03 15:19 y-asaba
2767 * TODO (1.7): Remove TODO items.
2769 2007-10-03 14:21 y-asaba
2771 * pool_process_query.c (1.52): Reset a prepared statement list when
2772 DISCARD ALL or DISCARD PLANS statement is completed.
2774 2007-10-03 13:52 y-asaba
2776 * test/parser/: README (1.2), run-test (1.2) (utags: V2_0_0,
2777 V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2,
2778 V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1,
2779 V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4): Translate from
2780 Japanese into English.
2782 2007-10-03 13:47 y-asaba
2784 * Makefile.am (1.10), Makefile.in (1.14), test/parser/.cvsignore
2785 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
2786 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
2787 V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2788 test/parser/Makefile (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2789 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2790 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2791 V2_0_0_BETA1), test/parser/README (1.1), test/parser/main.c (1.1,
2792 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2793 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2794 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2795 test/parser/parse_schedule (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2796 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2797 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2798 V2_0_0_BETA1), test/parser/pool.h (1.1, V2_2_4, V2_2_3, V2_2_2,
2799 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2800 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2801 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/run-test (1.1),
2802 test/parser/expected/copy.out (1.1, V2_2_4, V2_2_3, V2_2_2,
2803 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2804 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2805 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/create.out
2806 (1.1), test/parser/expected/cursor.out (1.1, V2_2_4, V2_2_3,
2807 V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2808 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2809 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/delete.out
2810 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
2811 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
2812 V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2813 test/parser/expected/drop.out (1.1, V2_2_4, V2_2_3, V2_2_2,
2814 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2815 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2816 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/insert.out
2817 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
2818 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
2819 V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2820 test/parser/expected/misc.out (1.1, V2_2_4, V2_2_3, V2_2_2,
2821 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2822 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2823 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/prepare.out
2824 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
2825 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
2826 V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2827 test/parser/expected/privileges.out (1.1, V2_2_4, V2_2_3, V2_2_2,
2828 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2829 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2830 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/select.out
2831 (1.1), test/parser/expected/transaction.out (1.1, V2_2_4, V2_2_3,
2832 V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2833 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2834 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/update.out
2835 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
2836 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
2837 V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2838 test/parser/expected/var.out (1.1, V2_2_4, V2_2_3, V2_2_2,
2839 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2840 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2841 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/alter.sql (1.1,
2842 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2843 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2844 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2845 test/parser/input/copy.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2846 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2847 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2848 V2_0_0_BETA1), test/parser/input/create.sql (1.1, V2_2_4, V2_2_3,
2849 V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2850 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2851 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/cursor.sql (1.1,
2852 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2853 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2854 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2855 test/parser/input/delete.sql (1.1, V2_2_4, V2_2_3, V2_2_2,
2856 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2857 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2858 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/drop.sql (1.1,
2859 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2860 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2861 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2862 test/parser/input/insert.sql (1.1, V2_2_4, V2_2_3, V2_2_2,
2863 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2864 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2865 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/misc.sql (1.1,
2866 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2867 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2868 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2869 test/parser/input/prepare.sql (1.1, V2_2_4, V2_2_3, V2_2_2,
2870 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2871 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2872 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/privileges.sql
2873 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
2874 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
2875 V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2876 test/parser/input/select.sql (1.1),
2877 test/parser/input/transaction.sql (1.1, V2_2_4, V2_2_3, V2_2_2,
2878 V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
2879 V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
2880 V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/update.sql (1.1,
2881 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2882 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2883 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
2884 test/parser/input/var.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
2885 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
2886 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2887 V2_0_0_BETA1): Add SQL parser test.
2889 2007-10-03 13:25 y-asaba
2891 * Makefile.in (1.13), aclocal.m4 (1.10), config.sub (1.2, V2_2_4,
2892 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
2893 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
2894 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), configure (1.14),
2895 ltmain.sh (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2896 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2897 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2898 V2_0_0_BETA1), pool_hba.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
2899 pool_process_query.c (1.51), pool_rewrite_outfuncs.c (1.2),
2900 pool_rewrite_query.c (1.4), parser/Makefile.in (1.9),
2901 parser/copyfuncs.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
2902 parser/gram.c (1.5), parser/gram.h (1.5), parser/gram.y (1.3),
2903 parser/gramparse.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
2904 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
2905 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
2906 V2_0_0_BETA1), parser/keywords.c (1.2, V2_0_1, V2_0_0,
2907 V2_0_0_BETA1), parser/keywords.h (1.2, V2_0_1, V2_0_0,
2908 V2_0_0_BETA1), parser/list.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
2909 parser/makefuncs.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
2910 parser/makefuncs.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
2911 parser/nodes.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
2912 parser/outfuncs.c (1.2), parser/parsenodes.h (1.2, V2_0_1,
2913 V2_0_0, V2_0_0_BETA1), parser/parser.c (1.3), parser/parser.h
2914 (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/pg_list.h (1.2,
2915 V2_0_1, V2_0_0, V2_0_0_BETA1), parser/pool_parser.h (1.3),
2916 parser/primnodes.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
2917 parser/scan.c (1.5), parser/scan.l (1.2), parser/value.c (1.2,
2918 V2_0_1, V2_0_0, V2_0_0_BETA1), parser/value.h (1.2, V2_0_1,
2919 V2_0_0, V2_0_0_BETA1), pcp/Makefile.in (1.9): Import PostgreSQL
2920 8.3 SQL parser. The revision of gram.y is 2.603.
2922 2007-10-03 13:17 y-asaba
2924 * pgpool.conf.sample (1.9), pool_config.c (1.11), pool_config.l
2925 (1.9): The default value of ignore_leading_white_space is true in
2928 2007-09-27 18:38 gleu
2930 * pool_process_query.c (1.50): Typo fix.
2932 2007-09-27 11:48 y-asaba
2934 * TODO (1.6): Remove TODO item.
2936 2007-09-27 11:46 y-asaba
2938 * pool_process_query.c (1.49): Call read_kind_from_backend()
2939 function instead of pool_read_kind() in Execute(), Parse() and
2940 SimpleForwardToFrontend().
2942 2007-09-26 18:09 y-asaba
2944 * pool_process_query.c (1.48): Remove debug message.
2946 2007-09-26 17:56 y-asaba
2948 * pool_process_query.c (1.47): SET, PREPARE and DEALLOCATE
2949 statements are replicated in master/slave mode.
2951 2007-09-26 14:29 y-asaba
2953 * main.c (1.17), pool.h (1.16), pool_process_query.c (1.46),
2954 pool_stream.c (1.5, V2_0_0_BETA1): pgpool-II could not detach
2955 multiple node when message kinds were mismatched.
2958 node-1(master): success
2964 node-2 was only detached.
2966 Now it determine detached nodes by "majority voting rule". And it
2967 can detach them at the same time.
2970 node-1(master): success
2976 node-2 and node-4 are detached because they are minority.
2978 node-1(master): success
2983 The number of the group which gain "success" is same as the number
2984 of the group which gain "fail". In this case, node-2 and node-3 are
2985 detached because these don't belong to the group which master
2988 2007-09-26 12:32 y-asaba
2990 * pool_sema.c (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Fix initializing
2993 2007-09-16 11:08 y-asaba
2995 * pgpool.conf.sample (1.8): Add comments abount failover_command
2996 and failback_command.
2998 2007-09-14 22:36 y-asaba
3000 * main.c (1.16), pgpool.conf.sample (1.7), pool.h (1.15),
3001 pool_config.c (1.10), pool_config.l (1.8), pool_process_query.c
3002 (1.45), parser/gram.c (1.4), parser/gram.h (1.4), parser/gram.y
3003 (1.2), parser/pool_string.c (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1),
3004 parser/pool_string.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Add
3005 "failover_command" and "failback_command" directives. If failover
3006 or failback occur, pgpool execute setting command by system(3).
3007 These directives evaluate special characters with the following
3011 %h: backend's hostname
3012 %p: backend's port number
3013 %D: backend's data directory
3015 example) pgpool.conf: ---
3016 failover_command = 'echo %h %p %D %d > /tmp/failover'
3017 failback_command = 'echo %h %p %D %d > /tmp/failback'
3019 backend_hostname1 = 'localhost'
3020 backend_port1 = 5433
3022 backend_data_directory1 = '/home/postgres/pgdata/data5433' ---
3024 When node 1 is down, pgpool execute the following failover command.
3026 failover localhost 5433 /home/postgres/pgdata/data5433 1
3028 /tmp/failover is created.
3031 failover localhost 5433 /home/postgres/pgdata/data5433 1
3033 2007-09-14 20:11 y-asaba
3035 * child.c (1.14), pool.h (1.14), pool_process_query.c (1.44): Fix
3036 hang up when load balancing node was down.
3038 2007-09-10 22:29 t-ishii
3040 * pool_process_query.c (1.43): Modfify pool_send_error_message() so
3041 that it won't be blocked by sending packet to the closing frontend
3042 connection. Also rename set_non_block() and unset_non_block() to
3043 pool_sen_non_block() and pool_unset_non_block() respectively to make
3044 them public functions.
3046 2007-09-10 22:25 t-ishii
3048 * child.c (1.13), pool.h (1.13): Modfify pool_send_error_message()
3049 so that it won't be blocked by sending packet to the closing
3050 frontend connection. Also rename set_non_block() and
3051 unset_non_block() to pool_sen_non_block() and pool_unset_non_block()
3052 respectively to make them public functions.
3054 2007-09-10 21:47 t-ishii
3056 * child.c (1.12): Fix misspell in a comment
3058 2007-09-07 18:08 y-asaba
3060 * pool_process_query.c (1.42), parser/parser.c (1.2),
3061 parser/pool_memory.c (1.7), parser/pool_memory.h (1.3, V2_0_1,
3062 V2_0_0, V2_0_0_BETA1): Improve performance.
3063 - Reuse parser memory space in free_parser().
3064 - Check node type before comparing with "show pool_status()".
3066 2007-09-06 10:43 y-asaba
3068 * doc/pgpool-en.html (1.11): Fix restricted query section.
3070 2007-08-29 15:49 y-asaba
3072 * pool_query_cache.c (1.7), pcp/pcp.c (1.4, V2_0_1, V2_0_0,
3073 V2_0_0_BETA1), pcp/pcp_stream.c (1.3, V2_0_1, V2_0_0,
3074 V2_0_0_BETA1): Fix compile error on FreeBSD 4.11.
3076 2007-08-29 15:48 y-asaba
3078 * recovery.c (1.2): Fix compile error.
3080 2007-08-29 15:01 y-asaba
3082 * pool_process_query.c (1.41): Read response messages in Parse()
3083 until receiving ParseComplete or ErrorResponse message.
3085 2007-08-28 19:07 y-asaba
3087 * pool_process_query.c (1.40): Add checking deadlock error message
3090 2007-08-28 11:28 y-asaba
3092 * pool_process_query.c (1.39):
3093 * Fix handling Parse message. Parse message including
3094 INSERT/UPDATE/DELETE query acquires RowExclusiveLock. However pgpool
3095 did not wait a response from each node. It was possible to occur
3098 * Fix memory leak in reset_prepared_list()
3100 2007-08-17 10:50 t-ishii
3102 * TODO (1.5), doc/pgpool-ja.html (1.16): Enhance documentation.
3104 2007-08-13 11:23 y-asaba
3106 * pgpool.conf.sample (1.6), pool.h (1.12), pool_config.l (1.7),
3107 pool_process_query.c (1.38): Add new parameter named
3108 "replicate_select". Default value is 'false'.
3110 If it is true, pgpool replicates SELECT queries when load balancing
3111 is disabled. This is a old specification which was V1.0.
3113 If it is false, pgpool only sends them to the master node. This is a
3114 current specification.
3116 2007-08-06 10:42 y-asaba
3118 * pool_process_query.c (1.37): Fix memory leak.
3120 2007-08-01 13:27 y-asaba
3122 * child.c (1.11): Remove compiler warning.
3124 2007-07-27 10:19 y-asaba
3126 * doc/pgpool-ja.html (1.15): Merge from V1_STABLE branch
3128 2007-07-26 19:15 y-asaba
3130 * child.c (1.10), pool.h (1.11), pool_connection_pool.c (1.9,
3131 V2_0_1, V2_0_0, V2_0_0_BETA1): SIGALRM handler didn't safe.
3132 Because it called non-reentrant functions. We only set a flag in
3133 SIGALRM handler. Then we close expired connections in safe places.
3135 2007-07-26 14:15 y-asaba
3137 * pool_connection_pool.c (1.8): Fix memory leak when connection
3140 2007-07-26 11:28 t-ishii
3142 * aclocal.m4 (1.9), configure (1.13), pool_config.c (1.9): Run
3145 2007-07-26 11:21 y-asaba
3147 * pool_config.l (1.6): Fix using uninitialized value.
3149 2007-07-25 21:31 y-asaba
3151 * pool_process_query.c (1.36): Fix hang up and SEGV if Parse
3152 message contains a warning statement.
3155 WARNING: nonstandard use of \' in a string literal
3157 If pgpool receives a warning message that is NoticeMessage('N')
3158 under the extended query protocol, it reads a next message.
3160 2007-07-24 18:02 y-asaba
3162 * pool.h (1.10), pool_process_query.c (1.35): Detect deadlock in
3163 do_command(). When insert_lock was true, kind mismatch error
3166 2007-07-23 14:32 y-asaba
3168 * pool_process_query.c (1.34): Fixed that
3169 start_internal_transaction() was only called under replication mode
3172 2007-07-23 14:24 y-asaba
3174 * main.c (1.15): Remove debug code.
3176 2007-07-23 13:37 y-asaba
3178 * child.c (1.9), main.c (1.14), pool.h (1.9), pool_config.c (1.8),
3179 pool_config.l (1.5), pool_process_query.c (1.33), pool_type.h
3180 (1.6): Add reloading config files. pgpool can reload pgpool.conf,
3181 pool_hba.conf and distributed rules from system DB. If reload, you
3182 type the following command.
3186 Or you send SIGHUP signal to the pgpool parent process.
3188 2007-07-17 15:04 y-asaba
3190 * pool_process_query.c (1.32): Fix hang up when backend node did
3191 fast or immediate shutdown.
3193 If shutdown occured, postgres send an error which error code is
3194 "57P01" and error message is "terminating connection due to
3195 administrator command".
3197 However, another nodes did not send any messages. pgpool waited for
3198 a message from them. when the error is sended, pgpool reads the
3199 message and degenerate.
3201 2007-07-17 11:33 y-asaba
3203 * pool_process_query.c (1.31, ROOT_OF_V2_0_PARALLEL_UNSTABLE):
3204 Rearrange detect_deadlock_error().
3206 2007-07-10 18:56 y-asaba
3208 * main.c (1.13, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h (1.8,
3209 ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_process_query.c (1.30),
3210 pool_stream.c (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE):
3211 * Change type of InRecovery variable to sig_atomic_t*
3213 * Fixed kind mismatch error when deadlock error occured. The
3214 problem is the following senario.
3218 A: LOCK TABLE t1 IN SHARE ROW EXCLUSIVE MODE;
3219 B: LOCK TABLE t2 IN SHARE ROW EXCLUSIVE MODE;
3220 A: LOCK TABLE t2 IN SHARE ROW EXCLUSIVE MODE;
3221 B: LOCK TABLE t1 IN SHARE ROW EXCLUSIVE MODE;
3223 Transaction "A" aborts on master node, but it completes on another
3224 nodes. It causes wrong failover.
3226 So pgpool checks deadlock error(code == '40P01') and sends error
3227 query to another nodes.
3229 2007-07-09 14:18 y-asaba
3231 * main.c (1.12): Add comments.
3233 2007-07-09 13:23 y-asaba
3235 * main.c (1.11): Fix race condition between flag checking and
3238 Normally, this case solve to call pselect(2). But Linux's pselect(2)
3239 is emulated by select(2) and sigprocmask(2). It contains this race.
3240 So pgpool archieves using the self-pipe trick.
3242 See 'man pselect' if you want to get more information.
3244 2007-07-09 10:29 y-asaba
3246 * config.guess (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
3247 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
3248 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
3249 V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), config.h.in (1.4,
3250 V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
3251 configure (1.12, ROOT_OF_V2_0_PARALLEL_UNSTABLE), configure.in
3252 (1.11, ROOT_OF_V2_0_PARALLEL_UNSTABLE), ltmain.sh (1.2,
3253 ROOT_OF_V2_0_PARALLEL_UNSTABLE), aclocal.m4 (1.8,
3254 ROOT_OF_V2_0_PARALLEL_UNSTABLE), child.c (1.8,
3255 ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp_child.c (1.6,
3256 ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_connection_pool.c (1.7,
3257 ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_process_query.c (1.29),
3258 pool_query_cache.c (1.6, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
3259 pool_stream.c (1.3): configure checks that OS has sys/select.h.
3260 If it exists, include it.
3262 2007-07-06 17:32 y-asaba
3264 * child.c (1.7), pool_process_query.c (1.28), pool_type.h (1.5,
3265 ROOT_OF_V2_0_PARALLEL_UNSTABLE): Load balancing node was chosen
3266 before sending "SELECT" statement. But this way had the following
3270 Did not find any relation with OID XXX
3272 pgpool chooses it after receiving AuthenticationOK('R') message. So
3273 pgpool load balance to the same node inside a same session.
3275 2007-07-05 18:12 y-asaba
3277 * main.c (1.10): Improve signal handling.
3279 We fixed signal handling at revision 1.6. That fix was to set a flag
3280 in signal handler, then pgpool checked flags in safe points. However
3281 It has a race condition in the following case.
3283 CHECK_REQUEST; <-- check flags
3284 <signal handler> <-- set flags
3285 pause(); <-- wait for signals
3287 So, we modified to deliver signals in safe places which are in
3288 pause() and sleep().
3290 2007-07-05 11:14 y-asaba
3292 * pool_process_query.c (1.27):
3293 * Remove debug code.
3294 * Refactor ReadyForQuery() and do_command().
3296 2007-07-04 17:18 y-asaba
3298 * pool_process_query.c (1.26): In replication mode, pgpool checks
3299 the numbers of insert/update/delete tuples in CommandComplete
3300 message. If these numbers are not same, a transaction is aborted by
3301 pgpool. It is for data consistency.
3303 TODO: This behavior will be able to switch by pgpool.conf.
3305 2007-07-03 18:23 y-asaba
3307 * TODO (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Rearrange TODO list.
3309 2007-06-29 23:15 y-asaba
3311 * main.c (1.9): Fix race condition between unsetting SIGCHLD flag
3312 and unblocking SIGCHLD signal.
3314 2007-06-28 21:35 y-asaba
3316 * main.c (1.8): Fix SIGUSR2 handling. The signal handler only set
3317 flag. Then, pgpool call SIGUSR2 handler in CHECK_REQUEST macro.
3319 2007-06-27 18:29 y-asaba
3321 * ChangeLog (1.18, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h (1.7),
3322 pool_process_query.c (1.25): Fix hang up when a SELECT query has
3323 error inside transaction block. It occurs only in simple query
3326 2007-06-27 18:04 y-asaba
3328 * sample/pgpool_remote_start (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
3329 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
3330 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
3331 V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Fix checking the
3332 number of arguments.
3334 2007-06-26 10:35 y-asaba
3336 * pcp_child.c (1.5): Remove unused variable.
3338 2007-06-22 19:10 t-ishii
3340 * Makefile.in (1.12, ROOT_OF_V2_0_PARALLEL_UNSTABLE), aclocal.m4
3341 (1.7), configure (1.11), parser/Makefile.in (1.8,
3342 ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/scan.c (1.4,
3343 ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/Makefile.in (1.8,
3344 ROOT_OF_V2_0_PARALLEL_UNSTABLE): run autoconf and flex
3346 2007-06-22 18:50 y-asaba
3348 * Makefile.am (1.9, ROOT_OF_V2_0_PARALLEL_UNSTABLE), Makefile.in
3349 (1.11), aclocal.m4 (1.6), child.c (1.6), configure (1.10),
3350 configure.in (1.10), main.c (1.7), pcp_child.c (1.4),
3351 pgpool.conf.sample (1.5, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h
3352 (1.6), pool_config.c (1.7, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
3353 pool_config.l (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
3354 pool_process_query.c (1.24), pool_type.h (1.4), recovery.c (1.1,
3355 ROOT_OF_V2_0_PARALLEL_UNSTABLE), doc/pgpool-ja.html (1.14,
3356 ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/Makefile.in (1.7),
3357 pcp/Makefile.am (1.2, V2_0_0_BETA1,
3358 ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/Makefile.in (1.7), pcp/pcp.c
3359 (1.3, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/pcp.h (1.2, V2_0_1,
3360 V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
3361 pcp/pcp_recovery_node.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1,
3362 ROOT_OF_V2_0_PARALLEL_UNSTABLE), sample/pgpool_recovery (1.1,
3363 ROOT_OF_V2_0_PARALLEL_UNSTABLE), sample/pgpool_remote_start
3364 (1.1), sql/pgpool-recovery/Makefile (1.1, V2_2_2, V2_2_1, V2_2_0,
3365 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
3366 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
3367 V2_0_0_BETA1), sql/pgpool-recovery/pgpool-recovery.c (1.1),
3368 sql/pgpool-recovery/pgpool-recovery.sql.in (1.1): Add new
3369 features in pgpool-II 2.0.
3370 * support online-recovery in replication mode.
3371 - based on physical data copy
3373 * improve replication mode.
3374 - employ "primary copy method" to enhance the performance
3375 - more stable replication
3377 2007-06-21 10:17 y-asaba
3379 * ChangeLog (1.17): update ChangeLog.
3381 2007-06-20 18:09 y-asaba
3383 * main.c (1.6): Fix SIGCHLD and SIGUSR1 signal handling. Signal
3384 handlers set flags only, then a parent process checks flags in
3387 2007-06-20 17:14 t-ishii
3389 * pool_config.c (1.6), parser/gram.c (1.3, V1_3, V1_2_1, V1_2,
3390 ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/gram.h (1.3, V1_3,
3391 V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/scan.c
3392 (1.3, V1_2_1, V1_2): run flex
3394 2007-06-18 11:40 y-asaba
3396 * pool_process_query.c (1.23): Fix memory leak in
3397 NotificationResponse().
3399 2007-06-18 11:37 y-asaba
3401 * ChangeLog (1.16): update ChangeLog.
3403 2007-06-18 11:34 y-asaba
3405 * pool_process_query.c (1.22):
3406 * Fix compile warning.
3407 * Fix memory leak in CursorResponse().
3409 2007-06-18 10:33 t-ishii
3411 * Makefile.in (1.10, V1_2_1, V1_2): run autoconf
3413 2007-06-15 22:35 devrim
3415 * pgpool.spec (1.7, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Update spec
3418 2007-06-15 12:21 y-asaba
3420 * NEWS (1.10, ROOT_OF_V2_0_PARALLEL_UNSTABLE), doc/pgpool-ja.html
3421 (1.13) (utags: V1_1_1): Update release note.
3423 2007-06-15 11:57 t-ishii
3425 * configure (1.9, V1_1_1): Run autoconf.
3427 2007-06-15 11:55 t-ishii
3429 * doc/pgpool-ja.html (1.12): Fix typo.
3431 2007-06-14 16:44 y-asaba
3433 * ChangeLog (1.15, V1_1_1): Prepare for 1.1.1
3435 2007-06-12 10:49 y-asaba
3437 * NEWS (1.9): Prepare for 1.1.1
3439 2007-06-11 15:37 y-asaba
3441 * configure.in (1.9, V1_1_1), doc/pgpool-ja.html (1.11): Prepare
3444 2007-06-11 12:06 y-asaba
3446 * ChangeLog (1.14): Update ChangeLog.
3448 2007-06-11 12:01 y-asaba
3450 * pool_process_query.c (1.21, V1_1_1): Fix kind mismatch error when
3451 load_balance_mode is true.
3453 2007-06-07 11:38 y-asaba
3455 * pool_process_query.c (1.20): Fix handling nullmap (V2 only).
3457 2007-06-06 17:32 yamaguti
3459 * doc/: pgpool-en.html (1.10, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
3460 V1_1_1), pgpool-ja.html (1.10): added an explanation about
3461 command line option "-a" for HBA file.
3463 2007-06-02 09:54 y-asaba
3465 * pool_process_query.c (1.19): Fix typo EmptyQueryResponse message.
3466 pgpool hung up in EXECUTE command. (Patch contributed by Kenichi
3469 2007-05-29 10:58 y-asaba
3471 * pool_process_query.c (1.18): Fix handling protocol version 2.
3473 2007-05-28 18:13 y-asaba
3475 * pool_process_query.c (1.17): Fix handling protocol version 2.
3477 2007-05-25 12:02 y-asaba
3479 * Makefile.am (1.8, V1_2_1, V1_2), Makefile.in (1.9) (utags: V1_1,
3482 2007-05-25 11:45 y-asaba
3484 * ChangeLog (1.13, V1_1): Prepare for 1.1
3486 2007-05-25 11:37 y-asaba
3488 * doc/: pgpool-en.html (1.9), pgpool-ja.html (1.9) (utags: V1_1):
3489 Add handling "SELECT nextval".
3491 2007-05-25 11:30 y-asaba
3493 * doc/pgpool-ja.html (1.8): Add Japanese release note for 1.1
3495 2007-05-24 23:27 t-ishii
3497 * Makefile.in (1.8), aclocal.m4 (1.5, V1_3, V1_2_1, V1_2, V1_1_1,
3498 V1_1), configure (1.8, V1_1), parser/Makefile.in (1.6, V1_3,
3499 V1_2_1, V1_2, V1_1_1, V1_1), pcp/Makefile.in (1.6, V1_3, V1_2_1,
3500 V1_2, V1_1_1, V1_1): Resync files generated by configure.in
3502 2007-05-24 23:25 t-ishii
3504 * TODO (1.3, V1_3, V1_2_1, V1_2, V1_1_1, V1_1): update
3507 2007-05-24 15:42 y-asaba
3509 * NEWS (1.8, V1_1): update NEWS
3511 2007-05-24 15:38 y-asaba
3513 * parser/pool_memory.c (1.6, V1_3, V1_2_1, V1_2,
3514 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1), ChangeLog (1.12):
3515 Fix core dump in pool_memory_realloc().
3517 2007-05-23 11:01 yamaguti
3519 * ChangeLog (1.11), NEWS (1.7):
3521 fixed pgpool.pam so it is installed under $PREFIX/share/pgpool-II/
3523 2007-05-23 10:59 yamaguti
3525 * ac_func_accept_argtypes.m4 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
3526 V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
3527 V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
3528 V2_0_0_BETA1), pool_hba.c (1.1), pool_hba.conf.sample (1.1,
3529 V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
3530 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
3531 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_ip.c (1.1,
3532 V2_0_1, V2_0_0, V2_0_0_BETA1), pool_ip.h (1.1, V2_0_1, V2_0_0,
3533 V2_0_0_BETA1), pool_path.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1),
3534 pool_path.h (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), ps_status.c
3535 (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), strlcpy.c (1.1, V2_0_1,
3536 V2_0_0, V2_0_0_BETA1) (utags: ROOT_OF_V2_0_PARALLEL_UNSTABLE,
3537 V1_1, V1_1_1, V1_2, V1_2_1, V1_3):
3539 new files for HBA, ps display, log_hostname & log_connections
3541 2007-05-22 15:28 y-asaba
3543 * pool_process_query.c (1.16, V1_1): Add checking a message length
3544 is valid. (Reported by Fujii Masao)
3546 2007-05-21 14:49 y-asaba
3548 * NEWS (1.6), configure.in (1.8, V1_1), version.h (1.2,
3549 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): Prepare for 1.1
3551 2007-05-21 11:16 yamaguti
3553 * Makefile.am (1.7), Makefile.in (1.7): pgpool.pam and
3554 system_db.sql is now installed under share/pgpool-II/
3556 2007-05-17 15:46 yamaguti
3558 * ChangeLog (1.10), Makefile.am (1.6), Makefile.in (1.6),
3559 aclocal.m4 (1.4), child.c (1.5, V1_1_1, V1_1), config.h.in (1.3,
3560 V1_1_1, V1_1), configure (1.7), configure.in (1.7), main.c (1.5,
3561 V1_1_1, V1_1), pcp_child.c (1.3, V1_3, V1_2_1, V1_2, V1_1_1,
3562 V1_1), pgpool.conf.sample (1.4, V1_1_1, V1_1), pool.h (1.5,
3563 V1_1_1, V1_1), pool_config.c (1.5, V1_1_1, V1_1), pool_config.l
3564 (1.3, V1_1_1, V1_1), pool_process_query.c (1.15),
3565 pool_query_cache.c (1.5, V1_2, V1_1_1, V1_1), pool_type.h (1.3,
3566 V1_1_1, V1_1), doc/pgpool-en.html (1.8), doc/pgpool-ja.html
3567 (1.7), parser/Makefile.in (1.5), parser/gram.c (1.2, V1_1_1,
3568 V1_1), parser/gram.h (1.2, V1_1_1, V1_1), parser/pool_parser.h
3569 (1.2, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1,
3570 V1_1), pcp/Makefile.in (1.5), sample/pgpool.pam (1.1, V2_2_4,
3571 V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
3572 V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
3573 V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
3574 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1):
3575 * Support HBA authentication.
3576 * Support log_connections
3577 * Support log_hostname
3578 * Support "ps" status display
3579 * Fixed compiler warning in pool_query_cache.c
3580 * sample/pgpool.pam: PAM service configuration file. It will be
3581 installed to "$PREFIX/share/"
3582 * doc/pgpool-ja.html: Added pool_hba description.
3583 * doc/pgpool-en.html: Added pool_hba description.
3586 2007-04-26 14:26 y-asaba
3588 * ChangeLog (1.9), pool_connection_pool.c (1.6, V1_1_1, V1_1):
3589 Retry connect() when it is interrupted by signal.
3591 2007-04-20 16:18 y-asaba
3593 * ChangeLog (1.8): Add entry.
3595 2007-04-20 15:41 y-asaba
3597 * pool_process_query.c (1.14): Enhance that the query that begins
3598 with "SELECT nextval()" or "SELECT setval()" are always replicated
3599 under replication mode.
3601 Then, SELECT statements are only executed by MASTER node if
3602 load_balance_mode is false. If need to replicate select statement,
3603 add a comment in the begining of the query.
3606 SELECT foo() -> /*REPLICATION*/ SELECT foo()
3608 2007-04-15 20:26 t-ishii
3610 * pool_process_query.c (1.13): Fix read_kind_from_backend(). It
3611 calls notice_backend_error() with fixed db node number 1. Make it
3612 the db node which returns different packet kind from master.
3614 2007-04-12 17:30 devrim
3616 * pool_process_query.c (1.12): Patch to surpress compiler warnings,
3619 2007-03-01 13:06 y-asaba
3621 * ChangeLog (1.7), pool_process_query.c (1.11): Support load
3622 balancing with extended protocol. (Parallel query isn't supported
3623 extended protocol yet.)
3625 2007-03-01 12:03 y-asaba
3627 * ChangeLog (1.6), parser/Makefile.am (1.2, V1_3, V1_2_1, V1_2,
3628 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1), parser/copyfuncs.c
3629 (1.1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1,
3630 V1_1): Porting deep copy functions for tree nodes from
3633 2007-02-28 20:04 y-asaba
3635 * ChangeLog (1.5): Add ChangeLog entry.
3637 2007-02-28 19:44 y-asaba
3639 * Makefile.am (1.5): Fix link error on Solaris. Solaris's ld does
3640 not have --rpath option. So it uses libtool's -rpath option instead
3643 2007-02-21 04:38 devrim
3645 * pgpool.spec (1.6, V1_1_1, V1_1): Fixes from Jarod Wilson
3646 <jwilson@redhat.com>
3647 - Create proper devel package, drop -libs package
3649 - Don't install libtool archive and static lib
3650 - Clean up %%configure line
3651 - Use proper %%_smp_mflags
3652 - Install config files properly, without .sample on the end
3653 - Preserve timestamps on header files
3655 2007-02-20 18:20 devrim
3657 * pgpool.spec (1.5):
3659 - Fix various build problems and prepared for Fedora Submission
3662 ----------------------------------------------------------------------
3664 2007-02-20 15:02 devrim
3666 * pgpool.conf.sample (1.3): Update header so that we can see that
3667 it is pgpool-II conf file (I was confused after removing pgpool and
3668 installing pgpool-II :) )
3670 2007-02-16 22:56 t-ishii
3672 * Makefile.in (1.5), configure (1.6), parser/Makefile.in (1.4),
3673 pcp/Makefile.in (1.4): automake & autoconf
3675 2007-02-16 20:31 y-asaba
3677 * ChangeLog (1.4), Makefile.am (1.4), configure.in (1.6),
3678 pool_connection_pool.c (1.5), pool_query_cache.c (1.4), pcp/pcp.c
3679 (1.2, V1_2, V1_1_1, V1_1), pcp/pcp_stream.c (1.2, V1_2,
3680 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): Fixed compile
3681 error on MacOS X. MacOS's ld does not have rpath option. So add
3682 --disable-rpath option to configure for MacOS X.
3684 2007-02-13 12:44 y-asaba
3686 * ChangeLog (1.3, V1_0_2):
3687 * Add entries using cvs2cl.
3689 2007-02-12 16:23 y-asaba
3691 * doc/pgpool-ja.html (1.6, V1_0_2): Add release note.
3693 2007-02-12 15:51 y-asaba
3695 * doc/pgpool-ja.html (1.5): Add Japanese release note into
3698 2007-02-12 11:32 y-asaba
3700 * child.c (1.4), pool.h (1.4), pool_connection_pool.c (1.4) (utags:
3701 V1_0_2): pgpool *only* checks backend connection when connection
3704 2007-02-09 12:54 y-asaba
3706 * NEWS (1.5, V1_0_2): fix indent.
3708 2007-02-09 12:50 y-asaba
3710 * NEWS (1.4): Remove '\000'.
3712 2007-02-08 22:08 t-ishii
3714 * doc/pgpool-en.html (1.7, V1_0_2): prepare for 1.0.2
3716 2007-02-08 21:52 t-ishii
3718 * NEWS (1.3), config.h.in (1.2, V1_0_2), configure (1.5, V1_0_2):
3721 2007-02-08 17:56 y-asaba
3723 * doc/pgpool-ja.html (1.4): Add new loadbalancing rule in
3724 replication mode section.
3726 2007-02-08 17:34 y-asaba
3728 * pool_query_cache.c (1.3), configure.in (1.5), pool_system.c (1.3,
3729 V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1)
3730 (utags: V1_0_2): Fixed configure error if libpq version is 7.4.x.
3731 7.4 does not have PQprepare(). So when version is 7.4, pgpool uses
3732 PREPARE statement instead of PQprepare().
3734 2007-02-08 00:44 y-asaba
3736 * configure.in (1.4): Prepare for 1.0.2
3738 2007-02-07 19:08 t-ishii
3740 * Makefile.in (1.4, V1_0_2), aclocal.m4 (1.3, V1_0_2), configure
3741 (1.4), configure.in (1.3), pool_config.c (1.4, V1_0_2),
3742 parser/Makefile.in (1.3, V1_0_2), pcp/Makefile.in (1.3, V1_0_2):
3743 update configure.in to use pg_config. Patch made by Yoshiyuki
3746 2007-02-06 11:46 y-asaba
3748 * pool_connection_pool.c (1.3): Add checking socket state when
3749 connection pool is reused. If socket is closed, pgpool try to
3750 create new connection pool.
3752 2007-01-30 11:25 y-asaba
3754 * pool_process_query.c (1.10, V1_0_2): Disable to load balance in
3755 the following cases.
3758 - /* xxx */ SELECT ... (This is pgpool-I spec.)
3760 2007-01-13 23:56 yamaguti
3762 * pool_signal.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1,
3763 V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2):
3765 fixed #ifndef ~ #define macro for that it could have been included
3768 2007-01-10 04:02 y-asaba
3770 * pool_process_query.c (1.9): Fix auto-deallocation. If a client
3771 used PDO interface, pgpool didn't clean prepared statement.
3773 2007-01-05 02:27 devrim
3775 * COPYING (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
3776 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), child.c
3777 (1.3), main.c (1.4, V1_0_2), pcp_child.c (1.2, V1_0_2),
3778 pgpool.8.in (1.2, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
3779 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool.h
3780 (1.3), pool_auth.c (1.3, V1_3, V1_2_1, V1_2,
3781 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
3782 pool_config.c (1.3), pool_config.l (1.2, V1_0_2),
3783 pool_connection_pool.c (1.2), pool_error.c (1.2, V2_0_1, V2_0_0,
3784 V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
3785 V1_1_1, V1_1, V1_0_2), pool_ipc.h (1.2, V2_0_1, V2_0_0,
3786 V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
3787 V1_1_1, V1_1, V1_0_2), pool_params.c (1.2, V2_0_1, V2_0_0,
3788 V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
3789 V1_1_1, V1_1, V1_0_2), pool_process_query.c (1.8),
3790 pool_query_cache.c (1.2), pool_rewrite_query.c (1.3, V1_3,
3791 V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1,
3792 V1_0_2), pool_rewrite_query.h (1.2, V1_3, V1_2_1, V1_2,
3793 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
3794 pool_sema.c (1.2, V1_3, V1_2_1, V1_2,
3795 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
3796 pool_shmem.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1,
3797 V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
3798 pool_signal.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1,
3799 V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
3800 pool_signal.h (1.2), pool_stream.c (1.2, V1_1_1, V1_1, V1_0_2),
3801 pool_system.c (1.2), pool_type.h (1.2, V1_0_2),
3802 parser/pool_memory.c (1.5, V1_0_2), parser/pool_memory.h (1.2,
3803 V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1,
3804 V1_0_2), parser/pool_string.c (1.2, V1_3, V1_2_1, V1_2,
3805 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
3806 parser/pool_string.h (1.2, V1_3, V1_2_1, V1_2,
3807 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2): Copyright
3810 2006-12-25 19:14 y-asaba
3812 * Makefile.am (1.3, V1_0_2), Makefile.in (1.3): Fix libpq link
3813 error (Reported by ISHIDA Akio).
3815 2006-12-04 14:49 t-ishii
3817 * pool_process_query.c (1.7): Fix bug with replication mode. With
3818 UPDATE/DELETE, the number of affcted rows should not be sum of each
3821 2006-12-02 22:41 t-ishii
3823 * pool_process_query.c (1.6): Add backend status info to show
3826 2006-12-02 22:40 t-ishii
3828 * main.c (1.3): enhance logging to make it clear what kind of
3829 failover/failback event ocuured.
3831 2006-12-02 22:38 t-ishii
3833 * TODO (1.2, V1_0_2): update TODO document to reflect current
3836 2006-11-30 07:33 devrim
3838 * child.c (1.2), pool_auth.c (1.2): Fix small typos in messages
3840 2006-11-30 06:54 devrim
3842 * pgpool.conf.sample (1.2, V1_0_2): Fix small typos in config file
3844 2006-11-15 18:30 y-asaba
3846 * pool_process_query.c (1.5): Fix an extended query protocol
3849 2006-11-13 14:02 y-asaba
3851 * parser/pool_memory.c (1.4): Fix SIGSEGV under parallel mode.
3853 2006-11-10 12:48 y-asaba
3855 * parser/pool_memory.c (1.3):
3856 * Add NULL checking in pool_memory_free().
3858 * Fix SIGSEGV in pool_memory_alloc() if allocate size is 8192 byte.
3861 pool_memory = pool_memory_create();
3862 x = pool_memory_alloc(pool_memory, 8192);
3864 2006-11-04 16:38 y-asaba
3866 * parser/pool_memory.c (1.2): Fixed a inifinite loop in
3869 2006-10-04 14:57 y-asaba
3871 * pool_rewrite_query.c (1.2): Fix rewriting a query which refers
3872 pg_catalog. Patch contributed by Yoshiharu Mori.
3874 2006-10-04 04:31 devrim
3876 * pgpool.spec (1.4, V1_0_2):
3877 - Added -libs and -devel RPM
3878 - Fix .so link problem
3879 - Cosmetic changes to spec file
3881 2006-10-04 04:29 devrim
3883 * pgpool.spec (1.3): [no log message]
3885 2006-09-27 14:45 devrim
3887 * pgpool.spec (1.2):
3888 * Thu Sep 27 2006 - Devrim GUNDUZ <devrim@commandprompt.com> 1.0.1-3
3889 - Fix spec, per Yoshiyuki Asaba
3891 * Thu Sep 26 2006 - Devrim GUNDUZ <devrim@commandprompt.com> 1.0.1-2
3892 - Fixed rpmlint errors
3893 - Fixed download url
3894 - Added ldconfig for .so files
3896 ** Thu Sep 21 2006 - David Fetter <david@fetter.org> 1.0.1-1
3897 - Initial build pgpool-II 1.0.1 for PgPool Global Development Group
3899 2006-09-27 11:14 y-asaba
3901 * pool_process_query.c (1.4): Fix load balancing algorithm. Patch
3902 contributed by Jeff Davis.
3904 See the following URL for more details.
3906 http://pgfoundry.org/pipermail/pgpool-hackers/2006-September/000034.html
3908 2006-09-25 12:03 y-asaba
3910 * doc/: pgpool-en.html (1.6), pgpool-ja.html (1.3): Add pam
3911 authentication in supported authentication protocol list. Reported
3914 2006-09-22 15:04 t-ishii
3916 * Makefile.am (1.2), Makefile.in (1.2), aclocal.m4 (1.2), configure
3917 (1.3), pool_config.c (1.2), parser/Makefile.in (1.2),
3918 parser/scan.c (1.2, V1_1_1, V1_1, V1_0_2), pcp/Makefile.in (1.2)
3919 (utags: V1_0_1): Update Makefile.am to reflect the fact that some
3920 doc names have been changed.
3922 2006-09-22 14:39 t-ishii
3924 * ChangeLog (1.2, V1_0_1), NEWS (1.2, V1_0_1), configure (1.2),
3925 configure.in (1.2, V1_0_1): Version 1.0.1
3927 2006-09-15 15:06 y-asaba
3929 * doc/pgpool-ja.html (1.2, V1_0_1): A restriction of extended
3930 protocol is *only* in parallel mode. Fixed the description.
3932 2006-09-14 11:04 t-ishii
3934 * pool.h (1.2, V1_0_1): Fix NUM_BACKENDS macro when operated in
3935 MASTER_SLAVE mode. See following message for more details.
3937 Subject: [Pgpool-general] pgpool-II master/slave mode, BackendError
3938 From: Jeff Davis <pgpool@j-davis.com> To:
3939 pgpool-general@pgfoundry.org Date: Tue, 12 Sep 2006 16:48:49 -0700
3941 2006-09-14 11:00 t-ishii
3943 * pool_process_query.c (1.3, V1_0_1): Fix debug message in
3944 simpleQuery() so that it correctly prints query string when operated
3945 in MASTER_SLAVE mode.
3947 2006-09-14 10:56 t-ishii
3949 * main.c (1.2, V1_0_1): enhance health check error messages
3951 2006-09-13 19:21 y-asaba
3953 * pool_process_query.c (1.2): Fix kind mismatch error in COPY FROM
3956 2006-09-11 23:50 y-asaba
3958 * doc/pgpool-en.html (1.5, V1_0_1): Remove multibyte character.
3960 2006-09-11 15:47 y-asaba
3962 * doc/tutorial-ja.html (1.1, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
3963 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1):
3964 Rename `tutorial.html' to `tutorial-ja.html'.
3966 2006-09-11 15:42 y-asaba
3968 * README.euc_jp (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
3969 V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
3970 V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
3971 V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
3972 V1_1_1, V1_1, V1_0_2, V1_0_1), doc/pgpool-ja.html (1.1):
3973 * Rename `doc/pgpool.html' to `doc/pgpool-ja.html'.
3975 * Merge Devrim's patch.
3977 2006-09-11 15:32 y-asaba
3979 * doc/pgpool-en.html (1.4): Remove Japanese comment.
3981 2006-09-11 15:13 y-asaba
3983 * doc/tutorial-en.html (1.2, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
3984 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1):
3985 Remove Japanese characters.
3987 2006-09-11 14:53 y-asaba
3989 * README (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
3990 V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
3991 V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3,
3992 V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1,
3993 V1_0_2, V1_0_1): Update README.
3995 2006-09-08 21:01 devrim
3997 * doc/pgpool-en.html (1.3): Far better look for HTML page, suitable
3998 for web and local browsing.
4000 2006-09-08 20:09 devrim
4002 * doc/pgpool-en.html (1.2): comment last modified line for a better
4005 2006-09-08 20:05 devrim
4007 * doc/pgpool.css (1.1, V1_3, V1_2_1, V1_2,
4008 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1):
4009 Add pgpool.css for readme files. This is the same stylesheet that we
4012 2006-09-08 19:16 devrim
4014 * doc/: pgpool-en.html (1.1), tutorial-en.html (1.1):
4016 Renamed files so that some browsers won't complain.
4018 2006-09-08 12:35 t-ishii
4020 * README (1.1), configure.in (1.1), Makefile.am (1.1), aclocal.m4
4021 (1.1), Makefile.in (1.1), config.h.in (1.1), configure (1.1),
4022 COPYING (1.1), ChangeLog (1.1), NEWS (1.1), TODO (1.1),
4023 config.guess (1.1), config.sub (1.1), ltmain.sh (1.1), pg_md5.c
4024 (1.1), pool_config.c (1.1), README.euc_jp (1.1), main.c (1.1),
4025 pgpool.conf.sample (1.1), pgpool.spec (1.1), pool.h (1.1),
4026 pool_type.h (1.1), version.h (1.1), child.c (1.1), pool_auth.c
4027 (1.1), pool_config.l (1.1), pool_error.c (1.1),
4028 pool_connection_pool.c (1.1), pool_params.c (1.1),
4029 pool_process_query.c (1.1), pool_signal.c (1.1), pool_signal.h
4030 (1.1), pool_stream.c (1.1), pcp_child.c (1.1), pool_ipc.h (1.1),
4031 pool_sema.c (1.1), pool_shmem.c (1.1), pool_system.c (1.1),
4032 pool_rewrite_query.c (1.1), pool_rewrite_query.h (1.1),
4033 pool_rewrite_outfuncs.c (1.1), pgpool.8.in (1.1),
4034 pool_query_cache.c (1.1), parser/Makefile.am (1.1),
4035 parser/Makefile.in (1.1), sql/system_db.sql (1.1), parser/gram.c
4036 (1.1), parser/gram.h (1.1), parser/gram.y (1.1),
4037 parser/gramparse.h (1.1), parser/list.c (1.1), parser/makefuncs.c
4038 (1.1), parser/makefuncs.h (1.1), parser/memnodes.h (1.1),
4039 parser/nodes.c (1.1), parser/nodes.h (1.1), parser/parsenodes.h
4040 (1.1), parser/parser.c (1.1), parser/parser.h (1.1),
4041 parser/pg_list.h (1.1), parser/pool_memory.c (1.1),
4042 parser/pool_memory.h (1.1), parser/pool_string.c (1.1),
4043 parser/pool_string.h (1.1), parser/keywords.c (1.1),
4044 parser/keywords.h (1.1), parser/pool_parser.h (1.1),
4045 parser/primnodes.h (1.1), parser/scansup.h (1.1), parser/value.c
4046 (1.1), parser/value.h (1.1), parser/outfuncs.c (1.1),
4047 parser/scan.c (1.1), parser/scan.l (1.1), pcp/Makefile.am (1.1),
4048 pcp/Makefile.in (1.1), pcp/pcp.h (1.1), pcp/pcp.c (1.1),
4049 pcp/pcp_attach_node.c (1.1), pcp/pcp_detach_node.c (1.1),
4050 pcp/pcp_error.c (1.1), pcp/pcp_node_count.c (1.1),
4051 pcp/pcp_stream.c (1.1), pcp/pcp_stream.h (1.1),
4052 pcp/pcp_node_info.c (1.1), pcp/pcp_proc_count.c (1.1),
4053 pcp/pcp_proc_info.c (1.1), pcp/pcp_stop_pgpool.c (1.1),
4054 pcp/pcp_systemdb_info.c (1.1): Initial revision
4056 2006-09-08 12:35 t-ishii
4058 * AUTHORS (1.1.1.1, V2_2_4), INSTALL (1.1.1.1, V2_2_4), depcomp
4059 (1.1.1.1, V2_2_4), install-sh (1.1.1.1, V2_2_4), missing
4060 (1.1.1.1, V2_2_4), mkinstalldirs (1.1.1.1, V2_2_4), md5.c
4061 (1.1.1.1), md5.h (1.1.1.1, V2_2_4), pcp.conf.sample (1.1.1.1,
4062 V2_2_4), sample/dist_def_pgbench.sql (1.1.1.1, V2_2_4), pcp/md5.h
4063 (1.1.1.1, V2_2_4), pcp/md5.c (1.1.1.1) (utags:
4064 ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_0_0, V1_0_1, V1_0_2, V1_1,
4065 V1_1_1, V1_2, V1_2_1, V1_3, V2_0_0, V2_0_0_BETA1, V2_0_1, V2_1_0,
4066 V2_1_0_BETA1, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0, V2_2_0_BETA1,
4067 V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3):
4068 pgpool-II initial release