pgpool Setting
Summary
The content of pgpool.conf that is the configuration file of pgpool set can be displayed and be changed.Feature
Please input the value that wants to change and push the update button.Addition of A backend host
Please push the add button when you want to add a new back end host.It inputs in back end host's item and a new input column can be done, and input information on a new back end host there, please.
Please push the update button when input ends.
Deletion of backend host
Please push the delete button at the right of the host setting when you want to delete the back end host who has registered.Connections
Parameter | Detail |
---|---|
listen_addresses (string) |
Specifies the addresses to listen on for TCP/IP connections. Set to '*' for all configured IP interfaces, '' for no TCP/IP connections, or else to a specific IP address or host name. The default is 'localhost'. Note that connections via UNIX domain sockets are always allowed. |
port (integer) |
The port number where pgpool is running on. Default value is 9999. |
socket_dir (string) |
The directory of unix domain socket for PostgreSQL server. Default value is '/tmp'. |
num_init_children (integer) |
Number of pgpool process initially forked. Default value is 32. |
max_pool (integer) |
Number of connection pools each pgpool server process are keeping. pgpool will make a new connection if there's no user name and database name pair yet. Thus it is recommended that max_pool exceeds the number of such that possible pairs. If it exceeds, the oldest connection is discarded and the new connection uses the slot. The default value is 4. |
child_life_time (integer) |
Life of a idle child process in seconds. This will prevent unwanted memory leaks or other problems. Default is 300. Set it to 0 disables this feature. |
connection_life_time (integer) |
Life time for each idle connection in seconds. 0 means the life time is forever. The default value is 0. |
child_max_connections (integer) |
If child_max_connections connections were received, child exits. 0 means no exit. The default value is 0. |
connection_cache |
If true, cache connections to PostgreSQL. Default value is true. |
pgpool2_hostname (string) |
The host name that pgpool2 runs is specified. |
Backends
Parameter | Detail | |
---|---|---|
backend_socket_dir (string) |
The directory of unix domain socket for PostgreSQL server. Default value is '/tmp'. | |
backend_hostname (string) |
The host name that PostgreSQL runs is specified. | |
backend_port (integer) |
It is a port number that postmaster is running. | |
backend_weight (integer) |
The weight at the load balance mode is set by the value from 0 to 1. Relative weight is calculated and distributed from the value specified with all the back end servers. |
PCP (pgpool Control Port)
Parameter | Detail |
---|---|
pcp_port (integer) |
It is a port number to connect it with PCP. Default is 9898. |
pcp_socket_dir (string) |
The directory of unix domain socket for PCP. Default value is '/tmp'. |
pcp_timeout (integer) |
The time-out of the PCP command is set. The connection disconnect when there will not be response in this time. |
Logging
Parameter | Detail |
---|---|
logdir (string) |
The directory name to store pgpool's log files. Currently only a file named pgpool.pid(has pgpool's process id) is stored. The default value for logdir is '/tmp'. |
print_timestamp |
If true timestamp is added to each log line. The default value is true. |
log_statement |
If true, print all statements to the log. Like the log_statement option to PostgreSQL, this allows for observing queries without engaging in full debugging. The default value is false. |
log_connections |
If true, incoming connections will be printed to the log. |
log_hostname |
If true, incoming client's hostname will be printed in the "ps" command result. Also, if log_connections is enabled, hostname will be printed with a connection log. Be aware that hostname lookup adds some overhead, and may slow down pgpool-II. |
Replication
Parameter | Detail |
---|---|
replication_mode |
Set this true if you are going to use replication functionality. Default is false. |
replication_strict |
If true, pgpool will wait for the completion of the master query before sending a query to the secondary server. This is the safest and default operating mode for pgpool. Default is true. |
replication_stop_on_mismatch |
Stop replication mode on data mismatch between master and secondary. Default is false. |
reset_query_list (string) |
SQL command to initialize the connection when the session ends is delimited by ";". |
Health Check
Parameter | Detail |
---|---|
health_check_timeout (integer) |
pgpool does "health check" periodically to detect PostgreSQL servers down, network communication problems or as such. If something is going wrong, pgpool will automatically run into fail over or degeneration mode. |
health_check_period (integer) |
Specifies the interval for next health checking. 0 means no health checking. The default is 0(i.e. no health checking). |
health_check_user (string) |
PostgreSQL user name for the health checking. |
Online Recovery
Parameter | Detail |
---|---|
recovery_user (string) |
A PostgreSQL user name to be used during online recovery process. |
recovery_password (string) |
"recovery_user"'s password to be used during online recovery process. |
recovery_1st_stage_command (string) |
Specifies a script name to be executed for the first stage of an online recovery process. The script needs to be placed in master node's database cluster ($PGDATA) |
recovery_2nd_stage_command (string) |
Specifies a script name to be executed for the second stage of an online recovery process. The script needs to be placed in master node's database cluster ($PGDATA |
recovery_timeout (integer) |
Number of seconds to wait for online recovery to complete. Note that 0 means NO WAIT; not no timeout. |
System Database
Parameter | Detail |
---|---|
system_db_hostname (string) |
The host name that system DB is operating is specified. It connects with Unix domain socket when not specifying it. |
system_db_port (integer) |
The port number to connect system DB is specified. |
system_db_dbname (string) |
The data base name of system DB is specified. |
system_db_schema (string) |
The schema name of system DB is specified. |
system_db_user (string) |
The username connected with system DB is specified. |
system_db_password (string) |
The password connected with system DB is specified. |
Others
Parameter | Detail |
---|---|
load_balance_mode |
Perform load balancing for SELECT. Default is false. |
master_slave_mode |
Run in master/slave mode. See 14 for more details. Default value is false. This mode is not compatible with replication_mode. |
insert_lock |
If you replicate a table having SERIAL data type column, sometimes the serial value does not match between servers. You can avoid the problem by using a table lock (with a performance penalty due to
less currency in transactions). For this you need to rewrite you query:
INSERT INTO .... to:
BEGIN; This is painfull. If you turn on insert_lock, pgpool will automatically do the rewriting for you. |
ignore_leading_white_space |
If true, ignore leading white spaces of each query while pgpool judges if the query is a SELECT so that it can be load balanced. This is usefull for certain APIs such as DBI/DBD which is know as adding an extra leading white space. |
parallel_mode |
If true, pgpool runs in parallel mode. You must define partitioning rules to use parallel mode. |
enable_query_cache |
If true, allow pgpool to cache SELECT query results. |
enable_pool_hba |
If true, incoming clients are authenticated based on the configuration written in pool_hba.conf. |