2009-10-04 18:15 t-ishii * NEWS, configure.in, configure (V2_2_STABLE.[4,5,5]): Prepare 2.2.5 2009-10-04 18:15 t-ishii * doc/pgpool-ja.html (V2_2_STABLE.8): Add release note for 2.2.5 2009-10-04 08:52 t-ishii * doc/tutorial-en.html (V2_2_STABLE.1): Add sample to use rotatelogs 2009-10-03 21:45 t-ishii * doc/tutorial-ja.html (V2_2_STABLE.1): Add sample to use rotatelogs 2009-10-03 21:39 t-ishii * sample/pgpool_recovery_pitr (V2_2_STABLE.1): Enhance online recovery 2nd stage script to sync sequence value 2009-10-03 20:55 t-ishii * pool_proto_modules.h (V2_2_STABLE.5): Remove unnecessary declaration "allow_close_transaction" 2009-10-02 16:56 t-ishii * pool_proto_modules.c (V2_2_STABLE.13): Fix Parse() to use wait_for_query_response() instead of synchronize(). 2009-10-02 16:53 t-ishii * pool_process_query.c (V2_2_STABLE.22): Fix comment 2009-09-26 18:14 t-ishii * pool_proto_modules.c (V2_2_STABLE.12): Allow to print more accurate query when Parse() detects kind mismatch errors. 2009-09-26 16:36 t-ishii * pool_process_query.c (V2_2_STABLE.21): Fix reset_backend to deal with DEALLOCATE error. In this case prepared objects are not removed and reset_backend is infinitely called. Fix do_command to guard against the case that after execution of an SQL command, the backend does not return either N, E or C. This should not happen but there was a report that it actually happend in certain cases(maybe caused by asynchronized backend data?) See: Subject: Re: [Pgpool-general] pgpool 2.2.4: DEALLOCATED children From: Xavier Noguer Date: Fri, 25 Sep 2009 03:35:57 -0400 For more details. Patches by Xavier Noguer with minor tweak by Tatsuo Ishii. 2009-09-25 23:36 t-ishii * pool_proto_modules.c (V2_2_STABLE.11): Make allow_close_transaction to static and add comments. Let execute CREATAE TEMP TABLE on every nodes in master/slave mode. If not, subsequent Parse or Bind to use the table will fail. At this point this doen't work since MASTER_SLAVE set to 0 in ProcessFrontendResponse. More analysis is needed... 2009-09-25 16:35 t-ishii * main.c (V2_2_STABLE.6): Fix write_pid_file. It forgot to write out NULL termination of pid. Pgpool occasionally won't stop because of this bug. 2009-09-23 20:39 t-ishii * pool_process_query.c (V2_2_STABLE.20): Remove error checks for pool_write(frontend), pool_flush(frontend) in SimpleForwardToFrontend. Check error for send_deallocate() in reset_backend. Otherwise send_deallocate will be called infinitely. Per bug report from Agustin Almonte Ferrada. See: Subject: Re: [Pgpool-general] pgpool 2.2.4: DEALLOCATED children From: Agustin Almonte Ferrada To: Tatsuo Ishii Cc: pgpool-general@pgfoundry.org Date: Wed, 23 Sep 2009 01:55:54 -0400 2009-09-23 11:03 t-ishii * pool_auth.c (V2_2_STABLE.2): Fix pool_read_kind and pool_read_int so that the error message for kind is shown in hexadecimal. Other part of pgpool-II already does this. 2009-09-17 20:17 t-ishii * pool_process_query.c, pool_proto_modules.c, pool_proto_modules.h (V2_2_STABLE.[19,10,4]): Teach do_command() to use wait_for_query_response(). insert_lock() calls do_command() to issue LOCK TABLE to lock tables having SERIAL column when insert_lock is true. Problem is, insert_lock() waits forever in do_command() if the target table is locked by someone else. This patch should give a way insert_lock() to espcape from the situation. 2009-09-06 12:52 t-ishii * child.c, pool.h (V2_2_STABLE.[8,5]): Fix connection_count_down() so that it does decrement too much in some corner cases. If failed to read a start up packet, or receive cancel request etc., connection_count_down() is called and goes back to the onnection accept loop. Problem is, at the very beginning of the connection accept loop, if we have received a signal, we call child_exit() which calls connection_count_down() again. Problem report by Ryoichi TANABE. See [pgpool-general-jp: 616] for more details. Also unneccesary public declarations for connection_count_up() and connection_count_down() are removed. 2009-08-24 13:58 t-ishii * ChangeLog (tags: V2_2_4) (V2_2_STABLE.4): Prepare 2.2.4 2009-08-24 13:55 t-ishii * NEWS, configure, doc/pgpool-ja.html (V2_2_STABLE.[3,4,7]) (utags: V2_2_4): Prepare 2.2.4 2009-08-24 13:53 t-ishii * configure.in (tags: V2_2_4) (V2_2_STABLE.4): Prepare 2.2.4. 2009-08-24 13:36 t-ishii * TODO (tags: V2_2_4) (V2_2_STABLE.1): Add a few items 2009-08-22 13:19 t-ishii * child.c, main.c, md5.c, pcp_child.c, pg_md5.c, pool_auth.c, pool_config.c, pool_connection_pool.c, pool_error.c, pool_hba.c, pool_ip.c, pool_params.c, pool_path.c, pool_process_query.c, pool_proto_modules.c, pool_query_cache.c, pool_rewrite_outfuncs.c, pool_rewrite_query.c, pool_sema.c, pool_shmem.c, pool_signal.c, pool_stream.c, pool_system.c, ps_status.c, recovery.c, strlcpy.c, pcp/md5.c (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]) (utags: V2_2_4): Remove unnecessary spaces and tabs at end of line. Patch conributed by Jun Kuriyama. 2009-08-20 15:26 t-ishii * pool_process_query.c (V2_2_STABLE.17): Fix possible bug introduced in pgpool-II 2.2.2. Load balance control variables may remain not be restored and subsequent DML/DDL call might sent to only master node. 2009-08-18 17:38 t-ishii * pool_process_query.c, pool_proto_modules.c, pool_proto_modules.h (tags: V2_2_4) (V2_2_STABLE.[16,8,3]): Change wait_for_query_response() so that it sends NOTICE message to frontend periodically. It appears that pgpool-II 2.2.3 unconditionaly sends param packet to client even it uses version 2 protocol, which is apparentlt wrong. Also tweak checking period from 1 second to 30 seconds since 1 second seems too aggressive. 2009-08-18 17:30 t-ishii * child.c (V2_2_STABLE.6): Remove unneccessary call to send_frontend_exit() in do_child(). 2009-08-13 22:36 t-ishii * child.c (V2_2_STABLE.5): Remove unnessary call of send_frontend_exits() in die(). 2009-08-13 22:34 t-ishii * main.c (V2_2_STABLE.4): Block signals before forking children rather after. Otherwise parent will be killed by failover signal if it receives before establish signal handler. See [pgpool-general-jp: 586] for more details. 2009-08-11 22:53 t-ishii * ChangeLog (tags: V2_2_3) (V2_2_STABLE.3): Prepare 2.2.3. 2009-08-11 22:52 t-ishii * configure.in, configure (V2_2_STABLE.[3,3]) (utags: V2_2_3): Stamp 2.2.3. 2009-08-11 22:48 t-ishii * doc/pgpool-ja.html (tags: V2_2_3) (V2_2_STABLE.6): Fix description of parallel query. Add release note for 2.2.3. 2009-08-11 22:23 t-ishii * pool_connection_pool.c (tags: V2_2_3) (V2_2_STABLE.2): Fix new_connection() so that it does leave garbage in POOL_CONNECTION_POOL->slot[i]. This caused segfault in child_exit(). Bug report at [pgpool-general-jp: 586]. 2009-08-07 14:27 y-mori * pool_process_query.c, pool_rewrite_outfuncs.c (V2_2_STABLE.[15,4]) (utags: V2_2_3): FIX parallel query 1. Fix JOIN Expr Subquery was used on larg or rarg. Subquery was used on ON-Cluase. Full OUTER JOIN was not optimized.   2. Fail_on_error=false was passed to the 3rd arguments of dblink. 2009-08-06 16:55 t-ishii * pool_proto_modules.c (tags: V2_2_3) (V2_2_STABLE.7): Print last query for kind mismatch error message even extended protocol is used. Patch contributed by Akio Ishida. 2009-08-06 16:38 t-ishii * pool_process_query.c (V2_2_STABLE.14): Fix buffer overrun error which mangled kind mismatch error message in pool_send_error_message(). Bug rpeort by Takahiro Itagaki at [pgsql-jp: 39950]. Fix suggested by Akio Ishida at [pgsql-jp: 39952]. 2009-08-01 20:40 t-ishii * child.c (tags: V2_2_3) (V2_2_STABLE.4): Check MASTER_CONNECTION(p)->sp) is non 0 before further referring to sp. Current implementation may interrupt in the window, after setting p and before setting sp. Per bug report from Jun Kuwamura. 2009-08-01 20:34 t-ishii * pool_connection_pool.c (V2_2_STABLE.1): Fix pool_debug's mismatch between data type and conversion specification for time_t. Check MASTER_CONNECTION(p)->sp) is non 0 before further referring to sp. Current implementation may interrupt in the window, after setting p and before setting sp. 2009-07-30 16:46 t-ishii * pool_process_query.c (V2_2_STABLE.13): Fix typo in comment 2009-07-28 14:52 y-mori * doc/: pgpool-en.html (tags: V2_2_4, V2_2_3), pgpool-ja.html (V2_2_STABLE.[3,5]): add restrictions for parallel mode -Natural Join => not support -USING CLAUSE at Join Expression => auto convert to ON CLAUSE 2009-07-26 18:04 t-ishii * pool_rewrite_outfuncs.c (V2_2_STABLE.3): Fix breakage by previous commit. Patch by Guillaume Lelarge. 2009-07-26 12:01 t-ishii * pool_process_query.c (V2_2_STABLE.12): Fix comment about load balancing. 2009-07-26 11:57 t-ishii * pool_sema.c (tags: V2_2_3) (V2_2_STABLE.1): Fix various pool_error/log format errors. Patch provided by Akio Ishida. 2009-07-24 21:30 y-mori * pool_rewrite_outfuncs.c (V2_2_STABLE.2): fix: Join statment in parallel query sample) Accouts table is defined by dist_def, the below query is executed as loadbalance. SELECT a.aid FROM accounts as a JOIN accounts as b ON a.aid=b.aid WHERE a.aid =1 or a.aid=2; 2009-07-22 17:46 t-ishii * child.c, main.c (tags: V2_2_3), pool.h (tags: V2_2_4, V2_2_3), pool_process_query.c, pool_proto_modules.c, pool_rewrite_outfuncs.c, pool_shmem.c (tags: V2_2_3) (V2_2_STABLE.[3,3,4,11,6,1,1]): Fix various pool_error/log format errors. Patch provided by Akio Ishida. 2009-07-22 14:33 t-ishii * pool_process_query.c, pool_proto_modules.c, pool_proto_modules.h (tags: V2_2_3) (V2_2_STABLE.[10,5,2]): Query cancel by statement timeout does not generate "kind mismatch" error any more. How to reproduce the test case: Directory connect to PostgreSQL. T1: BEGIN; T1: LOCK TABLE t1; T2: SET statement_timeout TO 5000; T2: UPDATE t1 SET ... UPDATE query aborts and error message comes out on T2: ERROR: canceling statement due to statement timeout A side effect of this is, statement timeout works correctly (rather than statement timeout value * # of node). Note that to initiate T1 by directory connecting to slave node will not work (still results in kind mismatch error). But I don't think this could happend in the real world. Also refactor error detecting modules (detect_deadlock_error and so on). 2009-07-21 18:48 t-ishii * main.c (V2_2_STABLE.2): Check read(2) error in health_check(). This should detect case described in message below, i.e. postmaster is blocked by SIGSTOP. Subject: [Pgpool-general] Healt Check issues From: Vctrjsn@gmail.com To: pgpool-general@pgfoundry.org Date: Sun, 05 Jul 2009 18:01:18 +0000 2009-07-21 12:59 t-ishii * ChangeLog (V2_2_STABLE.2): Update Change. We are getting closer to 2.2.3. 2009-07-21 10:36 t-ishii * pool.h, pool_proto_modules.c (V2_2_STABLE.[3,4]): Check frontend connection while waiting for response from backend for extended protocol (Execute()). Replace sychronize() with wait_for_query_response(). Also tweak pool.h so that it includes cancel packet's mazic proto number. 2009-07-21 09:26 t-ishii * pool_process_query.c (V2_2_STABLE.9): Do not start transaction if the command is CLUSTER with no argument 2009-07-20 20:47 t-ishii * child.c, pool.h, pool_process_query.c, pool_proto_modules.c, pool_proto_modules.h (V2_2_STABLE.[2,2,8,3,1]): Check frontend connection while waiting for response from backend. This is done in wait_for_query_response() by writing a dummy parameter status packet to pgpool client every 1 second. If the write fails, a cancel packet is sent to backend to free backend. This is usefull to prevent pgpool child from waiting forever for backend response. Pgpool client will diconnect to pgpool if the query takes too long. This is typical use case for Web applications. 2009-07-15 14:14 t-ishii * pool_process_query.c (V2_2_STABLE.7): Fix bug with prepared statement deallocation: Subject: [Pgpool-general] Pgpool probelms From: Nimesh Satam To: pgpool-general@pgfoundry.org Cc: Nimesh Satam Date: Wed, 17 Jun 2009 11:31:37 +0530 This was caused a bug in reset_backend(). if (qcnt >= qn + prepared_list.cnt) { reset_prepared_list(&prepared_list); return 2; } send_deallocate(backend, &prepared_list, qcnt - qn); return 1; Problem is, send_deallocate -> SimpleQuery("DEALLOCATE") calls del_prepared_list, which will decrement prepared_list.cnt. In short, incrementing of qcnt *and* decrementing of prepared_list.cnt happen at the same time. So deallocate is only called 1/2 times than it should be. Bug analysis and fix provided by Akio Ishida. 2009-07-14 17:42 t-ishii * sql/pgpool-recovery/pgpool-recovery.c (tags: V2_2_4, V2_2_3) (V2_2_STABLE.2): Update copyright year 2009-07-14 17:39 t-ishii * sql/pgpool-recovery/pgpool-recovery.c (V2_2_STABLE.1): PostgreSQL 8.4 needs to include utils/binutils.h 2009-06-26 13:59 t-ishii * pool_process_query.c (V2_2_STABLE.6): Fix bug with SimpleForwardToFrontend(). Clients using the extend protocol send 'H'(Flush) after each command. Problem is, SimpleForwardToFrontend does not immediately forward 'C'(Command Complete) packet to frontend. So the client sends 'H' and wait for 'C'. On the other hand backend receives 'H' but reply back nothing since Command complete has nothing to be returned. Both side stuck. The fix is, forwarding 'C' packet immediately after receiving it from backend. To prevent similar bugs happen in the future, I put pool_flush(frontend) after calling SimpleForwardToFrontend in pool_process_query() (other places already do this). The extra pool_flush() might harm performance. So I did some tests using pgbench -S, and found nothing has been changed regarding performance after patching. Bug report from Gavin Sherry along with patches for SimpleForwardToFrontend(). 2009-05-27 11:01 t-ishii * pool.h, pool_process_query.c (V2_2_STABLE.[1,5]): Add pool_set_timeout() to control pool_check_fd()'s behavior. This can be used for various places. The first user is reset_backend() to fix following scenario: Do COPY_FROM(for example pgbench -i) Cancel pgbench pgpool waits for response from backend while sending reset queries and hang. Backend waits for data coming from pgpool forever. BTW, I don't think PostgreSQL's befaviro for COPY_FROM is quite correct since the doc stats:"Receipt of any other non-copy message type constitutes an error that will abort the copy-in state as described above" If my understanding correct, COPY_FROM should abort copy-in state if it receives ABORT (issued in reset_backend). It seems PostgreSQL is not implemented as stated in the doc... 2009-05-24 22:56 t-ishii * sql/pgpool-recovery/Makefile (tags: V2_2_4, V2_2_3) (V2_2_STABLE.1): Support pre 8.0 PostgreSQL which does not have pg_config --pgxs option. Patch provided by Enrico Pirozzi with slight modification by Tatsuo Ishii 2009-05-12 10:01 t-ishii * doc/pgpool-en.html (V2_2_STABLE.2): Fix description of client_idle_limit 2009-05-05 11:07 t-ishii * configure.in, configure, NEWS (tags: V2_2_3) (V2_2_STABLE.[2,2,2]) (utags: V2_2_2): prepare 2.2.2 2009-05-05 11:04 t-ishii * doc/pgpool-ja.html (tags: V2_2_2) (V2_2_STABLE.4): Add 2.2.2 release note 2009-05-02 17:48 t-ishii * pool_process_query.c (tags: V2_2_2) (V2_2_STABLE.4): Fix is_select_query() to test "sql" parameter is NULL. As of 2.2, pgpool sets Portal->sql_string to NULL for SQL command PREPARE. Usually this is ok, since in most cases SQL command EXECUTE follows anyway. Problem is, some applications mix PREPARE with extended protocol command "EXECUTE" and so on. Execute() seems to think this never happens but it is not real. Someday we should extract actual query string from PrepareStmt->query and set it to Portal->sql_string. 2009-05-02 17:45 t-ishii * pool_stream.c (tags: V2_2_3, V2_2_2) (V2_2_STABLE.1): Fix pool_flush() so that it ignores error on frontend connection. This is needed to continue processing with backend, otherwise we risk data incositency. 2009-05-02 17:41 t-ishii * child.c (tags: V2_2_2) (V2_2_STABLE.1): Call pool_send_frontend_exits() before pool_discard_cp() when resetting connection fails. This will avoid "unexpected EOF on client connection" error on when pgpool client exits abnormaly 2009-05-01 09:39 t-ishii * pool_proto_modules.c (tags: V2_2_2) (V2_2_STABLE.2): Add missing patches for this: 2009-04-08 20:11 t-ishii * pool_proto_modules.c (V2_2_STABLE): In master slave mode, sometimes DEALLOCATE fails. This is caused by that the first PREPARE was not executed on the slave. Patch contributed by Toshihiro Kitagawa. 2009-04-25 16:20 t-ishii * ChangeLog (tags: V2_2_2, V2_2_1) (V2_2_STABLE.1): prepare for 2.2.1 2009-04-25 16:16 t-ishii * configure.in, configure (V2_2_STABLE.[1,1]) (utags: V2_2_1): prepare for 2.2.1 2009-04-25 16:12 t-ishii * doc/pgpool-ja.html (tags: V2_2_1) (V2_2_STABLE.3): Add 2.2.1 release note 2009-04-25 16:05 t-ishii * NEWS (tags: V2_2_1) (V2_2_STABLE.1): Prepare 2.2.1 2009-04-08 20:11 t-ishii * pool_proto_modules.c (tags: V2_2_1) (V2_2_STABLE.1): In master slave mode, sometimes DEALLOCATE fails. This is caused by that the first PREPARE was not executed on the slave. Patch contributed by Toshihiro Kitagawa. 2009-04-03 22:49 t-ishii * doc/: pgpool-en.html (tags: V2_2_2, V2_2_1), pgpool-ja.html (V2_2_STABLE.[1,2]): Add documents about configuration reloading. 2009-04-03 19:21 t-ishii * pgpool.spec, redhat/pgpool.conf.sample.patch, redhat/pgpool.init (V2_2_STABLE.[1,1,1]) (utags: V2_2_1, V2_2_2, V2_2_3, V2_2_4): Merge changes made on HEAD regarding RPM spec files 2009-03-23 10:13 devrim * redhat/pgpool.conf.sample.patch (1.1): Add a patch which configures sample conf file to match RPM and Red Hat defaults. 2009-03-14 12:39 t-ishii * pool_process_query.c (tags: V2_2_1) (V2_2_STABLE.3): Fix need_insert_lock so that it returns false if the protocol version is 2. insert_lock has not been working for V2 protocol anyway, so this is ok. 2009-03-08 23:58 gleu * main.c, pgpool.8.in (tags: V2_2_4, V2_2_3) (V2_2_STABLE.[1,1]) (utags: V2_2_1, V2_2_2): Update usage function and man page. 2009-03-07 18:19 t-ishii * pool_process_query.c (V2_2_STABLE.2): Add a comment to need_insert_lock() if the query being used to check if the table has SERIAL column is valid for PostgreSQL 7.3 to 8.3. 2009-03-07 08:54 t-ishii * pool_process_query.c (V2_2_STABLE.1): Make excessive message level in read_kind_from_backend from LOG to DEBUG. 2009-03-01 22:34 t-ishii * doc/pgpool-ja.html (V2_2_STABLE.1): Fix release note for 2.2 2009-02-28 15:33 t-ishii * Makefile.in (tags: V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0) (V2_2_STABLE.1): Update Makefile.am 2009-02-28 15:33 t-ishii * Makefile.am (tags: V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0) (V2_2_STABLE.1): Add doc/load_balance.png, doc/load_balance.odp 2009-02-28 13:45 t-ishii * ChangeLog (1.40), NEWS (1.28), TODO (1.18, V2_2_3, V2_2_2, V2_2_1), configure (1.30) (utags: V2_2_0): Version 2.2 2009-02-28 13:40 t-ishii * configure.in (1.27, V2_2_0): Version 2.2 2009-02-24 11:20 t-ishii * pool_auth.c (1.15, V2_2_3, V2_2_2, V2_2_1), pool_process_query.c (1.141) (utags: V2_2_0): Prpare for receiving parameter status packets. If postgresql.conf was changed and reloaded, PostgreSQL sends parameter status packets asynchronously even those changed parameters are not one of session_authorization etc., which is marked as GUC_REPORT in guc.c(GUC_REPORT means parameter status packet is sent if its value is changed). After receiving those packets, they are discarded. I think this is harmless since most of changes are not affected to the frontend behavior. 2009-02-21 19:00 t-ishii * TODO (1.17), configure (1.29), ChangeLog (1.39) (utags: V2_2_0_RC2): pgpool-II 2.2 RC2 2009-02-21 18:56 t-ishii * configure.in (1.26, V2_2_0_RC2): pgpool 2.2 RC2 2009-02-21 18:52 t-ishii * doc/load_balance.png (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2): A load balance logic explanation figure 2009-02-21 18:47 t-ishii * doc/: pgpool-en.html (1.35), pgpool-ja.html (1.59) (utags: V2_2_0, V2_2_0_RC2): Add comment about rsync and autovacuum. 2009-02-20 10:34 t-ishii * pool_process_query.c (1.140, V2_2_0_RC2): Fix pool_send_frontend_exits() so that it checks the connection to backend if it actually exists. This is needed, for example, in the final stae of online recovery. pgpool child holds 1 connection to a backend. After failback one more backend added but there's no connection to the backend. 2009-02-17 18:50 t-ishii * pool_process_query.c (1.139): Do not start internal transaction if CREATE INDEX CONCURRENTLY 2009-02-17 15:16 devrim * pgpool.spec (1.14, V2_2_0, V2_2_0_RC2): Update to 2.2 (Download URL is broken, since we don't know yet the pgfoundry download URL yet) 2009-02-15 14:35 t-ishii * configure (1.28, V2_2_0_RC1): run autoconf 2009-02-15 14:32 t-ishii * configure.in (1.25, V2_2_0_RC1): 2.2 RC1 2009-02-15 14:31 t-ishii * ChangeLog (1.38, V2_2_0_RC1): Update Changelog 2009-02-15 14:29 t-ishii * TODO (1.16, V2_2_0_RC1): Mention that two items were resolved 2009-02-15 14:26 t-ishii * pgpool.conf.sample (1.26, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2), doc/pgpool-en.html (1.34), doc/pgpool-ja.html (1.58) (utags: V2_2_0_RC1): Reflect the fact that DISCARD ALL holds exclusive lock on pg_listener, thus will degrade performance. 2009-02-10 10:11 t-ishii * pool_process_query.c (1.138, V2_2_0_RC1): Fix is_internal_transaction_needed() so that DROP DATABASE does not start internal transaction 2009-02-07 21:57 t-ishii * configure (1.27, V2_2_0_BETA2): Run autoconf 2009-02-07 21:57 t-ishii * configure.in (1.24, V2_2_0_BETA2): Update version 2009-02-07 21:52 t-ishii * NEWS (1.27, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Update NEWS 2009-02-07 00:30 t-ishii * pool_process_query.c (1.137, V2_2_0_BETA2): Add pid_file_name to show pool_status 2009-02-05 17:24 t-ishii * doc/pgpool-ja.html (1.57, V2_2_0_BETA2): Fix typo 2009-02-05 09:33 t-ishii * ChangeLog (1.37, V2_2_0_BETA2): Run cvs2cl.pl -t --fsf 2009-02-05 09:30 t-ishii * doc/pgpool-ja.html (1.56): Add more fix to release info 2009-02-05 09:26 t-ishii * recovery.c (1.12, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Fix online recovery to wait for failback done before allowing to accept connections from clients. It was supposed to work like this but actually was not since the day 0 when online recovery was born. Without the fix there could be potential data inconsistency among DB nodes. 2009-02-05 09:24 t-ishii * main.c (1.45, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Fix/add comments 2009-02-01 19:13 t-ishii * NEWS (1.26): Add new item 2009-02-01 19:11 t-ishii * pool_process_query.c (1.136): Start internal transaction if necessary. Before we only started transaction INSERT, UPDATE, DELETE and SELECT. Obviously we need to start transaction other than these, for example CREATE TABLE. To avoid an overhead to look up large number of statements (currently 70), we use bsearch() now. 2009-01-31 22:17 t-ishii * doc/pgpool-ja.html (1.55): Update release note 2009-01-30 17:15 t-ishii * test/jdbc/README.euc_jp (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Add comment how to add CLASSPATH 2009-01-30 09:06 y-mori * pool_rewrite_query.c (1.13), pool_rewrite_query.h (1.8, V2_2_4) (utags: V2_2_0, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3): Add comment 2009-01-28 15:48 t-ishii * NEWS (1.25): Add more items 2009-01-27 10:04 t-ishii * COPYING (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Update copyright year 2009-01-25 20:13 t-ishii * NEWS (1.24), TODO (1.15, V2_2_0_BETA2), configure (1.26), configure.in (1.23), version.h (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2), doc/pgpool-en.html (1.33, V2_2_0_BETA2), doc/pgpool-ja.html (1.54) (utags: V2_2_0_BETA1): Prepare 2.2 beta1 2009-01-25 19:13 t-ishii * main.c (1.44), pool.h (1.36, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2), pool_config.l (1.24, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2), pgpool.conf.sample (1.25, V2_2_0_BETA2), pool_config.c (1.27, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2) (utags: V2_2_0_BETA1): Add pid_file_name directive 2009-01-25 13:32 t-ishii * ChangeLog (1.36, V2_2_0_BETA1): ChangeLog is now generated by using cvs2cl.pl -t --fsf 2009-01-25 09:09 t-ishii * pool_rewrite_query.c (1.12, V2_2_0_BETA1): Remove unused static function check_whereClause() Update Copyright year 2009-01-24 20:34 t-ishii * pool.h (1.35): Include limit.h. This seems to be necessary Fedra box. Update copyright year 2009-01-22 18:29 y-mori * pool_stream.c (1.14, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Fix different function name was used in the error message. 2009-01-22 18:16 y-mori * pool_process_query.c (1.135, V2_2_0_BETA1), pool_proto_modules.c (1.6, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pool_rewrite_query.c (1.11), pool_rewrite_query.h (1.7, V2_2_0_BETA1): add the comment related to parallel query 2009-01-22 09:50 t-ishii * child.c (1.26, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Remove unnecessary function declaration for child_exit() Add comments to child_exit() which had no comments at all Modify child_exit() so that it sends terminate mesagges before exiting. This will prevent backend process from being idle waiting for TCP keepalive event occurs. This is not good since a backend process may hold locking on certain tables. 2009-01-22 09:45 t-ishii * pool_process_query.c (1.134): Modify pool_send_frontend_exits() so that it change fd to non block while sending terminate message (X) to backend. This should prevent pgpool from being blocked while sending data to socket. 2009-01-21 10:43 t-ishii * pool_process_query.c (1.133): Add debug code and message 2009-01-18 22:54 t-ishii * ps_status.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Fix FreeBSD case. patch provided by Jun Kuriyama. 2009-01-14 23:54 t-ishii * pool_process_query.c (1.132): Fix excessive debug statement 2009-01-07 22:33 t-ishii * pool_process_query.c (1.131): Add new argument to detect_error() so that it can recognize the error class (E or N). per bug report from Daniel: From: Daniel.Crespo@l-3com.com To: Date: Tue, 6 Jan 2009 12:50:08 -0500 The bug was caused by detect_postmaster_down_error() not detecting receive crash shutdown error. Enbug by: Subject: [Pgpool-committers] pgpool - pgpool-II: Fix detect_error() so that it ignores NOTICE. From: t-ishii@pgfoundry.org (User T-ishii) To: pgpool-committers@pgfoundry.org Date: Tue, 30 Dec 2008 01:05:37 +0000 (UTC) 2009-01-07 22:27 t-ishii * pool_connection_pool.c (1.13, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pool_proto_modules.c (1.5): Update copyright year 2009-01-02 18:38 t-ishii * pool_process_query.c (1.130): Emit pool_error when detects kind mismatch error. Before we only sent error messages to client, but this will leave only on client, which may or may not be kept. Leaving it on pgpool log should leave on pgpool side at least. 2008-12-31 23:45 t-ishii * child.c (1.25), main.c (1.43): Fix typos in comments. Patch contributed by Jun Kuriyama. 2008-12-31 23:42 t-ishii * pool_sema.c (1.5, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Enhance error message when failed to create semaphores. Patch contributed by Jun Kuriyama. 2008-12-31 19:25 t-ishii * pcp/: pcp.c (1.8), pcp.h (1.4), pcp_attach_node.c (1.3), pcp_detach_node.c (1.3), pcp_node_count.c (1.3), pcp_node_info.c (1.3), pcp_proc_count.c (1.4), pcp_proc_info.c (1.3), pcp_recovery_node.c (1.4), pcp_stop_pgpool.c (1.3), pcp_systemdb_info.c (1.3) (utags: V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4): Add -d (debug)option to pcp commands. patch contributed by Jun Kuriyama 2008-12-30 21:16 t-ishii * pool.h (1.34), pool_process_query.c (1.129), pool_proto_modules.c (1.4): Enhance "kind mismatch" error message to include original query. This would not work for extended query, though. 2008-12-30 10:05 t-ishii * pool_process_query.c (1.128): Fix detect_error() so that it ignores NOTICE. Without this following error occurs, for example: BEGIN; BEGIN; ERROR: kind mismatch among backends 0[N] 1[E] 2008-12-30 09:59 t-ishii * child.c (1.24), main.c (1.42), pool.h (1.33), pool_auth.c (1.14, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pool_type.h (1.9, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Fix bug with query cancel. It seems this has not been working since pgpool-II was born. To fix this, now we have each connection's pid and cancel key in the shared memory area. If a cancel packet is sent, the table is searched by the pid and the cancel key. If found, the actual cancel key is sent to each backend. 2008-12-27 16:26 t-ishii * config.h.in (1.7, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Update timestamp 2008-12-23 21:26 t-ishii * pool_process_query.c (1.127): Fix unnessary code(maybe copy & paste error?) Take out internal transction starting code from insert_lock. 2008-12-23 21:24 t-ishii * pool_proto_modules.c (1.3): Fix Query() so that it starts transaction *before* checking insert lock is needed or not 2008-12-23 21:21 t-ishii * child.c (1.23): Do not make a connection cache for postgres database 2008-12-21 21:57 t-ishii * pgpool.conf.sample (1.24): Change insert_lock's default value to true. Since automatic SERIAL data type is implemented, always making insert_lock to true is harmless. 2008-12-21 08:02 t-ishii * pool.h (1.32), pool_config.c (1.26), pool_process_query.c (1.126): If SERIAL data type is used(checked in system catalog) and insert_lock is true(now default) then automatically lock the table. 2008-12-21 07:59 t-ishii * pool_config.l (1.23): Now insert_lock is defaulted to be true 2008-12-20 20:21 t-ishii * pool_process_query.c (1.125): Fix need_insert_lock() so that it runs a little bit faster with no INSERT case. 2008-12-20 20:12 t-ishii * pool_proto_modules.c (1.2): Enhance and fix comments related to Query() 2008-12-13 20:25 t-ishii * parser/gram.c (1.10, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0), Makefile.am (1.21), Makefile.in (1.25), parser/gram.h (1.9, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0) (utags: V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2): Update generated files 2008-12-13 20:23 t-ishii * pool_process_query.c (1.124), pool_proto_modules.c (1.1), pool_proto_modules.h (1.1, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Refactor pool_process_query.c. Now it is devided into pool_process_query.c and pool_proto_modules.c. Also pool_proto_modules.h added which is a companion header file. 2008-12-13 20:21 t-ishii * main.c (1.41): Fix comment 2008-12-13 17:20 t-ishii * pool_process_query.c (1.123): Fix Execute() to avoid kind mismatch error caused by "SET TRANSACTION ISOLATION LEVEL must be called before any query". 2008-12-13 17:13 t-ishii * pool_process_query.c (1.122): Avoid kind mismatch error caused by "SET TRANSACTION ISOLATION LEVEL must be called before any query". This could happen in following scenario: * M:S1:BEGIN; * S:S1:BEGIN; * M:S1:SELECT 1; <-- only sent to MASTER * M:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; * S:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; * M: <-- error * S: <-- ok since no previous SELECT is sent. kind mismatch error occurs! Fix ReadyForQuery() by calling pool_unread if backend after do_error_command executed not returns read for query packet. Fix comments 2008-12-08 22:48 t-ishii * pool_process_query.c (1.121): Check serialization failure error and abort all nodes if so. Otherwise we allow data inconsistency among DB nodes. See following scenario: (M:master, S:slave) M:S1:BEGIN; M:S2:BEGIN; S:S1:BEGIN; S:S2:BEGIN; M:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; M:S2:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; S:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; S:S2:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; M:S1:UPDATE t1 SET i = i + 1; S:S1:UPDATE t1 SET i = i + 1; M:S2:UPDATE t1 SET i = i + 1; <-- blocked S:S1:COMMIT; M:S1:COMMIT; M:S2:ERROR: could not serialize access due to concurrent update S:S2:UPDATE t1 SET i = i + 1; <-- success in UPDATE and data becomes inconsistent! 2008-12-08 21:38 t-ishii * pool_process_query.c (1.120): Forget to add free_string() 2008-12-08 21:32 t-ishii * pool_process_query.c (1.119): Fix uninitialized variable in read_kind_from_backend. Also refactor to make it more effective and readable. Add lots of comments and enhance error message to display eacho kinds. 2008-12-05 23:38 t-ishii * pool_process_query.c (1.118): Fix client_idle_limit_in_recovery handling not to hang when goes into 2nd stage. Also fix grammatical errors in comments. 2008-11-27 09:30 t-ishii * pool_auth.c (1.13): Fix thoughtless coding in MD5 case checking. We should have considered raw mode case. Bug pointed out by Duco Fijma. See discussions below for more details. Subject: [Pgpool-general] MD5 authentication in "raw mode" From: Duco Fijma To: pgpool-general@pgfoundry.org Date: Tue, 25 Nov 2008 13:29:39 +0100 2008-11-15 16:10 t-ishii * pool_process_query.c (1.117): Fix pool_discard_packet. Missing statement in the last commit. 2008-11-15 15:15 t-ishii * pool_process_query.c (1.116): Fix do_error_command. If mistakely assumed that after sending an error query, always ReadyForQuery came right after that. If some debugging or logging verboseness is set, PostgreSQL might sends NOTICE before ReadyForQuery. 2008-11-12 22:42 t-ishii * pool_process_query.c (1.115): Fix do_command in case of notice message sent right after Complete command response. See threads in pgpool-general: Subject: Re: [Pgpool-general] Pgpool-II - replication problems From: "nir osovsky" for more details. 2008-11-10 09:58 t-ishii * pool_process_query.c (1.114): Enhance error message in do_command 2008-11-07 18:20 t-ishii * ChangeLog (1.35), Makefile.in (1.24), aclocal.m4 (1.16, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), configure (1.25), pgpool.conf.sample (1.23), pool.h (1.31), pool_config.c (1.25), pool_config.l (1.22), pool_process_query.c (1.113), pool_stream.c (1.13), doc/pgpool-en.html (1.32), doc/pgpool-ja.html (1.53), parser/Makefile.in (1.16, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pcp/Makefile.in (1.15, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Add client_idle_limit_in_recovery 2008-10-31 14:21 t-ishii * doc/load_balance.odp (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Add a flow chart which explains load balance/replication/send to master only is decided. 2008-10-31 10:31 t-ishii * doc/: pgpool-en.html (1.31), pgpool-ja.html (1.52): Fix wording Fix description for replicate_select and "condition for load balance" section. 2008-10-31 10:28 t-ishii * pgpool.conf.sample (1.22): Fix incorrect comment for recovery_timeout 2008-09-05 13:25 t-ishii * main.c (1.40): Fix and enhance comments 2008-08-29 14:17 t-ishii * pool_process_query.c (1.112): Allow to load balance DECLARE, FETCH and CLOSE. Also fix comments. 2008-08-29 11:54 t-ishii * main.c (1.39): Fix bug in fork_a_child which mistakely closed pipe fds which are not created yet at the startup time 2008-08-28 21:37 t-ishii * pool_process_query.c (1.111): Fix/enhance log messages and comments 2008-08-28 21:35 t-ishii * main.c (1.38): - Close all file descriptors when running in daemon mode. Otherwise we inherit socket from apache when it's started by pgpoolAdmin. This results in that port 80 is occupied for example. Pach provided by Akio Ishida. Also add chdir("/"). This always good for daemon programs. - Always fail over and restart all children. Before we do not restart if master has not been changed. This was wrong. If we have trouble with network cable or something, TCP/IP stack keeps on retrying for long time and the only way to prevent it is restarting process. 2008-07-23 17:50 y-asaba * NEWS (1.23), configure (1.24), configure.in (1.22), doc/pgpool-ja.html (1.51) (utags: V2_1_0): Prepare for 2.1. 2008-07-08 16:53 y-mori * ChangeLog (1.34, V2_1_0), NEWS (1.22) (utags: V2_1_0_RC1): Prepare for pgpool-II 2.1 RC1. -add comment to ChangeLog NEWS 2008-07-08 16:41 y-mori * NEWS (1.21): FIX indent 2008-07-08 16:37 y-mori * doc/pgpool-ja.html (1.50, V2_1_0_RC1): Update release note parallel query bug fix comment 2008-07-08 16:21 y-asaba * Makefile.in (1.23, V2_1_0), aclocal.m4 (1.15, V2_1_0), configure (1.23), configure.in (1.21), parser/Makefile.in (1.15, V2_1_0), pcp/Makefile.in (1.14, V2_1_0) (utags: V2_1_0_RC1): Prepare for pgpool-II 2.1 RC1. 2008-07-04 22:00 y-mori * pool_rewrite_outfuncs.c (1.15, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): FIX: query rewrite of DISTINCT ON 2008-07-04 14:27 y-mori * pool.h (1.30, V2_1_0, V2_1_0_RC1), pool_process_query.c (1.110, V2_1_0, V2_1_0_RC1), pool_rewrite_outfuncs.c (1.14), pool_rewrite_query.c (1.10, V2_1_0, V2_1_0_RC1), pool_stream.c (1.12, V2_1_0, V2_1_0_RC1): FIX: join partitioned tables Delete: pool_read_parallel 2008-07-01 21:26 y-mori * pool_rewrite_outfuncs.c (1.13): fix: Converting JOIN expression from USING to ON in query rewriting at parallel mode 2008-06-30 16:05 y-mori * pool_process_query.c (1.109): Fix Hung up when two or more insert statment was executed in parallel mode 2008-05-30 16:18 y-asaba * pool_process_query.c (1.108): Fixed segfault if client protocol was V2. 2008-05-22 23:36 y-asaba * main.c (1.37, V2_1_0, V2_1_0_RC1): If a backend raised FATAL error while health checking, do not send a Terminate message. Because sending the message fails with EPIPE. 2008-05-08 12:02 y-asaba * child.c (1.22, V2_1_0, V2_1_0_RC1): Fix segfault if all weight values are zero and master node is down. Perf report by Michael SALOMON. 2008-05-04 14:04 y-asaba * sql/pgpool-recovery/pgpool-recovery.c (1.6, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): Use snprintf(). 2008-04-12 03:09 devrim * pgpool.spec (1.13, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): Sync with community spec file. Fix Requires: problem. 2008-04-09 16:45 y-asaba * redhat/pgpool.init (1.4, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): * Remove non-ascii character. * Fix the daemon stdio redirection. Per report by kabe-san. 2008-04-09 16:03 y-asaba * sample/replicate_def_pgbench.sql (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): Fix SQL error. 2008-04-09 16:01 y-asaba * sql/system_db.sql (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): Drop replicate_def table if exists. 2008-04-09 15:26 devrim * redhat/pgpool.init (1.3): - Honor /etc/sysconfig/pgpool settings. Previously we could never customize PGPOOLPID=/var/run/pgpool.pid et al. - Remaining hardcoded paths replaced by customizable variables such as $PGPOOLCONF . 2008-04-09 15:22 y-asaba * Makefile.am (1.20, V2_1_0, V2_1_0_RC1), Makefile.in (1.22): Add sample/replicate_def_pgbench.sql into a release tar ball. 2008-04-07 01:49 devrim * pgpool.spec (1.12): Update to 2.1 beta2 2008-04-04 13:32 y-asaba * NEWS (1.20), doc/pgpool-ja.html (1.49) (utags: V2_1_0_BETA2): Update 2.1 release note. 2008-04-03 22:10 y-asaba * pool_process_query.c (1.107, V2_1_0_BETA2): Fix hang up in Execute. We sended a syntax error query to abort a transaction if replicate_select was true. However, the query was sended over Query message. In extended query mode, we *must* send the query over Execute message. Because postgres discards messages until a Sync is reached when an error is detected. 2008-04-03 14:44 y-asaba * ChangeLog (1.33, V2_1_0_BETA2): Add. 2008-04-03 14:30 y-asaba * pool_process_query.c (1.106): Do not close a internal transaction when Sync message is received after receiving Parse message. This hack is for PHP-PDO. 2008-04-02 11:48 y-asaba * NEWS (1.19), doc/pgpool-ja.html (1.48): Update release note. 2008-04-01 17:31 y-asaba * configure (1.22), configure.in (1.20) (utags: V2_1_0_BETA2): Prepare for 2.1 beta2. 2008-04-01 10:12 y-asaba * pool_rewrite_outfuncs.c (1.12, V2_1_0_BETA2): Fix "AS" handling in FROM clause. Patch contributed by sho-san. 2008-03-31 17:27 y-asaba * pgpool.8.in (1.4, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Enhance manpage. patch contributed by kabe-san. - no hypenation, no justify for better greppability - have explicit subsection for [noargs], stop, switch for readability - some phrases rewritten to suit manpages - add "-v" option 2008-03-31 17:07 y-asaba * ChangeLog (1.32): Add items. 2008-03-31 13:19 t-ishii * TODO (1.14, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Add Docs section and add an item (writelibpcp docs) 2008-03-31 11:56 y-asaba * NEWS (1.18), doc/pgpool-ja.html (1.47): Add a item into 2.1 release note. 2008-03-28 01:06 y-asaba * child.c (1.21), pool_hba.c (1.5, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1) (utags: V2_1_0_BETA2): Use child_exit() instead of exit(). 2008-03-28 01:04 y-asaba * pcp_child.c (1.11, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2), recovery.c (1.11) (utags: V2_1_0, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0_BETA1): Fix a race condition between SIGUSR2 signal and pause(). 2008-03-28 01:01 y-asaba * pool_connection_pool.c (1.12, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Fix core dump with the following scenario. 1. detach a node. 2. create connection pool 3. attach the node. 4. reuse the connection pool 2008-03-27 17:26 y-asaba * doc/pgpool-ja.html (1.46): Remove a wrong restriction. 2008-03-27 16:54 y-asaba * doc/: pgpool-en.html (1.30, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2), pgpool-ja.html (1.45), pgpool.css (1.6, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2), tutorial-en.html (1.6, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2), tutorial-ja.html (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Add copyright. 2008-03-27 16:24 y-asaba * doc/: tutorial-en.html (1.5), tutorial-ja.html (1.4): Add an example to rotate pgpool log files. 2008-03-27 11:53 y-asaba * pool_process_query.c (1.105): Improve network I/O routine. 2008-03-27 11:51 t-ishii * doc/pgpool-en.html (1.29): Add description about the timing of recovery command invocation 2008-03-27 11:49 t-ishii * TODO (1.13): Add TODO items 2008-03-26 18:18 t-ishii * doc/pgpool-ja.html (1.44): Add description about the timing of recovery command invocation 2008-03-25 14:15 t-ishii * TODO (1.12): Add more TODO 2008-03-25 10:00 t-ishii * TODO (1.11): Translate into English 2008-03-20 17:33 t-ishii * doc/: pgpool-en.html (1.28), pgpool-ja.html (1.43): Enhance reset_query_list description. 2008-03-20 16:33 t-ishii * doc/: pgpool-en.html (1.27), pgpool-ja.html (1.42): Add info about pgpool-II download page. 2008-03-18 17:39 y-asaba * pgpool.conf.sample (1.21, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Remove ";" in recovery_timeout. 2008-03-14 16:09 y-asaba * doc/: pgpool-en.html (1.26), pgpool-ja.html (1.41) (utags: V2_1_0_BETA1): * Changed title from README to user manual. * Emphasized load balancing note. 2008-03-14 16:06 y-asaba * doc/pgpool.css (1.5, V2_1_0_BETA1): Add

style. 2008-03-14 15:57 y-asaba * NEWS (1.17, V2_1_0_BETA1): Reviewed. 2008-03-14 15:53 y-asaba * doc/pgpool-en.html (1.25): Updated English documentation. 2008-03-14 15:30 y-asaba * doc/pgpool-ja.html (1.40): Add recovery_timeout description. 2008-03-14 14:45 y-asaba * NEWS (1.16): Added 2.1 beta release note. I hope to review it. 2008-03-14 11:43 y-asaba * doc/pgpool-ja.html (1.39): Added 2.1 release note. 2008-03-14 11:00 y-asaba * pgpool.conf.sample (1.20, V2_1_0_BETA1): Add comment for '%M' format. 2008-03-14 10:35 y-asaba * ChangeLog (1.31, V2_1_0_BETA1): Add entries. 2008-03-13 22:11 y-asaba * pool_process_query.c (1.104, V2_1_0_BETA1): * Fixed kind mismatch error in master slave mode with following scenario. This bug was introduced in pgpool-II v2.0. BEGIN; SET client_encoding TO SJIS; * Fixed load balancing in master slave mode. This bug was introduced in pgpool-II v2.0. 2008-03-13 16:01 y-asaba * pg_md5.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Fix compile error on FreeBSD. Per report by ISHIDA Akio. 2008-03-13 12:46 y-asaba * ylwrap (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Add ylwrap generated by automake 1.10. 2008-03-13 03:22 devrim * pgpool.spec (1.11, V2_1_0_BETA2, V2_1_0_BETA1): Update to 2.1 beta1 2008-03-12 21:33 y-asaba * configure (1.21), configure.in (1.19) (utags: V2_1_0_BETA1): Stamp beta1. 2008-03-12 18:33 t-ishii * pgpool.conf.sample (1.19): Fix comments for load_balance_mode which were no longer true. 2008-03-12 18:32 y-asaba * pool_config.c (1.24, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Run flex v2.5.33 2008-03-12 18:32 y-asaba * version.h (1.4, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Change version string. 2008-03-12 18:31 y-asaba * child.c (1.20, V2_1_0_BETA1), pool_process_query.c (1.103): If load_balance_mode is false, then pgpool does not calculate load balancing node. 2008-03-12 14:06 y-asaba * main.c (1.36, V2_1_0_BETA2, V2_1_0_BETA1): health_check_timeout did not work correctly. Report and patch by Kenichi Sawada. 2008-03-12 14:00 y-asaba * main.c (1.35): Improve bind(2) and unlink(2) error message. Patch contributed by Jun Kuriyama. 2008-03-12 13:53 y-asaba * pcp/pcp_recovery_node.c (1.3, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Fix typos in pcp_recovery_node.c usage. Patch contributed by Jun Kuriyama. 2008-03-12 13:51 y-asaba * Makefile.in (1.21, V2_1_0_BETA2, V2_1_0_BETA1), aclocal.m4 (1.14, V2_1_0_BETA2, V2_1_0_BETA1), config.h.in (1.6, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), configure (1.20), configure.in (1.18), parser/Makefile.in (1.14, V2_1_0_BETA2, V2_1_0_BETA1), pcp/Makefile.in (1.13, V2_1_0_BETA2, V2_1_0_BETA1): Support set_ps_display on FreeBSD. Patch contributed by ISHIDA Akio. 2008-03-12 12:54 t-ishii * pool_auth.c (1.12, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Add detailed error messages when auth phase fail. Current messages: pool_read_message_length: message length (8 ) in slot 1 does not match with slot 0(12) is confusing and does very little help. 2008-03-12 11:01 y-asaba * pool_process_query.c (1.102): Fixed DEALLOCATE ALL processing. 2008-03-11 12:04 y-asaba * ChangeLog (1.30): Added entries. 2008-03-11 11:54 y-asaba * main.c (1.34), doc/pgpool-en.html (1.24), doc/pgpool-ja.html (1.38): * Add '%M'format to obtain old master node ID into failover_command and failback_command. * When master node was down, killed all children process during executing failover_command. * Fixed SIGSEGV if backend0 was undefined. 2008-03-11 11:49 y-asaba * pool_process_query.c (1.101): Fixed hang up if a node was executed immediate shutdown. 2008-03-11 00:08 t-ishii * pool_auth.c (1.11): Fix using uninialized varible in pool_read_message_length() 2008-03-10 13:37 t-ishii * pool_process_query.c (1.100): [no log message] 2008-03-04 16:58 y-asaba * ChangeLog (1.29): Add entries. 2008-03-03 12:39 y-asaba * pool_process_query.c (1.99): Fix hang up after processing "show pool_status". Per report by ISHIDA Akio. 2008-02-29 13:49 yamaguti * ChangeLog (1.28): added entry for the change in pg_md5.c 2008-02-29 13:40 yamaguti * pg_md5.c (1.2): * implement password prompt with option "-p" (patch contributed by Volkan Yazici) * disable ECHO while reading password from stdin 2008-02-26 18:55 y-asaba * main.c (1.33): - Add comment. - Add -v option, which prints version info. 2008-02-25 20:22 y-asaba * recovery.c (1.10, V2_1_0_BETA1): Improve error message. 2008-02-25 11:58 y-asaba * pool_process_query.c (1.98): Fix asynchronous query handling. When ReadyForQuery message was received, pgpool set off loadbalancing flag, internal transaction flag and so on. If client sended a Query message before receiving the ReadyForQuery message, pgpool reported error message. So, we block the Query message while backend nodes process a query. 2008-02-20 19:12 y-asaba * pool_process_query.c (1.97): Return TRUE in is_select_query() if a query is "COPY TO STDOUT". kind mismatching error was caused by pg_dump or pg_dumpall. Per report by Bruno Lustosa. 2008-02-19 14:54 y-asaba * Makefile.in (1.20), aclocal.m4 (1.13), configure (1.19), configure.in (1.17): Stamp 2.1-devel. We hope to release 2.1 on March. 2008-02-19 14:46 y-asaba * pool_process_query.c (1.96): Fix HINT clause handling in extended query protocol. pgpool did not replicate the following query with extended query protocol. /* REPLICATION */ SELECT func(); Per report by Sagar Thapa. 2008-02-19 14:18 y-asaba * pool_process_query.c (1.95): Fix misspell. Patch contributed by Jun Kuriyama. 2008-02-18 18:58 y-asaba * pool_stream.c (1.11, V2_1_0_BETA2, V2_1_0_BETA1): Add error checking. 2008-02-15 18:43 y-asaba * main.c (1.32): Polling signals per 3 secs when health check is disabled. 2008-02-15 18:36 y-asaba * main.c (1.31): Fix zombie process problem. "switching" flag did not clear when invalid node ID was detached. 2008-02-15 15:19 y-asaba * pool_process_query.c (1.94): Fix DISCARD statement handling. 2008-02-15 13:04 y-asaba * main.c (1.30): Fix compiler warning. 2008-02-14 14:48 y-asaba * main.c (1.29): Add comment. 2008-02-14 14:24 y-asaba * ChangeLog (1.27): Add ChangeLog items. 2008-02-14 14:09 y-asaba * main.c (1.28): Fix a failover bug that pgpool did not determine a next master node in raw_mode. 2008-02-14 14:05 y-asaba * pool_connection_pool.c (1.11, V2_1_0_BETA1): Do not create connection cache to standby nodes in raw_mode. As a result, we can use pgpool-II + warm standby with raw_mode. 2008-02-12 20:16 y-asaba * child.c (1.19), pgpool.conf.sample (1.18), pool.h (1.29, V2_1_0_BETA2, V2_1_0_BETA1), pool_config.c (1.23), pool_config.l (1.21, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_process_query.c (1.93), pool_stream.c (1.10), doc/pgpool-en.html (1.23), doc/pgpool-ja.html (1.37): Remove "replication_timeout" parameter. This parameter was enabled if replication_strict = false. However replication_strict was already removed. 2008-02-12 16:29 yamaguti * pool.h (1.28): Fix a bug in raw mode where only 1 of multiple nodes were recognized by pgpool. 2008-02-08 19:57 y-asaba * pool_stream.c (1.9): Fix wrong timeout handling in pool_read2() and pool_read_string(). 2008-02-08 17:10 yamaguti * pcp/pcp.c (1.7, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Disabled PCP client's timeout. PCP commands still take timeout option, but ignores and set notimeout. 2008-02-08 15:47 y-asaba * sql/pgpool-recovery/pgpool-recovery.c (1.5, V2_1_0_BETA2, V2_1_0_BETA1): PostgreSQL superuser can *only* execute pgpool_recovery and pgpool_remote_start functions because of security issue. 2008-02-08 15:47 yamaguti * main.c (1.27), pcp_child.c (1.10, V2_1_0_BETA1), recovery.c (1.9): Implemented configuration file "reload" function into PCP. 2008-02-08 13:11 yamaguti * recovery.c (1.8): Use "recovery_timeout" to decide how long pgpool should wait before online-recovery fails. 2008-02-08 13:10 yamaguti * pgpool.conf.sample (1.17), pool.h (1.27), pool_config.c (1.22), pool_config.l (1.20): added a new configuration parameter "recovery_timeout". pgpool waits so many seconds, specified by recovery_timeout, for: 1) all client connections are closed before the 2nd stage 2) a remote host to start up in the final stage Note that "recovery_timeout = 0" means NO WAIT; not no timeout. 2008-02-05 19:05 y-asaba * pool_auth.c (1.10): Fix minor bug introduced by previous commit. 2008-02-05 18:57 y-asaba * pool_auth.c (1.9): Fix authentication error when master was down. 2008-02-05 11:13 y-asaba * pool_process_query.c (1.92): Remove unneccesary flushing output buffer. 2008-01-29 11:01 y-asaba * doc/pgpool-ja.html (1.36): Add description of recovery script. 2008-01-29 10:56 y-asaba * ChangeLog (1.26), child.c (1.18), main.c (1.26), pcp_child.c (1.9), pool.h (1.26), pool_auth.c (1.8), pool_config.c (1.21), pool_config.l (1.19), pool_connection_pool.c (1.10), pool_error.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_hba.c (1.4, V2_1_0_BETA1), pool_ip.c (1.2, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_ip.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_ipc.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_params.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_path.c (1.2, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_path.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_process_query.c (1.91), pool_query_cache.c (1.9, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_rewrite_query.c (1.9, V2_1_0_BETA2, V2_1_0_BETA1), pool_rewrite_query.h (1.6, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_sema.c (1.4, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_shmem.c (1.3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_signal.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_signal.h (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_stream.c (1.8), pool_system.c (1.5, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_type.h (1.8, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), ps_status.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), recovery.c (1.7), strlcpy.c (1.2, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), COPYING (1.3, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/Makefile.in (1.12), pcp/pcp.c (1.6), pcp/pcp.h (1.3, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_attach_node.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/Makefile.in (1.13), parser/copyfuncs.c (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/gram.c (1.9, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_detach_node.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_error.c (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_node_count.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_node_info.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_proc_count.c (1.3, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_proc_info.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_recovery_node.c (1.2), pcp/pcp_stop_pgpool.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_stream.c (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_stream.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_systemdb_info.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), sql/pgpool-recovery/pgpool-recovery.c (1.4), parser/gram.h (1.8, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/gram.y (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/keywords.c (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/keywords.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/list.c (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/makefuncs.c (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/makefuncs.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/memnodes.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/nodes.c (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/nodes.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/outfuncs.c (1.6, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/parsenodes.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/parser.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pg_list.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_memory.c (1.10, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_memory.h (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_parser.h (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_string.c (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_string.h (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/primnodes.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/scan.c (1.8, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/scan.l (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/scansup.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/value.c (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/value.h (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Update copyright. 2008-01-28 11:31 y-asaba * ChangeLog (1.25): Add item. 2008-01-28 11:26 y-asaba * pool_process_query.c (1.90): Change log level of the following message from ERROR to LOG. ProcessFrontendResponse: failed to read kind from frontend. fronend abnormally exited This means that pgpool detects unexpected EOF. This is not pgpool's error. 2008-01-25 18:49 y-asaba * ChangeLog (1.24): Add item. 2008-01-25 16:20 y-asaba * pool_process_query.c (1.89): Load balancing node was changed after processing transaction. For example, SELECT 1; <-- node 1 BEGIN; SELECT 2; <-- node 0(master) END; SELECT 3; <-- node 0(master) "SELECT 3" was sended to a master node, not a load balancing node. VALID_BACKEND macro does not check node validation if in_load_balancing is 1. So we do not use VALID_BACKEND macro to check whether load balancing node is down. 2008-01-19 18:49 y-asaba * pool_process_query.c (1.88): Add comments. 2008-01-15 11:10 y-asaba * pool_process_query.c (1.87): Remove unused variable. 2008-01-11 12:11 y-asaba * pool_process_query.c (1.86): Add comments. 2008-01-11 11:30 y-asaba * ChangeLog (1.23), main.c (1.25), pool_hba.c (1.3), pool_process_query.c (1.85), parser/parser.c (1.5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_memory.c (1.9), parser/pool_memory.h (1.4): Fix memory leak at prepared statement list. pgpool caches a parse tree in prepared statement list. The parse tree copy deeply, but we freed only the top node of the parse tree. 2008-01-09 18:10 y-asaba * recovery.c (1.6): Refactoring recovery code. 2008-01-08 13:31 y-asaba * main.c (1.24): Fix compile error. 2008-01-08 11:20 y-mori * doc/: tutorial-en.html (1.4), tutorial-ja.html (1.3) (utags: V2_1_0_BETA1): FIX tutorial Because replicate_def table is confused dist_def table when a parallel mode is set according to the tutorial, data is not divided. 2008-01-02 17:32 t-ishii * main.c (1.23): Fix bug in previous commit Fix typo 2007-12-27 12:00 y-asaba * ChangeLog (1.22): Add ChangeLog items. 2007-12-27 11:21 y-asaba * main.c (1.22), pgpool.conf.sample (1.16), doc/pgpool-en.html (1.22), doc/pgpool-ja.html (1.35): Allow '%m' character to obtain master node id in failover_command and failback_command. 2007-12-26 16:05 y-asaba * doc/: pgpool-en.html (1.21), pgpool-ja.html (1.34): Add multi-statement restriction. 2007-12-26 11:40 y-asaba * pool_process_query.c (1.84): Fix internal transaction handling in extended query protocol. pgpool did not send "COMMIT" to close an internal transaction block. 2007-12-22 09:11 t-ishii * recovery.c (1.5): Add lots of pool_log to show the recovery steps 2007-12-11 12:59 t-ishii * main.c (1.21): Change "starting health checking" and "retrying %d th health checking" log messages to DEBUG messages since they are too verbose. 2007-12-07 15:35 y-asaba * TODO (1.10, V2_1_0_BETA1): TODO: Add replication function list. 2007-12-07 14:08 y-asaba * child.c (1.17), config.h.in (1.5), configure (1.18), configure.in (1.16), pcp_child.c (1.8), pool_config.c (1.20), pool_config.l (1.18), pcp/pcp.c (1.5): Fix compile error and warning on Solaris 10. 2007-12-06 13:59 y-mori * pool_rewrite_query.c (1.8): FIX: INSERT statment in a parallel mode How to count the Value Clause list was wrong 2007-12-05 17:15 y-asaba * pool_stream.c (1.7): Improve buffering algorithm in pool_write(). 2007-12-03 10:47 y-asaba * pool_process_query.c (1.83): Don't output log if PostgreSQL send a warning message in do_command(). 2007-12-02 11:45 y-asaba * pool_process_query.c (1.82): Fix segmentation fault if CloseComplete command was received. 2007-12-01 23:50 y-asaba * pool_process_query.c (1.81): Fix memory leak when PREPARE or DEALLOCATE is failed. 2007-12-01 22:26 y-asaba * pool_process_query.c (1.80): Remove debug log. 2007-11-30 16:38 y-mori * pool_rewrite_query.c (1.7): Fix: The INSERT statment did not correspond to the parser of postgresql 8.3 that pgpool-II 2.0 had. Therefore, the following errors occur if INSERT is done in a parallel mode ERROR: pgpool2 sql restriction DETAIL: cannot use SElectStmt in InserStmt 2007-11-24 22:04 t-ishii * doc/: pgpool-en.html (1.20), pgpool-ja.html (1.33): Fix english docs. Add a link to tutorial. 2007-11-23 09:14 t-ishii * pool_config.c (1.19), pool_config.l (1.17): Add missing replicate_select entry. per bug report on [pgsql-jp: 38968]. 2007-11-22 04:35 devrim * pgpool.spec (1.10): Update to 2.0.1 2007-11-21 19:18 y-asaba * configure (1.17), configure.in (1.15) (utags: V2_0_1): Prepare for 2.0.1. 2007-11-21 19:09 y-asaba * NEWS (1.15), doc/pgpool-ja.html (1.32) (utags: V2_0_1): Release note for pgpool-II 2.0.1. 2007-11-21 18:39 y-asaba * ChangeLog (1.21, V2_0_1): update. 2007-11-21 18:37 y-asaba * pool_process_query.c (1.79, V2_0_1): Fix segmentation fault when UPDATE or DELETE is executed. The bug is critical so we must release 2.0.1 as soon as possible. 2007-11-21 13:47 y-asaba * recovery.c (1.4, V2_0_1): Use snprintf() instead of sprintf(). 2007-11-21 10:47 y-asaba * pool_process_query.c (1.78): Send a syntax error query to a master node when master_slave is true. 2007-11-16 14:29 y-mori * doc/: pgpool-en.html (1.19, V2_0_1), pgpool-ja.html (1.31) (utags: V2_0_0): ADD: documents (Setting method of Query cache) 2007-11-16 11:52 y-asaba * pool_auth.c (1.7, V2_0_1, V2_0_0): Fix segmentation fault in a password authentication when a node is down. 2007-11-16 10:56 y-asaba * ChangeLog (1.20, V2_0_0): pgpool-II 2.0 2007-11-16 10:51 y-asaba * Makefile.in (1.19, V2_0_1), aclocal.m4 (1.12, V2_0_1), configure (1.16), parser/Makefile.in (1.12, V2_0_1), parser/gram.c (1.8, V2_0_1), parser/gram.h (1.7, V2_0_1), pcp/Makefile.in (1.11, V2_0_1) (utags: V2_0_0): Prepare for pgpool-II 2.0. 2007-11-16 10:39 y-asaba * doc/: pgpool-en.html (1.18), pgpool-ja.html (1.30): - Fix the sample script of online recovery. - Add note about timeout of pcp_recovery_node. 2007-11-16 09:20 gleu * doc/pgpool-en.html (1.17): Typo fix. 2007-11-15 09:39 y-mori * pool_rewrite_outfuncs.c (1.11, V2_1_0_BETA1), pool_rewrite_query.h (1.5) (utags: V2_0_0, V2_0_1): FIX: It corresponed to the following Queries. ex) select * from (select a,b,c from t1) as t2(d,e,f) ~~~~~ 2007-11-14 16:46 y-mori * pool_process_query.c (1.77, V2_0_0): FIX: The load-balnace was not functioning in a parallel mode 2007-11-14 13:59 y-mori * pool_rewrite_outfuncs.c (1.10): FIX: It made a mistake in the processing of OUTER JOIN (syntax of C lang) 2007-11-14 12:59 y-mori * pool.h (1.25, V2_0_1, V2_0_0), pool_process_query.c (1.76), pool_stream.c (1.6, V2_0_1, V2_0_0): fix: -When the setting of replication_timeout was effective, SELECT that the execution time is long did the time-out in only a parallel mode. -A wrong number was displayed when replicated table was updated or deleted in only a parallel mode. 2007-11-13 10:44 y-asaba * configure.in (1.14, V2_0_0): Prepare for pgpool-II 2.0. 2007-11-13 03:12 devrim * doc/pgpool-en.html (1.16): Removed some garbage chars Fixed indendation of some paragraphs Fixed some typos There seems a lot to do btw. 2007-11-12 18:04 y-asaba * NEWS (1.14, V2_0_0), doc/pgpool-ja.html (1.29): Prepare for pgpool-II 2.0. 2007-11-12 18:02 y-asaba * doc/pgpool-ja.html (1.28): Fix typo. 2007-11-12 17:34 y-mori * doc/tutorial-en.html (1.3, V2_0_1, V2_0_0): add: pgpoo-II 2.0 tutorial -parallel-query section 2007-11-12 15:40 y-mori * doc/: pgpool-en.html (1.15), pgpool-ja.html (1.27): add: pgpool-II 2.0 manual. -add parallel-query section fix: Japanese manual. - typo 2007-11-09 16:25 y-mori * doc/: pgpool-ja.html (1.26), pgpool.css (1.4, V2_0_1, V2_0_0), tutorial-ja.html (1.2, V2_0_1, V2_0_0): pgpoo-ll 2.0 manual & tutorial (Japanese) - Add parallel query section 2007-11-09 15:09 y-mori * sample/replicate_def_pgbench.sql (1.1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0): ADD Sample SQL file 2007-11-09 13:56 y-mori * sql/system_db.sql (1.2, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0): ADD "replicate_def" table in "pgpool_catalog" schema 2007-11-09 13:41 y-asaba * pgpool.8.in (1.3, V2_1_0_BETA1, V2_0_1, V2_0_0): Add reload option. 2007-11-09 13:37 y-asaba * main.c (1.20, V2_0_1, V2_0_0): Add pgpool reload in usage(). 2007-11-09 12:00 y-asaba * Makefile.am (1.19), test/jdbc/README.euc_jp (1.1, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1) (utags: V2_0_0, V2_0_1, V2_1_0_BETA1, V2_1_0_BETA2): Add README.euc_jp 2007-11-08 10:43 y-asaba * doc/pgpool-en.html (1.14): pgpool-II 2.0 manual. - Add online recovery section. - Add new parameters. TODO: review my English... 2007-11-07 19:05 y-asaba * pool_process_query.c (1.75): Send Sync message before calling insert_lock(). 2007-11-07 15:35 y-mori * pool_rewrite_outfuncs.c (1.9): fix: join rule for /*NOT*/SQL99 type join,CROSS JOIN and NATURAL JOIN 2007-11-06 16:07 y-asaba * test/jdbc/InsertTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), test/jdbc/RunTest.java (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), test/jdbc/pgpool.properties (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), test/jdbc/prepare.sql (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), test/jdbc/expected/insert (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), Makefile.am (1.18): Add INSERT statement test. 2007-11-05 14:26 y-asaba * pool_process_query.c (1.74): Fix insert_lock with extended query protocol. 2007-11-05 11:08 y-asaba * pool_process_query.c (1.73): Use FD_SETSIZE instead of 1024 at set_fd, isset_fd and zero_fd. 2007-11-05 10:41 y-asaba * pool_process_query.c (1.72): Ignore white space in need_insert_lock(). 2007-11-02 18:20 y-mori * pool_process_query.c (1.71): Fix: compile error at FreeBSD4.1 2007-11-02 01:57 devrim * pgpool.spec (1.9, V2_0_1, V2_0_0): Update spec file for 2.0 beta1 2007-11-01 19:14 y-asaba * Makefile.am (1.17): Fix compile error with SUN's cc. 2007-11-01 19:11 y-asaba * configure.in (1.13), pool_process_query.c (1.70), parser/Makefile.am (1.4, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), pcp/Makefile.am (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0): Fix compile error with SUN's cc. 2007-11-01 17:17 y-asaba * pcp/pcp_proc_count.c (1.2, V2_0_1, V2_0_0): Fix warning with SUN's cc. 2007-11-01 11:08 t-ishii * Makefile.in (1.18, V2_0_0_BETA1): Rerun autoconf 2007-11-01 11:01 y-asaba * Makefile.am (1.16, V2_0_0_BETA1): Remove test.diff 2007-11-01 10:45 t-ishii * Makefile.in (1.17), aclocal.m4 (1.11, V2_0_0_BETA1), configure (1.15, V2_0_0_BETA1), pool_config.c (1.18, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/Makefile.in (1.11, V2_0_0_BETA1), pcp/Makefile.in (1.10, V2_0_0_BETA1): Run autoconf 2007-10-31 19:45 y-asaba * NEWS (1.13), pgpool.conf.sample (1.15, V2_0_1, V2_0_0), pool.h (1.24), pool_config.l (1.16, V2_0_1, V2_0_0), pool_process_query.c (1.69), doc/pgpool-en.html (1.13), doc/pgpool-ja.html (1.25) (utags: V2_0_0_BETA1): Remove replicate_strict derective. pgpool-II 2.x always set to true. 2007-10-31 19:13 y-asaba * ChangeLog (1.19, V2_0_0_BETA1): pgpool-II 2.0 beta1 2007-10-31 18:41 y-mori * test/pdo-test/README.euc_jp (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1): ADD: pdo test program manual(Japanese) 2007-10-31 15:10 y-asaba * doc/pgpool-ja.html (1.24): Add comments about reloadable derectives. 2007-10-31 13:15 y-asaba * pool_config.l (1.15): Allow to reload pcp_timeout. 2007-10-31 12:49 y-mori * pool_rewrite_outfuncs.c (1.8, V2_0_0_BETA1): FIX: "IN" predicate at query rewriting 2007-10-31 12:31 y-asaba * NEWS (1.12): pgpool-II 2.0(beta1) release note. 2007-10-30 21:44 t-ishii * pool_auth.c (1.6, V2_0_0_BETA1): Fix confusing variable name Enhance error message Check unsupported auth method 2007-10-30 16:13 y-asaba * pool_process_query.c (1.68): Fix segfault with "SHOW pool_status". 2007-10-30 16:09 y-asaba * Makefile.am (1.15): Remove gprof option. 2007-10-30 15:58 y-asaba * doc/: pgpool-ja.html (1.23), pgpool.css (1.3, V2_0_0_BETA1): Improve online-recovery documentation. 2007-10-30 11:35 y-asaba * configure.in (1.12, V2_0_0_BETA1): Prepare for pgpool-II 2.0 beta1. 2007-10-30 11:11 y-asaba * pool_auth.c (1.5): Previous commit did not support V2 protocol. 2007-10-30 10:53 y-asaba * pool_auth.c (1.4): Send the following error message to frontend if client auth method is md5 password in replication, master-slave and parallel modes. MD5 authentication is unsupported in replication, master-slave and parallel modes. 2007-10-29 17:12 y-asaba * Makefile.am (1.14): Merge V1_STABLE branch. 2007-10-29 15:55 y-asaba * pgpool.spec (1.8, V2_0_0_BETA1): Merge V1_STABLE branch. 2007-10-29 15:28 y-asaba * redhat/: pgpool.init (1.2), pgpool.sysconfig (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1) (utags: V2_0_0, V2_0_0_BETA1, V2_0_1, V2_1_0_BETA1, V2_1_0_BETA2): Merge redhat scripts from V1_STABLE branch. 2007-10-29 15:09 y-asaba * doc/pgpool-ja.html (1.22): Fix insert_lock description. 2007-10-29 14:52 y-asaba * doc/pgpool-ja.html (1.21): Add new directives and update description of online recovery. 2007-10-29 14:50 y-asaba * pgpool.conf.sample (1.14), pool.h (1.23), pool_config.l (1.14), pool_process_query.c (1.67), recovery.c (1.3, V2_0_0, V2_0_0_BETA1): Add new directives "recovery_1st_stage_command" and "recovery_2nd_stage_command". pgpool don't block client connections and data update operations while executing recovery_1st_stage_command. In recovery_2nd_stage_command, pgpool block them. If you recover by PITR, the first stage command get a base backup. Then you switch XLOG in the second stage command. 2007-10-29 13:37 y-asaba * sql/pgpool-recovery/: pgpool-recovery.c (1.3), pgpool-recovery.sql.in (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1) (utags: V2_0_0, V2_0_0_BETA1, V2_0_1): Change pgpool_recovery signature from pgpol_recovery(text, text) to pgpool_recovery(text, text, text). The first argument is script name. * pgpool_recovery arguments: #1: script name #2: remote host name #3: remote database cluster path return value: command status (= "$?" value) 2007-10-29 13:16 y-mori * pool_process_query.c (1.66), pool_rewrite_outfuncs.c (1.7), pool_rewrite_query.h (1.4, V2_0_0_BETA1), parser/outfuncs.c (1.5, V2_0_1, V2_0_0, V2_0_0_BETA1): add optimization of aggregate function and group by clause in parallel mode 2007-10-29 10:20 t-ishii * Makefile.in (1.16), pgpool.conf.sample (1.13), pool.h (1.22), pool_config.c (1.17), pool_config.l (1.13), pool_process_query.c (1.65), parser/gram.c (1.7, V2_0_0_BETA1), parser/scan.c (1.7, V2_0_1, V2_0_0, V2_0_0_BETA1): Change child_idle_limit to client_idle_limit 2007-10-26 20:28 y-asaba * pool_process_query.c (1.64): All signals are blocked while sending a "COMMIT" command. 2007-10-26 16:41 y-asaba * pool_process_query.c (1.63): Check return value of pool_flush(). 2007-10-23 16:32 y-asaba * sql/pgpool-recovery/pgpool-recovery.c (1.2): Change error message. 2007-10-23 13:44 y-asaba * Makefile.am (1.13), doc/pgpool-ja.html (1.20), sample/pgpool_recovery_pitr (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1): Add online recovery script using pitr. 2007-10-22 17:59 y-asaba * test/jdbc/.cvsignore (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1): Add .cvsignore file. 2007-10-22 17:55 y-asaba * Makefile.am (1.12): Add test/jdbc/* into tar ball. 2007-10-22 17:47 y-asaba * test/jdbc/: AutoCommitTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), BatchTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), ColumnTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), LockTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), PgpoolTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), RunTest.java (1.1), SelectTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), UpdateTest.java (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), pgpool.properties (1.1), prepare.sql (1.1), run.sh (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), expected/autocommit (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), expected/batch (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), expected/column (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), expected/lock (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), expected/select (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), expected/update (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0) (utags: V2_0_0_BETA1): Add test program using Java+JDBC driver. 2007-10-22 13:23 y-asaba * NEWS (1.11), doc/pgpool-ja.html (1.19): Merge from V1_STABLE branch. 2007-10-18 18:55 y-asaba * pool_query_cache.c (1.8, V2_0_1, V2_0_0, V2_0_0_BETA1): Although the second argument of PQunescapeBytea() requires size_t which size is 8 byte in 64bit machine, pgpool passed 4 byte variable. It caused segfault. So fixed passing size_t variable. 2007-10-18 18:52 y-mori * test/pdo-test/: collections.inc (1.1), def.inc (1.1), log.txt (1.1), pdotest.php (1.1), regsql.inc (1.1), SQLlist/test1.sql (1.1), SQLlist/test2.sql (1.1), mod/database.inc (1.1), mod/def.inc (1.1), mod/errorhandler.inc (1.1) (utags: V2_0_0, V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4): ADD: extend protocol test tool 2007-10-18 17:24 y-asaba * sample/pgpool_recovery (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1): execute rsync as background jobs. 2007-10-18 13:48 y-asaba * sample/pgpool_recovery (1.2): * Add --update option. * Sync pg_twophase directory. 2007-10-18 11:54 y-asaba * pool_process_query.c (1.62): Fix compile warning on Solaris. 2007-10-18 10:21 y-asaba * pool_config.c (1.16), pool_config.l (1.12): Set failback_command default value to empty string; 2007-10-17 19:23 y-asaba * main.c (1.19, V2_0_0_BETA1): Fix segfault when failover_command is empty. 2007-10-17 15:31 y-mori * pool_rewrite_outfuncs.c (1.6): FIX: lost alias name of column in query rewriting when it was used at GRUP BY CLAUSE..etc 2007-10-17 12:00 y-mori * pool.h (1.21), pool_process_query.c (1.61), pool_rewrite_outfuncs.c (1.5): Fix: compiler's warning 2007-10-16 12:44 y-asaba * pool_process_query.c (1.60): Fix hang up in load balancing mode. 2007-10-15 22:56 y-mori * pool_rewrite_outfuncs.c (1.4): fix Type Casting of Constant value was not supported 2007-10-15 21:56 y-mori * pool_process_query.c (1.59): FIX wrong file descriptor was used at pool_prallel_exec 2007-10-15 19:38 y-mori * pool_process_query.c (1.58), pool_rewrite_query.c (1.6, V2_0_1, V2_0_0, V2_0_0_BETA1): FIX insert rule in parallel mode 2007-10-15 19:20 y-asaba * test/parser/: expected/create.out (1.2), expected/select.out (1.2), input/select.sql (1.3) (utags: V2_0_0, V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4): Add test cases. 2007-10-15 19:18 y-asaba * parser/outfuncs.c (1.4): Support interval operator. 2007-10-15 18:51 y-asaba * parser/: gram.y (1.4), scan.l (1.4) (utags: V2_0_0, V2_0_0_BETA1, V2_0_1): Fix core dump with the following SQL. SELECT * FROM tbl LIMIT 1,0; 2007-10-15 16:05 y-asaba * pool_process_query.c (1.57): Fix invalid memory access when pgpool processed DEALLOCATE statement. 2007-10-15 15:56 y-mori * pool_config.c (1.15), pool_process_query.c (1.56), pool_rewrite_outfuncs.c (1.3), pool_rewrite_query.c (1.5), pool_rewrite_query.h (1.3), pool_system.c (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_type.h (1.7, V2_0_1, V2_0_0, V2_0_0_BETA1): ADD query rewriting to main trunc 2007-10-15 15:11 y-asaba * parser/pool_memory.c (1.8, V2_0_1, V2_0_0, V2_0_0_BETA1): Fix core dump with a large SQL. 2007-10-12 21:27 t-ishii * pgpool.conf.sample (1.12), pool.h (1.20), pool_config.c (1.14), pool_process_query.c (1.55), parser/scan.c (1.6): Add pool_status entry for child_idle_limit Fix comments 2007-10-12 18:15 y-asaba * pgpool.conf.sample (1.11): Add new directive "authentication_timeout" into pgpool.conf.sample. 2007-10-12 15:56 y-asaba * doc/pgpool-ja.html (1.18): Add authentication_timeout. 2007-10-12 14:55 y-asaba * main.c (1.18): Fix compiler warning. 2007-10-12 14:30 y-asaba * parser/: parser.c (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_parser.h (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1), scan.l (1.3): Fix scanner's error handling. If there was a unterminated double-quote identifier, scanner entered infinite-loop. 2007-10-12 13:51 y-asaba * child.c (1.16, V2_0_1, V2_0_0, V2_0_0_BETA1), pool.h (1.19), pool_config.c (1.13), pool_config.l (1.11), pool_process_query.c (1.54): Add new directive "authentication_timeout". The directive means the maximum time in seconds to complete client authentication. The default value is 60. 2007-10-12 13:50 y-asaba * TODO (1.9, V2_0_1, V2_0_0, V2_0_0_BETA1): Remove some items. 2007-10-12 13:39 y-asaba * test/parser/input/select.sql (1.2): Add test cases. 2007-10-12 13:38 y-asaba * parser/outfuncs.c (1.3): Support for XmlExprt object. 2007-10-12 13:35 y-asaba * pcp_child.c (1.7, V2_0_1, V2_0_0, V2_0_0_BETA1): recovery request can be accepted only in replication mode. 2007-10-12 13:34 t-ishii * Makefile.am (1.11), Makefile.in (1.15), pgpool.conf.sample (1.10), pool.h (1.18), pool_config.c (1.12), pool_config.l (1.10), pool_process_query.c (1.53), parser/Makefile.am (1.3, V2_0_0_BETA1), parser/Makefile.in (1.10), parser/gram.c (1.6), parser/gram.h (1.6, V2_0_0_BETA1): Add child_idle_limit. # If child_idle_limit is n (n > 0), the child is forced to be # disconnected after n seconds idle between transactions. # 0 means no disconnect. Need to work on show pool_status and docs. 2007-10-11 17:32 y-asaba * child.c (1.15), pool.h (1.17): Check startup packet length. If the length is greater than 10,000 byte, pgpool reject the connection. 2007-10-11 10:49 y-asaba * TODO (1.8): Add graceful {shutodwn, attach, detach} into TODO list. * TODO for TODO list translate Japanse into English. 2007-10-04 13:17 y-asaba * doc/: pgpool-ja.html (1.17), pgpool.css (1.2): Update Japanse manual. - Add release note for pgpool-II 2.0 - Add failover_command and failback_command description 2007-10-04 12:00 y-asaba * doc/pgpool-en.html (1.12): Merge V1_STABLE branch. 2007-10-04 11:36 y-asaba * version.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Change PGPOOLVERSION to "hikitsuboshi". 2007-10-03 15:19 y-asaba * TODO (1.7): Remove TODO items. 2007-10-03 14:21 y-asaba * pool_process_query.c (1.52): Reset a prepared statement list when DISCARD ALL or DISCARD PLANS statement is completed. 2007-10-03 13:52 y-asaba * test/parser/: README (1.2), run-test (1.2) (utags: V2_0_0, V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4): Translate from Japanese into English. 2007-10-03 13:47 y-asaba * Makefile.am (1.10), Makefile.in (1.14), test/parser/.cvsignore (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/Makefile (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/README (1.1), test/parser/main.c (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/parse_schedule (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/pool.h (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/run-test (1.1), test/parser/expected/copy.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/create.out (1.1), test/parser/expected/cursor.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/delete.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/drop.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/insert.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/misc.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/prepare.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/privileges.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/select.out (1.1), test/parser/expected/transaction.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/update.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/var.out (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/alter.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/copy.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/create.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/cursor.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/delete.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/drop.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/insert.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/misc.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/prepare.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/privileges.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/select.sql (1.1), test/parser/input/transaction.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/update.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/var.sql (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1): Add SQL parser test. 2007-10-03 13:25 y-asaba * Makefile.in (1.13), aclocal.m4 (1.10), config.sub (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), configure (1.14), ltmain.sh (1.3, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_hba.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_process_query.c (1.51), pool_rewrite_outfuncs.c (1.2), pool_rewrite_query.c (1.4), parser/Makefile.in (1.9), parser/copyfuncs.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/gram.c (1.5), parser/gram.h (1.5), parser/gram.y (1.3), parser/gramparse.h (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/keywords.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/keywords.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/list.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/makefuncs.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/makefuncs.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/nodes.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/outfuncs.c (1.2), parser/parsenodes.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/parser.c (1.3), parser/parser.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/pg_list.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/pool_parser.h (1.3), parser/primnodes.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/scan.c (1.5), parser/scan.l (1.2), parser/value.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/value.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), pcp/Makefile.in (1.9): Import PostgreSQL 8.3 SQL parser. The revision of gram.y is 2.603. 2007-10-03 13:17 y-asaba * pgpool.conf.sample (1.9), pool_config.c (1.11), pool_config.l (1.9): The default value of ignore_leading_white_space is true in pgpool-II 2.x. 2007-09-27 18:38 gleu * pool_process_query.c (1.50): Typo fix. 2007-09-27 11:48 y-asaba * TODO (1.6): Remove TODO item. 2007-09-27 11:46 y-asaba * pool_process_query.c (1.49): Call read_kind_from_backend() function instead of pool_read_kind() in Execute(), Parse() and SimpleForwardToFrontend(). 2007-09-26 18:09 y-asaba * pool_process_query.c (1.48): Remove debug message. 2007-09-26 17:56 y-asaba * pool_process_query.c (1.47): SET, PREPARE and DEALLOCATE statements are replicated in master/slave mode. 2007-09-26 14:29 y-asaba * main.c (1.17), pool.h (1.16), pool_process_query.c (1.46), pool_stream.c (1.5, V2_0_0_BETA1): pgpool-II could not detach multiple node when message kinds were mismatched. For example: node-1(master): success node-2: fail node-3: success node-4: fail node-5: success node-2 was only detached. Now it determine detached nodes by "majority voting rule". And it can detach them at the same time. For example: node-1(master): success node-2: fail node-3: success node-4: fail node-5: success node-2 and node-4 are detached because they are minority. node-1(master): success node-2: fail node-3: fail node-4: success The number of the group which gain "success" is same as the number of the group which gain "fail". In this case, node-2 and node-3 are detached because these don't belong to the group which master belongs to. 2007-09-26 12:32 y-asaba * pool_sema.c (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Fix initializing semaphore values. 2007-09-16 11:08 y-asaba * pgpool.conf.sample (1.8): Add comments abount failover_command and failback_command. 2007-09-14 22:36 y-asaba * main.c (1.16), pgpool.conf.sample (1.7), pool.h (1.15), pool_config.c (1.10), pool_config.l (1.8), pool_process_query.c (1.45), parser/gram.c (1.4), parser/gram.h (1.4), parser/gram.y (1.2), parser/pool_string.c (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/pool_string.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Add "failover_command" and "failback_command" directives. If failover or failback occur, pgpool execute setting command by system(3). These directives evaluate special characters with the following rule. %d: node id %h: backend's hostname %p: backend's port number %D: backend's data directory example) pgpool.conf: --- failover_command = 'echo %h %p %D %d > /tmp/failover' failback_command = 'echo %h %p %D %d > /tmp/failback' backend_hostname1 = 'localhost' backend_port1 = 5433 backend_weight1 = 1 backend_data_directory1 = '/home/postgres/pgdata/data5433' --- When node 1 is down, pgpool execute the following failover command. failover localhost 5433 /home/postgres/pgdata/data5433 1 /tmp/failover is created. % cat /tmp/failover failover localhost 5433 /home/postgres/pgdata/data5433 1 2007-09-14 20:11 y-asaba * child.c (1.14), pool.h (1.14), pool_process_query.c (1.44): Fix hang up when load balancing node was down. 2007-09-10 22:29 t-ishii * pool_process_query.c (1.43): Modfify pool_send_error_message() so that it won't be blocked by sending packet to the closing frontend connection. Also rename set_non_block() and unset_non_block() to pool_sen_non_block() and pool_unset_non_block() respectively to make them public functions. 2007-09-10 22:25 t-ishii * child.c (1.13), pool.h (1.13): Modfify pool_send_error_message() so that it won't be blocked by sending packet to the closing frontend connection. Also rename set_non_block() and unset_non_block() to pool_sen_non_block() and pool_unset_non_block() respectively to make them public functions. 2007-09-10 21:47 t-ishii * child.c (1.12): Fix misspell in a comment 2007-09-07 18:08 y-asaba * pool_process_query.c (1.42), parser/parser.c (1.2), parser/pool_memory.c (1.7), parser/pool_memory.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Improve performance. - Reuse parser memory space in free_parser(). - Check node type before comparing with "show pool_status()". 2007-09-06 10:43 y-asaba * doc/pgpool-en.html (1.11): Fix restricted query section. 2007-08-29 15:49 y-asaba * pool_query_cache.c (1.7), pcp/pcp.c (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1), pcp/pcp_stream.c (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Fix compile error on FreeBSD 4.11. 2007-08-29 15:48 y-asaba * recovery.c (1.2): Fix compile error. 2007-08-29 15:01 y-asaba * pool_process_query.c (1.41): Read response messages in Parse() until receiving ParseComplete or ErrorResponse message. 2007-08-28 19:07 y-asaba * pool_process_query.c (1.40): Add checking deadlock error message in Parse(). 2007-08-28 11:28 y-asaba * pool_process_query.c (1.39): * Fix handling Parse message. Parse message including INSERT/UPDATE/DELETE query acquires RowExclusiveLock. However pgpool did not wait a response from each node. It was possible to occur deadlock problem. * Fix memory leak in reset_prepared_list() 2007-08-17 10:50 t-ishii * TODO (1.5), doc/pgpool-ja.html (1.16): Enhance documentation. 2007-08-13 11:23 y-asaba * pgpool.conf.sample (1.6), pool.h (1.12), pool_config.l (1.7), pool_process_query.c (1.38): Add new parameter named "replicate_select". Default value is 'false'. If it is true, pgpool replicates SELECT queries when load balancing is disabled. This is a old specification which was V1.0. If it is false, pgpool only sends them to the master node. This is a current specification. 2007-08-06 10:42 y-asaba * pool_process_query.c (1.37): Fix memory leak. 2007-08-01 13:27 y-asaba * child.c (1.11): Remove compiler warning. 2007-07-27 10:19 y-asaba * doc/pgpool-ja.html (1.15): Merge from V1_STABLE branch 2007-07-26 19:15 y-asaba * child.c (1.10), pool.h (1.11), pool_connection_pool.c (1.9, V2_0_1, V2_0_0, V2_0_0_BETA1): SIGALRM handler didn't safe. Because it called non-reentrant functions. We only set a flag in SIGALRM handler. Then we close expired connections in safe places. 2007-07-26 14:15 y-asaba * pool_connection_pool.c (1.8): Fix memory leak when connection slot is full. 2007-07-26 11:28 t-ishii * aclocal.m4 (1.9), configure (1.13), pool_config.c (1.9): Run autoconf 2007-07-26 11:21 y-asaba * pool_config.l (1.6): Fix using uninitialized value. 2007-07-25 21:31 y-asaba * pool_process_query.c (1.36): Fix hang up and SEGV if Parse message contains a warning statement. SELECT '\''; WARNING: nonstandard use of \' in a string literal If pgpool receives a warning message that is NoticeMessage('N') under the extended query protocol, it reads a next message. 2007-07-24 18:02 y-asaba * pool.h (1.10), pool_process_query.c (1.35): Detect deadlock in do_command(). When insert_lock was true, kind mismatch error occured. 2007-07-23 14:32 y-asaba * pool_process_query.c (1.34): Fixed that start_internal_transaction() was only called under replication mode or parallel mode. 2007-07-23 14:24 y-asaba * main.c (1.15): Remove debug code. 2007-07-23 13:37 y-asaba * child.c (1.9), main.c (1.14), pool.h (1.9), pool_config.c (1.8), pool_config.l (1.5), pool_process_query.c (1.33), pool_type.h (1.6): Add reloading config files. pgpool can reload pgpool.conf, pool_hba.conf and distributed rules from system DB. If reload, you type the following command. % pgpool reload Or you send SIGHUP signal to the pgpool parent process. 2007-07-17 15:04 y-asaba * pool_process_query.c (1.32): Fix hang up when backend node did fast or immediate shutdown. If shutdown occured, postgres send an error which error code is "57P01" and error message is "terminating connection due to administrator command". However, another nodes did not send any messages. pgpool waited for a message from them. when the error is sended, pgpool reads the message and degenerate. 2007-07-17 11:33 y-asaba * pool_process_query.c (1.31, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Rearrange detect_deadlock_error(). 2007-07-10 18:56 y-asaba * main.c (1.13, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h (1.8, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_process_query.c (1.30), pool_stream.c (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE): * Change type of InRecovery variable to sig_atomic_t* * Fixed kind mismatch error when deadlock error occured. The problem is the following senario. A: BEGIN: B: BEGIN; A: LOCK TABLE t1 IN SHARE ROW EXCLUSIVE MODE; B: LOCK TABLE t2 IN SHARE ROW EXCLUSIVE MODE; A: LOCK TABLE t2 IN SHARE ROW EXCLUSIVE MODE; B: LOCK TABLE t1 IN SHARE ROW EXCLUSIVE MODE; Transaction "A" aborts on master node, but it completes on another nodes. It causes wrong failover. So pgpool checks deadlock error(code == '40P01') and sends error query to another nodes. 2007-07-09 14:18 y-asaba * main.c (1.12): Add comments. 2007-07-09 13:23 y-asaba * main.c (1.11): Fix race condition between flag checking and signal blocking. Normally, this case solve to call pselect(2). But Linux's pselect(2) is emulated by select(2) and sigprocmask(2). It contains this race. So pgpool archieves using the self-pipe trick. See 'man pselect' if you want to get more information. 2007-07-09 10:29 y-asaba * config.guess (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), config.h.in (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), configure (1.12, ROOT_OF_V2_0_PARALLEL_UNSTABLE), configure.in (1.11, ROOT_OF_V2_0_PARALLEL_UNSTABLE), ltmain.sh (1.2, ROOT_OF_V2_0_PARALLEL_UNSTABLE), aclocal.m4 (1.8, ROOT_OF_V2_0_PARALLEL_UNSTABLE), child.c (1.8, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp_child.c (1.6, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_connection_pool.c (1.7, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_process_query.c (1.29), pool_query_cache.c (1.6, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_stream.c (1.3): configure checks that OS has sys/select.h. If it exists, include it. 2007-07-06 17:32 y-asaba * child.c (1.7), pool_process_query.c (1.28), pool_type.h (1.5, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Load balancing node was chosen before sending "SELECT" statement. But this way had the following problems. psql>\d accounts Did not find any relation with OID XXX pgpool chooses it after receiving AuthenticationOK('R') message. So pgpool load balance to the same node inside a same session. 2007-07-05 18:12 y-asaba * main.c (1.10): Improve signal handling. We fixed signal handling at revision 1.6. That fix was to set a flag in signal handler, then pgpool checked flags in safe points. However It has a race condition in the following case. CHECK_REQUEST; <-- check flags <-- set flags pause(); <-- wait for signals So, we modified to deliver signals in safe places which are in pause() and sleep(). 2007-07-05 11:14 y-asaba * pool_process_query.c (1.27): * Remove debug code. * Refactor ReadyForQuery() and do_command(). 2007-07-04 17:18 y-asaba * pool_process_query.c (1.26): In replication mode, pgpool checks the numbers of insert/update/delete tuples in CommandComplete message. If these numbers are not same, a transaction is aborted by pgpool. It is for data consistency. TODO: This behavior will be able to switch by pgpool.conf. 2007-07-03 18:23 y-asaba * TODO (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Rearrange TODO list. 2007-06-29 23:15 y-asaba * main.c (1.9): Fix race condition between unsetting SIGCHLD flag and unblocking SIGCHLD signal. 2007-06-28 21:35 y-asaba * main.c (1.8): Fix SIGUSR2 handling. The signal handler only set flag. Then, pgpool call SIGUSR2 handler in CHECK_REQUEST macro. 2007-06-27 18:29 y-asaba * ChangeLog (1.18, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h (1.7), pool_process_query.c (1.25): Fix hang up when a SELECT query has error inside transaction block. It occurs only in simple query protocol. 2007-06-27 18:04 y-asaba * sample/pgpool_remote_start (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Fix checking the number of arguments. 2007-06-26 10:35 y-asaba * pcp_child.c (1.5): Remove unused variable. 2007-06-22 19:10 t-ishii * Makefile.in (1.12, ROOT_OF_V2_0_PARALLEL_UNSTABLE), aclocal.m4 (1.7), configure (1.11), parser/Makefile.in (1.8, ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/scan.c (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/Makefile.in (1.8, ROOT_OF_V2_0_PARALLEL_UNSTABLE): run autoconf and flex 2007-06-22 18:50 y-asaba * Makefile.am (1.9, ROOT_OF_V2_0_PARALLEL_UNSTABLE), Makefile.in (1.11), aclocal.m4 (1.6), child.c (1.6), configure (1.10), configure.in (1.10), main.c (1.7), pcp_child.c (1.4), pgpool.conf.sample (1.5, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h (1.6), pool_config.c (1.7, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_config.l (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_process_query.c (1.24), pool_type.h (1.4), recovery.c (1.1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), doc/pgpool-ja.html (1.14, ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/Makefile.in (1.7), pcp/Makefile.am (1.2, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/Makefile.in (1.7), pcp/pcp.c (1.3, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/pcp.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/pcp_recovery_node.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), sample/pgpool_recovery (1.1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), sample/pgpool_remote_start (1.1), sql/pgpool-recovery/Makefile (1.1, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), sql/pgpool-recovery/pgpool-recovery.c (1.1), sql/pgpool-recovery/pgpool-recovery.sql.in (1.1): Add new features in pgpool-II 2.0. * support online-recovery in replication mode. - based on physical data copy * improve replication mode. - employ "primary copy method" to enhance the performance - more stable replication 2007-06-21 10:17 y-asaba * ChangeLog (1.17): update ChangeLog. 2007-06-20 18:09 y-asaba * main.c (1.6): Fix SIGCHLD and SIGUSR1 signal handling. Signal handlers set flags only, then a parent process checks flags in signal safe places. 2007-06-20 17:14 t-ishii * pool_config.c (1.6), parser/gram.c (1.3, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/gram.h (1.3, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/scan.c (1.3, V1_2_1, V1_2): run flex 2007-06-18 11:40 y-asaba * pool_process_query.c (1.23): Fix memory leak in NotificationResponse(). 2007-06-18 11:37 y-asaba * ChangeLog (1.16): update ChangeLog. 2007-06-18 11:34 y-asaba * pool_process_query.c (1.22): * Fix compile warning. * Fix memory leak in CursorResponse(). 2007-06-18 10:33 t-ishii * Makefile.in (1.10, V1_2_1, V1_2): run autoconf 2007-06-15 22:35 devrim * pgpool.spec (1.7, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Update spec file 2007-06-15 12:21 y-asaba * NEWS (1.10, ROOT_OF_V2_0_PARALLEL_UNSTABLE), doc/pgpool-ja.html (1.13) (utags: V1_1_1): Update release note. 2007-06-15 11:57 t-ishii * configure (1.9, V1_1_1): Run autoconf. 2007-06-15 11:55 t-ishii * doc/pgpool-ja.html (1.12): Fix typo. 2007-06-14 16:44 y-asaba * ChangeLog (1.15, V1_1_1): Prepare for 1.1.1 2007-06-12 10:49 y-asaba * NEWS (1.9): Prepare for 1.1.1 2007-06-11 15:37 y-asaba * configure.in (1.9, V1_1_1), doc/pgpool-ja.html (1.11): Prepare for 1.1.1 2007-06-11 12:06 y-asaba * ChangeLog (1.14): Update ChangeLog. 2007-06-11 12:01 y-asaba * pool_process_query.c (1.21, V1_1_1): Fix kind mismatch error when load_balance_mode is true. 2007-06-07 11:38 y-asaba * pool_process_query.c (1.20): Fix handling nullmap (V2 only). 2007-06-06 17:32 yamaguti * doc/: pgpool-en.html (1.10, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1), pgpool-ja.html (1.10): added an explanation about command line option "-a" for HBA file. 2007-06-02 09:54 y-asaba * pool_process_query.c (1.19): Fix typo EmptyQueryResponse message. pgpool hung up in EXECUTE command. (Patch contributed by Kenichi Sawada) 2007-05-29 10:58 y-asaba * pool_process_query.c (1.18): Fix handling protocol version 2. 2007-05-28 18:13 y-asaba * pool_process_query.c (1.17): Fix handling protocol version 2. 2007-05-25 12:02 y-asaba * Makefile.am (1.8, V1_2_1, V1_2), Makefile.in (1.9) (utags: V1_1, V1_1_1): Fix typo 2007-05-25 11:45 y-asaba * ChangeLog (1.13, V1_1): Prepare for 1.1 2007-05-25 11:37 y-asaba * doc/: pgpool-en.html (1.9), pgpool-ja.html (1.9) (utags: V1_1): Add handling "SELECT nextval". 2007-05-25 11:30 y-asaba * doc/pgpool-ja.html (1.8): Add Japanese release note for 1.1 2007-05-24 23:27 t-ishii * Makefile.in (1.8), aclocal.m4 (1.5, V1_3, V1_2_1, V1_2, V1_1_1, V1_1), configure (1.8, V1_1), parser/Makefile.in (1.6, V1_3, V1_2_1, V1_2, V1_1_1, V1_1), pcp/Makefile.in (1.6, V1_3, V1_2_1, V1_2, V1_1_1, V1_1): Resync files generated by configure.in 2007-05-24 23:25 t-ishii * TODO (1.3, V1_3, V1_2_1, V1_2, V1_1_1, V1_1): update TODO(Japanese) 2007-05-24 15:42 y-asaba * NEWS (1.8, V1_1): update NEWS 2007-05-24 15:38 y-asaba * parser/pool_memory.c (1.6, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1), ChangeLog (1.12): Fix core dump in pool_memory_realloc(). 2007-05-23 11:01 yamaguti * ChangeLog (1.11), NEWS (1.7): fixed pgpool.pam so it is installed under $PREFIX/share/pgpool-II/ 2007-05-23 10:59 yamaguti * ac_func_accept_argtypes.m4 (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_hba.c (1.1), pool_hba.conf.sample (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_ip.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_ip.h (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_path.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_path.h (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), ps_status.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), strlcpy.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1) (utags: ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1, V1_1_1, V1_2, V1_2_1, V1_3): new files for HBA, ps display, log_hostname & log_connections 2007-05-22 15:28 y-asaba * pool_process_query.c (1.16, V1_1): Add checking a message length is valid. (Reported by Fujii Masao) 2007-05-21 14:49 y-asaba * NEWS (1.6), configure.in (1.8, V1_1), version.h (1.2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): Prepare for 1.1 2007-05-21 11:16 yamaguti * Makefile.am (1.7), Makefile.in (1.7): pgpool.pam and system_db.sql is now installed under share/pgpool-II/ 2007-05-17 15:46 yamaguti * ChangeLog (1.10), Makefile.am (1.6), Makefile.in (1.6), aclocal.m4 (1.4), child.c (1.5, V1_1_1, V1_1), config.h.in (1.3, V1_1_1, V1_1), configure (1.7), configure.in (1.7), main.c (1.5, V1_1_1, V1_1), pcp_child.c (1.3, V1_3, V1_2_1, V1_2, V1_1_1, V1_1), pgpool.conf.sample (1.4, V1_1_1, V1_1), pool.h (1.5, V1_1_1, V1_1), pool_config.c (1.5, V1_1_1, V1_1), pool_config.l (1.3, V1_1_1, V1_1), pool_process_query.c (1.15), pool_query_cache.c (1.5, V1_2, V1_1_1, V1_1), pool_type.h (1.3, V1_1_1, V1_1), doc/pgpool-en.html (1.8), doc/pgpool-ja.html (1.7), parser/Makefile.in (1.5), parser/gram.c (1.2, V1_1_1, V1_1), parser/gram.h (1.2, V1_1_1, V1_1), parser/pool_parser.h (1.2, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1), pcp/Makefile.in (1.5), sample/pgpool.pam (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): * Support HBA authentication. * Support log_connections * Support log_hostname * Support "ps" status display * Fixed compiler warning in pool_query_cache.c * sample/pgpool.pam: PAM service configuration file. It will be installed to "$PREFIX/share/" * doc/pgpool-ja.html: Added pool_hba description. * doc/pgpool-en.html: Added pool_hba description. * Updated ChangeLog 2007-04-26 14:26 y-asaba * ChangeLog (1.9), pool_connection_pool.c (1.6, V1_1_1, V1_1): Retry connect() when it is interrupted by signal. 2007-04-20 16:18 y-asaba * ChangeLog (1.8): Add entry. 2007-04-20 15:41 y-asaba * pool_process_query.c (1.14): Enhance that the query that begins with "SELECT nextval()" or "SELECT setval()" are always replicated under replication mode. Then, SELECT statements are only executed by MASTER node if load_balance_mode is false. If need to replicate select statement, add a comment in the begining of the query. Example: SELECT foo() -> /*REPLICATION*/ SELECT foo() 2007-04-15 20:26 t-ishii * pool_process_query.c (1.13): Fix read_kind_from_backend(). It calls notice_backend_error() with fixed db node number 1. Make it the db node which returns different packet kind from master. 2007-04-12 17:30 devrim * pool_process_query.c (1.12): Patch to surpress compiler warnings, per Ralf Corsepius 2007-03-01 13:06 y-asaba * ChangeLog (1.7), pool_process_query.c (1.11): Support load balancing with extended protocol. (Parallel query isn't supported extended protocol yet.) 2007-03-01 12:03 y-asaba * ChangeLog (1.6), parser/Makefile.am (1.2, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1), parser/copyfuncs.c (1.1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): Porting deep copy functions for tree nodes from PostgreSQL. 2007-02-28 20:04 y-asaba * ChangeLog (1.5): Add ChangeLog entry. 2007-02-28 19:44 y-asaba * Makefile.am (1.5): Fix link error on Solaris. Solaris's ld does not have --rpath option. So it uses libtool's -rpath option instead of ld's option. 2007-02-21 04:38 devrim * pgpool.spec (1.6, V1_1_1, V1_1): Fixes from Jarod Wilson - Create proper devel package, drop -libs package - Nuke rpath - Don't install libtool archive and static lib - Clean up %%configure line - Use proper %%_smp_mflags - Install config files properly, without .sample on the end - Preserve timestamps on header files 2007-02-20 18:20 devrim * pgpool.spec (1.5): - Update to 1.0.2-1 - Fix various build problems and prepared for Fedora Submission ---------------------------------------------------------------------- 2007-02-20 15:02 devrim * pgpool.conf.sample (1.3): Update header so that we can see that it is pgpool-II conf file (I was confused after removing pgpool and installing pgpool-II :) ) 2007-02-16 22:56 t-ishii * Makefile.in (1.5), configure (1.6), parser/Makefile.in (1.4), pcp/Makefile.in (1.4): automake & autoconf 2007-02-16 20:31 y-asaba * ChangeLog (1.4), Makefile.am (1.4), configure.in (1.6), pool_connection_pool.c (1.5), pool_query_cache.c (1.4), pcp/pcp.c (1.2, V1_2, V1_1_1, V1_1), pcp/pcp_stream.c (1.2, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): Fixed compile error on MacOS X. MacOS's ld does not have rpath option. So add --disable-rpath option to configure for MacOS X. 2007-02-13 12:44 y-asaba * ChangeLog (1.3, V1_0_2): * Add entries using cvs2cl. 2007-02-12 16:23 y-asaba * doc/pgpool-ja.html (1.6, V1_0_2): Add release note. 2007-02-12 15:51 y-asaba * doc/pgpool-ja.html (1.5): Add Japanese release note into pgpool-ja.html. 2007-02-12 11:32 y-asaba * child.c (1.4), pool.h (1.4), pool_connection_pool.c (1.4) (utags: V1_0_2): pgpool *only* checks backend connection when connection pool is reused. 2007-02-09 12:54 y-asaba * NEWS (1.5, V1_0_2): fix indent. 2007-02-09 12:50 y-asaba * NEWS (1.4): Remove '\000'. 2007-02-08 22:08 t-ishii * doc/pgpool-en.html (1.7, V1_0_2): prepare for 1.0.2 2007-02-08 21:52 t-ishii * NEWS (1.3), config.h.in (1.2, V1_0_2), configure (1.5, V1_0_2): Prepare for 1.0.2 2007-02-08 17:56 y-asaba * doc/pgpool-ja.html (1.4): Add new loadbalancing rule in replication mode section. 2007-02-08 17:34 y-asaba * pool_query_cache.c (1.3), configure.in (1.5), pool_system.c (1.3, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1) (utags: V1_0_2): Fixed configure error if libpq version is 7.4.x. 7.4 does not have PQprepare(). So when version is 7.4, pgpool uses PREPARE statement instead of PQprepare(). 2007-02-08 00:44 y-asaba * configure.in (1.4): Prepare for 1.0.2 2007-02-07 19:08 t-ishii * Makefile.in (1.4, V1_0_2), aclocal.m4 (1.3, V1_0_2), configure (1.4), configure.in (1.3), pool_config.c (1.4, V1_0_2), parser/Makefile.in (1.3, V1_0_2), pcp/Makefile.in (1.3, V1_0_2): update configure.in to use pg_config. Patch made by Yoshiyuki Asaba. 2007-02-06 11:46 y-asaba * pool_connection_pool.c (1.3): Add checking socket state when connection pool is reused. If socket is closed, pgpool try to create new connection pool. 2007-01-30 11:25 y-asaba * pool_process_query.c (1.10, V1_0_2): Disable to load balance in the following cases. - SELECT FOR UPDATE - SELECT INTO - /* xxx */ SELECT ... (This is pgpool-I spec.) 2007-01-13 23:56 yamaguti * pool_signal.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2): fixed #ifndef ~ #define macro for that it could have been included redundantly. 2007-01-10 04:02 y-asaba * pool_process_query.c (1.9): Fix auto-deallocation. If a client used PDO interface, pgpool didn't clean prepared statement. 2007-01-05 02:27 devrim * COPYING (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), child.c (1.3), main.c (1.4, V1_0_2), pcp_child.c (1.2, V1_0_2), pgpool.8.in (1.2, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool.h (1.3), pool_auth.c (1.3, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_config.c (1.3), pool_config.l (1.2, V1_0_2), pool_connection_pool.c (1.2), pool_error.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_ipc.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_params.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_process_query.c (1.8), pool_query_cache.c (1.2), pool_rewrite_query.c (1.3, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_rewrite_query.h (1.2, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_sema.c (1.2, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_shmem.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_signal.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool_signal.h (1.2), pool_stream.c (1.2, V1_1_1, V1_1, V1_0_2), pool_system.c (1.2), pool_type.h (1.2, V1_0_2), parser/pool_memory.c (1.5, V1_0_2), parser/pool_memory.h (1.2, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), parser/pool_string.c (1.2, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), parser/pool_string.h (1.2, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2): Copyright update 2006-12-25 19:14 y-asaba * Makefile.am (1.3, V1_0_2), Makefile.in (1.3): Fix libpq link error (Reported by ISHIDA Akio). 2006-12-04 14:49 t-ishii * pool_process_query.c (1.7): Fix bug with replication mode. With UPDATE/DELETE, the number of affcted rows should not be sum of each node. 2006-12-02 22:41 t-ishii * pool_process_query.c (1.6): Add backend status info to show pool_status 2006-12-02 22:40 t-ishii * main.c (1.3): enhance logging to make it clear what kind of failover/failback event ocuured. 2006-12-02 22:38 t-ishii * TODO (1.2, V1_0_2): update TODO document to reflect current status 2006-11-30 07:33 devrim * child.c (1.2), pool_auth.c (1.2): Fix small typos in messages 2006-11-30 06:54 devrim * pgpool.conf.sample (1.2, V1_0_2): Fix small typos in config file 2006-11-15 18:30 y-asaba * pool_process_query.c (1.5): Fix an extended query protocol handling. 2006-11-13 14:02 y-asaba * parser/pool_memory.c (1.4): Fix SIGSEGV under parallel mode. 2006-11-10 12:48 y-asaba * parser/pool_memory.c (1.3): * Add NULL checking in pool_memory_free(). * Fix SIGSEGV in pool_memory_alloc() if allocate size is 8192 byte. void *x; pool_memory = pool_memory_create(); x = pool_memory_alloc(pool_memory, 8192); 2006-11-04 16:38 y-asaba * parser/pool_memory.c (1.2): Fixed a inifinite loop in pool_memory_free(). 2006-10-04 14:57 y-asaba * pool_rewrite_query.c (1.2): Fix rewriting a query which refers pg_catalog. Patch contributed by Yoshiharu Mori. 2006-10-04 04:31 devrim * pgpool.spec (1.4, V1_0_2): - Added -libs and -devel RPM - Fix .so link problem - Cosmetic changes to spec file 2006-10-04 04:29 devrim * pgpool.spec (1.3): [no log message] 2006-09-27 14:45 devrim * pgpool.spec (1.2): * Thu Sep 27 2006 - Devrim GUNDUZ 1.0.1-3 - Fix spec, per Yoshiyuki Asaba * Thu Sep 26 2006 - Devrim GUNDUZ 1.0.1-2 - Fixed rpmlint errors - Fixed download url - Added ldconfig for .so files ** Thu Sep 21 2006 - David Fetter 1.0.1-1 - Initial build pgpool-II 1.0.1 for PgPool Global Development Group 2006-09-27 11:14 y-asaba * pool_process_query.c (1.4): Fix load balancing algorithm. Patch contributed by Jeff Davis. See the following URL for more details. http://pgfoundry.org/pipermail/pgpool-hackers/2006-September/000034.html 2006-09-25 12:03 y-asaba * doc/: pgpool-en.html (1.6), pgpool-ja.html (1.3): Add pam authentication in supported authentication protocol list. Reported by Jeff Davis. 2006-09-22 15:04 t-ishii * Makefile.am (1.2), Makefile.in (1.2), aclocal.m4 (1.2), configure (1.3), pool_config.c (1.2), parser/Makefile.in (1.2), parser/scan.c (1.2, V1_1_1, V1_1, V1_0_2), pcp/Makefile.in (1.2) (utags: V1_0_1): Update Makefile.am to reflect the fact that some doc names have been changed. 2006-09-22 14:39 t-ishii * ChangeLog (1.2, V1_0_1), NEWS (1.2, V1_0_1), configure (1.2), configure.in (1.2, V1_0_1): Version 1.0.1 2006-09-15 15:06 y-asaba * doc/pgpool-ja.html (1.2, V1_0_1): A restriction of extended protocol is *only* in parallel mode. Fixed the description. 2006-09-14 11:04 t-ishii * pool.h (1.2, V1_0_1): Fix NUM_BACKENDS macro when operated in MASTER_SLAVE mode. See following message for more details. Subject: [Pgpool-general] pgpool-II master/slave mode, BackendError From: Jeff Davis To: pgpool-general@pgfoundry.org Date: Tue, 12 Sep 2006 16:48:49 -0700 2006-09-14 11:00 t-ishii * pool_process_query.c (1.3, V1_0_1): Fix debug message in simpleQuery() so that it correctly prints query string when operated in MASTER_SLAVE mode. 2006-09-14 10:56 t-ishii * main.c (1.2, V1_0_1): enhance health check error messages 2006-09-13 19:21 y-asaba * pool_process_query.c (1.2): Fix kind mismatch error in COPY FROM STDIN. 2006-09-11 23:50 y-asaba * doc/pgpool-en.html (1.5, V1_0_1): Remove multibyte character. 2006-09-11 15:47 y-asaba * doc/tutorial-ja.html (1.1, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1): Rename `tutorial.html' to `tutorial-ja.html'. 2006-09-11 15:42 y-asaba * README.euc_jp (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1), doc/pgpool-ja.html (1.1): * Rename `doc/pgpool.html' to `doc/pgpool-ja.html'. * Merge Devrim's patch. 2006-09-11 15:32 y-asaba * doc/pgpool-en.html (1.4): Remove Japanese comment. 2006-09-11 15:13 y-asaba * doc/tutorial-en.html (1.2, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1): Remove Japanese characters. 2006-09-11 14:53 y-asaba * README (1.2, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1): Update README. 2006-09-08 21:01 devrim * doc/pgpool-en.html (1.3): Far better look for HTML page, suitable for web and local browsing. 2006-09-08 20:09 devrim * doc/pgpool-en.html (1.2): comment last modified line for a better look 2006-09-08 20:05 devrim * doc/pgpool.css (1.1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1): Add pgpool.css for readme files. This is the same stylesheet that we use in pgpool page. 2006-09-08 19:16 devrim * doc/: pgpool-en.html (1.1), tutorial-en.html (1.1): Renamed files so that some browsers won't complain. 2006-09-08 12:35 t-ishii * README (1.1), configure.in (1.1), Makefile.am (1.1), aclocal.m4 (1.1), Makefile.in (1.1), config.h.in (1.1), configure (1.1), COPYING (1.1), ChangeLog (1.1), NEWS (1.1), TODO (1.1), config.guess (1.1), config.sub (1.1), ltmain.sh (1.1), pg_md5.c (1.1), pool_config.c (1.1), README.euc_jp (1.1), main.c (1.1), pgpool.conf.sample (1.1), pgpool.spec (1.1), pool.h (1.1), pool_type.h (1.1), version.h (1.1), child.c (1.1), pool_auth.c (1.1), pool_config.l (1.1), pool_error.c (1.1), pool_connection_pool.c (1.1), pool_params.c (1.1), pool_process_query.c (1.1), pool_signal.c (1.1), pool_signal.h (1.1), pool_stream.c (1.1), pcp_child.c (1.1), pool_ipc.h (1.1), pool_sema.c (1.1), pool_shmem.c (1.1), pool_system.c (1.1), pool_rewrite_query.c (1.1), pool_rewrite_query.h (1.1), pool_rewrite_outfuncs.c (1.1), pgpool.8.in (1.1), pool_query_cache.c (1.1), parser/Makefile.am (1.1), parser/Makefile.in (1.1), sql/system_db.sql (1.1), parser/gram.c (1.1), parser/gram.h (1.1), parser/gram.y (1.1), parser/gramparse.h (1.1), parser/list.c (1.1), parser/makefuncs.c (1.1), parser/makefuncs.h (1.1), parser/memnodes.h (1.1), parser/nodes.c (1.1), parser/nodes.h (1.1), parser/parsenodes.h (1.1), parser/parser.c (1.1), parser/parser.h (1.1), parser/pg_list.h (1.1), parser/pool_memory.c (1.1), parser/pool_memory.h (1.1), parser/pool_string.c (1.1), parser/pool_string.h (1.1), parser/keywords.c (1.1), parser/keywords.h (1.1), parser/pool_parser.h (1.1), parser/primnodes.h (1.1), parser/scansup.h (1.1), parser/value.c (1.1), parser/value.h (1.1), parser/outfuncs.c (1.1), parser/scan.c (1.1), parser/scan.l (1.1), pcp/Makefile.am (1.1), pcp/Makefile.in (1.1), pcp/pcp.h (1.1), pcp/pcp.c (1.1), pcp/pcp_attach_node.c (1.1), pcp/pcp_detach_node.c (1.1), pcp/pcp_error.c (1.1), pcp/pcp_node_count.c (1.1), pcp/pcp_stream.c (1.1), pcp/pcp_stream.h (1.1), pcp/pcp_node_info.c (1.1), pcp/pcp_proc_count.c (1.1), pcp/pcp_proc_info.c (1.1), pcp/pcp_stop_pgpool.c (1.1), pcp/pcp_systemdb_info.c (1.1): Initial revision 2006-09-08 12:35 t-ishii * AUTHORS (1.1.1.1, V2_2_4), INSTALL (1.1.1.1, V2_2_4), depcomp (1.1.1.1, V2_2_4), install-sh (1.1.1.1, V2_2_4), missing (1.1.1.1, V2_2_4), mkinstalldirs (1.1.1.1, V2_2_4), md5.c (1.1.1.1), md5.h (1.1.1.1, V2_2_4), pcp.conf.sample (1.1.1.1, V2_2_4), sample/dist_def_pgbench.sql (1.1.1.1, V2_2_4), pcp/md5.h (1.1.1.1, V2_2_4), pcp/md5.c (1.1.1.1) (utags: ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_0_0, V1_0_1, V1_0_2, V1_1, V1_1_1, V1_2, V1_2_1, V1_3, V2_0_0, V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3): pgpool-II initial release