Permalink
Commits on Dec 7, 2009
  1. Forgot to add sample pgpool.conf files.

    t-ishii
    t-ishii committed Dec 7, 2009
  2. Change release date

    t-ishii
    t-ishii committed Dec 7, 2009
  3. Prepare 2.3

    t-ishii
    t-ishii committed Dec 7, 2009
  4. Allow to load balance EXPLAIN and EXPLAIN ANALYZE (only if query is

    t-ishii
    t-ishii committed Dec 7, 2009
    SELECT). This will prevent kind mismatch errors when query plan are
    different among servers.
Commits on Dec 6, 2009
  1. Change code name for pgpool-II 2.3

    t-ishii
    t-ishii committed Dec 6, 2009
  2. Add new configuration parameter fail_over_on_backend_error which

    t-ishii
    t-ishii committed Dec 6, 2009
    controls the behavior when write to backend socket fails.
    
    Also add pool_log when postmaster administrative shutdown detected.
  3. Ignore error of pool_flush(frontend).

    t-ishii
    t-ishii committed Dec 6, 2009
  4. Optimization when num_init_children == 1. In this case we don't need

    t-ishii
    t-ishii committed Dec 6, 2009
    to wait for master returning a response before sending a query to the
    other nodes.
  5. Teach process_reporting() about log_per_node_statement.

    t-ishii
    t-ishii committed Dec 6, 2009
    Also refactor pool_process_query.c to remove process_reporting() and
    make a new source file "pool_process_reporting.c" to hold the
    funtcion. Main reason for this is, process_reporting() is now big
    enough to have a separate C source file.
Commits on Dec 2, 2009
  1. Enhance SIGINT handler.

    t-ishii
    t-ishii committed Dec 2, 2009
  2. Fix ProcessFrontendResponse() handling of Parse message in

    t-ishii
    t-ishii committed Dec 2, 2009
    master/slave mode. If it's inside transaction, enable
    master_slave_dml, which means execute parse on master only.
    This will prevent unwanted parase executed on slave, which holds
    at least AccessShareLock on tables until transaction commits.
    It seems unamed statement does not release the lock until execute.
    
    Please note that, even with this fix, bind state will remain on slave
    if JDBC issues parse with autocommit off. This is because BEGIN
    parsed, bind on both master and slave but execute only on
    master. However, this is not harmfull since parse/bind does not hold
    any locks on tables.
    
    Also add some logging statemets.
Commits on Nov 29, 2009
  1. Fix is_select_query() not to allow cursor statements.

    t-ishii
    t-ishii committed Nov 29, 2009
    Close() should not allowed since hold cursor + update
    may cause data inconsistency.
  2. Add logging by per_node_statement().

    t-ishii
    t-ishii committed Nov 29, 2009
Commits on Nov 18, 2009
  1. Add -lcrypt for linking commnad. Certain distribution ships libpq wit…

    t-ishii
    t-ishii committed Nov 18, 2009
    …hout
    
    linking to libcrypt by some reasons which I don't know.
Commits on Nov 15, 2009
  1. Run cvs2cl.pl -t --fsf -b -F trunk

    t-ishii
    t-ishii committed Nov 15, 2009
  2. Add new directive log_per_node_statement.

    t-ishii
    t-ishii committed Nov 15, 2009
    If true, print all statements to the log. Similar to log_statement except
    that prints DB node id and backend process id info.
Commits on Nov 14, 2009
  1. Fix connection_cache = false case. In this mode, if frontend exits

    t-ishii
    t-ishii committed Nov 14, 2009
    abnormaly, some global state variables are not reset. For this
    purpose, new function reset_variables() added.
    
    Remove unnecessary argument of end_load_balance().
  2. Update pool_config.l

    t-ishii
    t-ishii committed Nov 14, 2009
  3. Allow to change weight with reloading pgpool.conf

    t-ishii
    t-ishii committed Nov 14, 2009
  4. Limit listen(2)'s backlog parameter to num_init_children*2 at largest.

    t-ishii
    t-ishii committed Nov 14, 2009
    This is almost same algorithm as PostgreSQL.
    I hope pgpool-II does not consume so much system resource any more...
Commits on Nov 13, 2009
  1. Fix some query rewriting cases.

    t-ishii
    t-ishii committed Nov 13, 2009
Commits on Nov 12, 2009
  1. Prepare for bind_rewrite_timestamp() returns NULL case. This could

    t-ishii
    t-ishii committed Nov 12, 2009
    happen if SELECT now() is called inside an aborted transaction.
    
    Fix SimpleForwardToBackend free rewrite_msg too early.
Commits on Nov 11, 2009
  1. Fix comment.

    t-ishii
    t-ishii committed Nov 11, 2009
Commits on Nov 10, 2009
  1. Add support for CURRENT_TIMESTAMP and friends.

    t-ishii
    t-ishii committed Nov 10, 2009
    Patch provided by Akio Ishida.
  2. Fix comment.

    t-ishii
    t-ishii committed Nov 10, 2009
Commits on Nov 5, 2009
  1. Fix relcache replacement logic bug.

    t-ishii
    t-ishii committed Nov 5, 2009
    Patches provided by Akio Ishida.
  2. Fix nodeToString() bug. example test case:

    t-ishii
    t-ishii committed Nov 5, 2009
    If nodeToString() is given the parse tree of "insert into r1
    values(1,2), (3,4)", it returns "insert into r1 values(1,2),
    values(3,4)", which is apparently wrong.
    Patch provided by Akio Ishida.
Commits on Nov 4, 2009
  1. Fix do_query() to return more than 1 characters. Patch provided by

    t-ishii
    t-ishii committed Nov 4, 2009
    Akio Ishida.
Commits on Nov 3, 2009
  1. - Remove init script from all runlevels before uninstall. Per #RH Bug…

    devrim
    devrim committed Nov 3, 2009
    …zilla
    
      532177
  2. When authentication fails, report to frontend proper error messages,

    t-ishii
    t-ishii committed Nov 3, 2009
    rather than unhelpfull "server closed the connection unexpectedly"
    message. Patch provided by Glyn Astill with minor tweak by Tatsuo Ishii.
  3. Fix pool_flush_it() so that it does not complain when failed to flush

    t-ishii
    t-ishii committed Nov 3, 2009
    to frontend. Also add info to the message if it was backend or
    frontend to avoid confusion.