2007-09-14 * Version 3.4.1 * Fix handling failover when health_check was disabled. (Yoshiyuki) - The bug was introduced in 3.4. * Fix deadlock while processing Parse message. (Yoshiyuki) 2007-08-01 * Version 3.4 * Add new "replicate_select" directive, being the default value to be false. (Yoshiyuki) - If it is true, SELECT query is replicated. This behavior is same as V3.2 or earlier. * Improve signal handling. (Yoshiyuki) - Occasionaly, zombie processes were remained. Or processes were unstable. * Fix hang up when SELECT was error inside a transaction block. The bug was introduced in V3.3. (Yoshiyuki) * Fix PREPARE/EXECUTE handling in master slave mode. (Yoshiyuki) * Fix "kind mismatch error" when deadlock error * Fix hang up and SEGV in extended query protocol when a warning SQL like "SELECT '\'';" executed. (Yoshiyuki) * Fix memory leak when connection cache was full. (Yoshiyuki) 2007-05-18 * Version 3.3 * Improve replication. SELECT nextval() and SELECT setval() are now replicated. (Yoshiyuki) * Change SELECT query is only sent to the master node. (Yoshiyuki) - Use /*REPLICATION*/ comment to repliate a SELECT query. * Fix unexpected failover error due to receiving an interrupt signal while connecting to the backend. (Yoshiyuki) * Fix "ps" output to follow PostgreSQL's output. (Taiki) * Change the default value for enable_pool_hba to true. (Taiki) * Add "pgpool.pam" file, for PAM configuration file, to be installed under "$PREFIX/share/". (Taiki) 2007-02-10 * Version 3.2 * Support HBA authentication(Taiki) * Support log_connections(Taiki) * Support log_hostname(Tatsuo) * Show pgpool status in ps command(Tatsuo) * Fix bug with prepared query(Yoshiyuki) * Detach secondary server when "kind mismatch error" is detected(Tatsuo) * Re-open socket if it was closed by backend while reusing connection(Yoshiyuki) 2006-12-12 * Version 3.1.2 * Allow 0 weight(Tatsuo) * Return correct error messaes when pg_hba.conf auth fails. Patch contributed by Kenji Kikuchi * Fix kind mismatch errors with COPY FROM STDIN(Yoshiyuki) * Allow load balancing with extended protocol(Yoshiyuki) 2006-07-23 * Version 3.1.1 * Fix LISTEN/NOTIFY bug in master/slave mode reported by Michael Ulitskiy (Tatsuo) 2006-07-01 * Version 3.1 * Improve documentation. patches contributed by Mark Stosberg * Fix "kind is 0!" error in Execute(). Reads messages until receiving CommandComplete, EmptyQuery, ErrorResponse or PortalSuspend in Execute() (Yoshiyuki) * Add log_statement option. patches contributed by Thomas E Lackey, modifications and documents by Tatsuo * In SimpleForwardToFrontend() do not send SYNC and wait for ready for query when PANIC or FATAL error occurs. In this case the backend closes the communication channel immediately which will cause unwanted failover/degeneration by, for example, trying to connect to invalid database (Tatsuo) * Fix dealock problem in extended modd by calling synchronize() in Execute if replication_strict is enabled (Yoshiyuki) * Fix segfault problem in race conditions among connection_life_time, child_life_time and child_max_connections (Tatsuo) 2006-05-17 * Version 3.0.2 * pgpool does not exit even if pgpool.conf contents is wrong(Tatsuo) * Fix buffer overrun bug with long health_check_user name(Taiki) * Fix occasional segfault with replication and load balance enabled(bug id #1000548)(Tatsuo) * Fix pool_send_error_message to send properly NULL terminated string(Yoshiyuki) * Fix kind mismatch error in SimpleFowardFrontend(Yoshiyuki) * Enable to build with BSD make(Yoshiyuki) * Fix pool_debug and friends to block signals while executing(Tatsuo) * Fix numerous bugs with extended query(Yoshiyuki) * Fix INSERT LOCK(Yoshiyuki) * Do not reuse startup packet(Tatsuo) * Automatically DEALLOCTE prepared queries when client disconnects(Yoshiyuki) * Do not forward packets when length = 0 in SimpleForwardToFrontend/SimpleForwardToBackend(Tatsuo) * Fix lost of kind info(Tatsuo) 2006-02-14 * Version 3.0.1 * Fix bugs with master/slave mode introduced in 2.7.2. per report from David Boreham (Tatsuo) * Fix bugs with master/slave and prepared quries. per report from David Boreham (Tatsuo) 2006-02-03 * Version 3.0.0 * Changed Copyright to PgPool Global Development Group * Fix a typo in man page 2006-02-02 * version 2.7.2 * PQnotifes() does not receive immediate responses from LISTEN * NOTIFY emits packet kind does not agree errors in master/slave mode * add pgpool man pages(Peter Eisentra) 2006-01-16 * version 2.7.1 * Fix bug in show pool_status for ignore_leading_white_space 2006-01-03 * version 2.7 * add child_max_connections. contributed by Pomarede Nicolas with minor changes by Tatsuo * add ignore_leading_white_space * fix problem with copy on V2 protocol * fix master/slave handling * fix extended query 2005-11-11 * version 2.6.5 * fix bug introduced in v2.6.4. V2 protocol/trust auth/first time connection causes error on connection. * fix problem with DROP DATABASE. if pgpool has connected to the database which is about to dropped, the command fails. 2005-10-22 * version 2.6.4 * fix connection error when client_min_message is verbose * resync pool_config.c with pool_config.l 2005-09-02 * version 2.6.3 * if invalid non-switch args are given (for example, pgpool -f pgpool.conf foobar), pgpool silently deleted pgpool.pid even if it's a valid one. Per report from Brad Nicholson. * fix show pool_status command bug. Sometimes secondary host is showed "unused" even it is actually used. * fix bug in health_check(). It made wrong reports if secondary goes down. Per report from Bunji Nagahasi. 2005-07-30 * version 2.6.2 * fix file descriptor leak bug 2005-07-18 * version 2.6.1 * set non blocking to sockets for frontend. * remove stdio usage from pool_write/pool_flush. Stdio libs have fundanmental problems with non blocking sockets * do not raise failover when read() read encounters EOF. It seems it is a oversight. Backend crush may cause that but it does not immediately mean postmaster crush * retries with EINTR or EAGAIN in pool_stream modules 2005-06-25 * version 2.6 * fix memory leak in pool_error() * allow replication between servers which have different time zone etc. * fix bug in pgpool -m f stop if pgpool stop has already issued but pgpool cannot stop. * add new "insert_lock" directive which automatically insert table locks to allow SERIAL data type replication * allow new "/*NO STRICT*/ comment to turn off the strict mode temporary * add a row to pool_staus to display server status 2005-03-12 * version 2.5.2 * fix bug in health checking * strict mode is applied to non SELECT query only * add -D_GNU_SOURCE to CPP flag 2005-02-20 * version 2.5.1 * fix bug in heal checking - sometimes health checking period drifts - if health checking is intrrupted by SIGCHILD (this could happen, for exmaple, if child_life_time expires), unwanted failover happens * accept fast/immediate shutdown request while blocking in smart shutdown * use asprintf to avoid log output confusion (thanks to Jacques Caron) * use sttok rather than strsep * emit log when starting up * make some logs from log level to debug level 2005-02-02 * version 2.5 * add health checking * add switch over * add following to pgpool.conf - print_time_stamp - master_slave_mode - connection_cache - health_check_timeout - health_check_period - health_check_user 2005-01-05 * version 2.4 * add reset_query_list so that SQL commands to be issued at the end of sessions configurable * update copyright years 2004-12-14 * version 2.3.3 * make signal handling more portable * add health check when kind does match between master and secondary 2004-12-08 * version 2.3.2 * fix bug in degeneration when session is continued 2004-11-12 * version 2.3.1 * fix bug after degeneration * fix bug in child expires its life time * fix bug when envoked with -n and sent kill signal 2004-11-05 * version 2.3 * fix memory leak in handling startup packets * implement child_life_time * add -m option to pgpool stop mode to terminate pgpool in safe manner 2004-10-28 * version 2.2.1 * restart child process if one of them detects backend errors in single/connection pool mode. This will avoid annoying errors in case of postmaster restarting. * fix bug in setting select()'s timeout parameter * fix enbug in 2.2 * fix mishandling select()'s timeout parameters in emitting ERROR when select() fails * fix comments in pgpool.conf.sample 2004-09-30 * version 2.2 * fix unexpected block when master or secondary receives shutdown request * allow listen address and add new listen_address directive. contributed by Peter Eisentraut 2004-09-13 * version 2.1 * new conf param weight_master and weight_secondary * use recent version of autoconf and automake 2004-09-02 * version 2.0.9 * use non block read() to be more reliable on heavy load * fix compilar warning on Solaris 2004-08-18 * version 2.0.8 * fix segfault when connection pool timer expires (Thanks matsuu!) 2004-08-13 * version 2.0.7 * fix compiler warning on PPC architecutre (thanks Peter!) * no need flex anymore while building pgpool (workaround is fix configure by hand. this is due to AM_PROG_LEX macro bug). * fix compiler warning and segfault on FreeBSD 5.2.1+AMD64 (thanks Martin!) * fix sigint handler in child 2004-07-22 * version 2.0.6 * workaorund with buggy 6.5's libpq * fix enbug in 2.0.5(pool_read -> pool_read2) 2004-07-19 * version 2.0.5 * do not check NULLMAP when no replication mode * fix lots of compiler warnings * change pool_read to pool_read2 * consider the case NULLMAP is different among master and secondary in BinaryRow 2004-07-17 * version 2.0.4 * accept more connections than max_pool * consider the case NULLMAP is different among master and secondary 2004-07-12 * version 2.0.3 * fix segfault when connection is reused (enbug in 2.0.2) * fix wording in pgpool.conf.sample * fix flat file password authentication on V3 and relication is true 2004-07-04 * version 2.0.2 * enhance error handling when frontend or backend failed * change "log" -> "LOG" in pool_log() 2004-07-01 * version 2.0.1 * fix bug when backend_host_name is '' * relax message length check in SimpleForwardToFrontend so that it allows rows order is physically different 2004-06-22 * version 2.0 * add load balancing capability * prevent unwanted degeneration (V1.2 behavior can be possible using replication_stop_on_mismatch directive) 2004-05-16 * version 1.2.3 * fix bug in FunctionCall in replication mode 2004-05-11 * version 1.2.2 * fix slowness when client is connected to pgpool via TCP 2004-05-08 * version 1.2.1 * fix a bug when pool_read_string() reads large string * remove unnecessary pool_write_and_flush() from AsciiRow() and BinaryRow() 2004-05-06 * version 1.2 * fix a bug introduced by v1.1 which close listen fds accidently * prevent buffer overflow by checking password string length * do authentication even when connected by pooled connection * send an end packet("X") before closing a connection to backend 2004-04-28 * version 1.1 * fix segfault when connection pool timer is expired * support clear text password, crypt, md5 authentication method. note that in repication mode, only clear text password authenticaton is supported. 2004-04-23 * pgpool 1.0 released