Skip to content


Subversion checkout URL

You can clone with
Download ZIP
branch: master
Commits on Dec 7, 2009
  1. Forgot to add sample pgpool.conf files.

    t-ishii authored
  2. Change release date

    t-ishii authored
  3. Prepare 2.3

    t-ishii authored
  4. Allow to load balance EXPLAIN and EXPLAIN ANALYZE (only if query is

    t-ishii authored
    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 authored
  2. Add new configuration parameter fail_over_on_backend_error which

    t-ishii authored
    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 authored
  4. Optimization when num_init_children == 1. In this case we don't need

    t-ishii authored
    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 authored
    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 authored
  2. Fix ProcessFrontendResponse() handling of Parse message in

    t-ishii authored
    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 authored
    Close() should not allowed since hold cursor + update
    may cause data inconsistency.
  2. Add logging by per_node_statement().

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

    t-ishii authored
    linking to libcrypt by some reasons which I don't know.
Commits on Nov 15, 2009
  1. Run -t --fsf -b -F trunk

    t-ishii authored
  2. Add new directive log_per_node_statement.

    t-ishii authored
    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 authored
    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 authored
  3. Limit listen(2)'s backlog parameter to num_init_children*2 at largest.

    t-ishii authored
    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 authored
Commits on Nov 12, 2009
  1. Prepare for bind_rewrite_timestamp() returns NULL case. This could

    t-ishii authored
    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 authored
Commits on Nov 10, 2009
  1. Add support for CURRENT_TIMESTAMP and friends.

    t-ishii authored
    Patch provided by Akio Ishida.
  2. Fix comment.

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

    t-ishii authored
    Patches provided by Akio Ishida.
  2. Fix nodeToString() bug. example test case:

    t-ishii authored
    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
Commits on Nov 3, 2009
  1. When authentication fails, report to frontend proper error messages,

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

    t-ishii authored
    to frontend. Also add info to the message if it was backend or
    frontend to avoid confusion.
Something went wrong with that request. Please try again.