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.
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.
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.
* 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