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

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

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

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

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

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

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

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

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

    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.
    t-ishii committed Dec 6, 2009
Commits on Dec 2, 2009
  1. Enhance SIGINT handler.

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

    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.
    t-ishii committed Dec 2, 2009
Commits on Nov 29, 2009
  1. Fix is_select_query() not to allow cursor statements.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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.
    t-ishii committed Nov 5, 2009
Commits on Nov 4, 2009
  1. Fix do_query() to return more than 1 characters. Patch provided by

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

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

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

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