$pgpoolConfigParam = array();

$pgpoolConfigBackendParam = array();

$pgpoolConfigWdOtherParam = array();

$pgpoolConfigHbDestinationParam = array();

$pgpoolConfigHealthCheckParam = array();

define('NUM_MAX', 65535);

$strreg = '^[0-9a-zA-Z_\-]+$';

$dirreg = '^\/[0-9a-zA-Z\._\/\-]+$';

$hostreg = '^[0-9a-zA-Z\._\-]*$';

$sslreg = '^(|\/[0-9a-zA-Z_\/\.\-]*)$';

$commandreg = '^[0-9a-zA-Z_\/\.\-]*$';

$addressreg = '^([0-9a-zA-Z\._\-]+|[\*]{1})$';

$listreg = '^[0-9a-zA-Z_,]*$';

$queryreg = '^[0-9a-zA-Z; ]+$';

$userreg = "^[0-9a-zA-Z_\.\-]+$";

$permissionreg = '^(0[0-7]{3}|[rwx\-]{9})$';

$anyelse = '.*';

function selectreg($lists)

{

return '^['. implode('|', $lists). ']+$';

}

$key = 'backend_clustering_mode';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['select'] = array('streaming_replication',

'logical_replication',

'slony',

'native_replication',

'snapshot_isolation',

'raw');

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$key = 'listen_addresses';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'localhost';

$pgpoolConfigParam[$key]['regexp'] = $addressreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'port';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 9999;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['min'] = 1024;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'socket_dir';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '/tmp';

$pgpoolConfigParam[$key]['regexp'] = $dirreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'listen_backlog_multiplier';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 2;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['min'] = 1;

$key = 'serialize_accept';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'reserved_connections';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = '0';

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'pcp_listen_addresses';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'localhost';

$pgpoolConfigParam[$key]['regexp'] = $addressreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'pcp_port';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 9898;

$pgpoolConfigParam[$key]['min'] = 1024;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'pcp_socket_dir';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '/tmp';

$pgpoolConfigParam[$key]['regexp'] = $dirreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'backend_hostname';

$pgpoolConfigBackendParam[$key]['type'] = 'C';

$pgpoolConfigBackendParam[$key]['default'] = '';

$pgpoolConfigBackendParam[$key]['regexp'] = $hostreg;

$pgpoolConfigBackendParam[$key]['multiple'] = TRUE;

$key = 'backend_port';

$pgpoolConfigBackendParam[$key]['type'] = 'N';

$pgpoolConfigBackendParam[$key]['default'] = 5432;

$pgpoolConfigBackendParam[$key]['min'] = 1024;

$pgpoolConfigBackendParam[$key]['max'] = NUM_MAX;

$pgpoolConfigBackendParam[$key]['multiple'] = TRUE;

$key = 'backend_weight';

$pgpoolConfigBackendParam[$key]['type'] = 'F';

$pgpoolConfigBackendParam[$key]['default'] = 1;

$pgpoolConfigBackendParam[$key]['min'] = 0.0;

$pgpoolConfigBackendParam[$key]['max'] = 100.0;

$pgpoolConfigBackendParam[$key]['multiple'] = TRUE;

$key = 'backend_data_directory';

$pgpoolConfigBackendParam[$key]['type'] = 'C';

$pgpoolConfigBackendParam[$key]['default'] = '';

$pgpoolConfigBackendParam[$key]['regexp'] = $anyelse;

$pgpoolConfigBackendParam[$key]['multiple'] = TRUE;

$key = 'backend_flag';

$pgpoolConfigBackendParam[$key]['type'] = 'C';

$pgpoolConfigBackendParam[$key]['default'] = 'ALLOW_TO_FAILOVER';

if (_PGPOOL2_VERSION >= 4.2) {

$pgpoolConfigBackendParam[$key]['select'] = array('ALLOW_TO_FAILOVER', 'DISALLOW_TO_FAILOVER', 'ALWAYS_PRIMARY');

} elseif (_PGPOOL2_VERSION >= 3.7) {

$pgpoolConfigBackendParam[$key]['select'] = array('ALLOW_TO_FAILOVER', 'DISALLOW_TO_FAILOVER', 'ALWAYS_MASTER');

} else {

$pgpoolConfigBackendParam[$key]['select'] = array('ALLOW_TO_FAILOVER', 'DISALLOW_TO_FAILOVER');

}

$pgpoolConfigBackendParam[$key]['regexp'] = selectreg($pgpoolConfigBackendParam[$key]['select']);

$pgpoolConfigBackendParam[$key]['multiple'] = TRUE;

$key = 'backend_application_name';

$pgpoolConfigBackendParam[$key]['type'] = 'C';

$pgpoolConfigBackendParam[$key]['default'] = '';

$pgpoolConfigBackendParam[$key]['regexp'] = $anyelse;

$pgpoolConfigBackendParam[$key]['multiple'] = TRUE;

$key = 'enable_pool_hba';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'pool_passwd';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'pool_passwd';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$key = 'authentication_timeout';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 60;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = 10000;

$key = 'allow_clear_text_frontend_auth';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'ssl';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'ssl_key';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $sslreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_cert';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $sslreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_ca_cert';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $sslreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_ca_cert_dir';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $sslreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_crl_file';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $sslreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_ciphers';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'HIGH:MEDIUM:+3DES:!aNULL';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_prefer_server_ciphers';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_ecdh_curve';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'prime256v1';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_dh_params_file';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $sslreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'ssl_passphrase_command';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('ssl' => 'on');

$key = 'num_init_children';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = '32';

$pgpoolConfigParam[$key]['min'] = 1;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'max_pool';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 4;

$pgpoolConfigParam[$key]['min'] = 1;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'child_life_time';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 300;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$key = 'child_max_connections';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 0;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$key = 'connection_life_time';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 0;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$key = 'client_idle_limit';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 0;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$key = 'log_destination';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'stderr';

$pgpoolConfigParam[$key]['select'] = array('stderr', 'syslog');

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$key = 'logging_collector';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'log_directory';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '/tmp/pgpool_logs';

$pgpoolConfigParam[$key]['regexp'] = $dirreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('logging_collector' => 'on');

$key = 'log_filename';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'pgpool-%Y-%m-%d_%H%M%S.log';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('logging_collector' => 'on');

$key = 'log_file_mode';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '0600';

$pgpoolConfigParam[$key]['regexp'] = $permissionreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('logging_collector' => 'on');

$key = 'log_rotation_age';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 1440;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('logging_collector' => 'on');

$key = 'log_rotation_size';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 0;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('logging_collector' => 'on');

$key = 'log_truncate_on_rotation';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('logging_collector' => 'on');

$key = 'log_line_prefix';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$key = 'print_timestamp';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'on';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'log_connections';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'log_disconnections';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'log_hostname';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'log_statement';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'log_per_node_statement';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'log_client_messages';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$key = 'log_standby_delay';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'none';

$pgpoolConfigParam[$key]['select'] = array('always', 'if_over_threshold', 'none');

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$key = 'syslog_facility';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'LOCAL0';

$pgpoolConfigParam[$key]['regexp'] = $strreg;

$pgpoolConfigParam[$key]['parent'] = array('log_destination' => 'syslog');

$key = 'syslog_ident';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'pgpool';

$pgpoolConfigParam[$key]['regexp'] = $strreg;

$pgpoolConfigParam[$key]['parent'] = array('log_destination' => 'syslog');

$key = 'debug_level';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = '0';

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$key = 'log_error_verbosity';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'DEFAULT';

$pgpoolConfigParam[$key]['select'] = array('TERSE', 'DEFAULT', 'VERBOSE');

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$key = 'client_min_messages';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'notice';

$pgpoolConfigParam[$key]['select'] = array(

'debug5', 'debug4', 'debug3', 'debug2', 'debug1',

'log', 'notice', 'warning', 'error'

);

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$key = 'log_min_messages';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'warning';

$pgpoolConfigParam[$key]['select'] = array(

'debug5', 'debug4', 'debug3', 'debug2', 'debug1',

'info', 'notice', 'warning', 'error', 'log', 'fatal', 'panic'

);

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$key = 'pid_file_name';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '/var/run/pgpool/pgpool.pid';

$pgpoolConfigParam[$key]['regexp'] = $dirreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'logdir';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '/tmp';

$pgpoolConfigParam[$key]['regexp'] = $dirreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'connection_cache';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] =true;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'reset_query_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'ABORT; DISCARD ALL';

$pgpoolConfigParam[$key]['regexp'] = $queryreg;

$key = 'replication_mode';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'replicate_select';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'native_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('replication_mode' => 'on');

}

$key = 'insert_lock';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'native_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('replication_mode' => 'on');

}

$key = 'lobj_lock_table';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'native_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('replication_mode' => 'on');

}

$key = 'replication_stop_on_mismatch';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'native_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('replication_mode' => 'on');

}

$key = 'failover_if_affected_tuples_mismatch';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'native_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('replication_mode' => 'on');

}

$key = 'load_balance_mode';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'ignore_leading_white_space';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = true;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'white_function_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'read_only_function_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'black_function_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'write_function_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'black_query_pattern_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'primary_routing_query_pattern_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'database_redirect_preference_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'app_name_redirect_preference_list';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'allow_sql_comments';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'disable_load_balance_on_write';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'transaction';

if (_PGPOOL2_VERSION >= 4.2) {

$pgpoolConfigParam[$key]['select'] = array('transaction', 'off', 'trans_transaction', 'always', 'dml_adaptive');

} else {

$pgpoolConfigParam[$key]['select'] = array('transaction', 'off', 'trans_transaction', 'always');

}

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'statement_level_load_balance';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['parent'] = array('load_balance_mode' => 'on');

$key = 'master_slave_mode';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'master_slave_sub_mode';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'stream';

$pgpoolConfigParam[$key]['select'] = array('stream', 'slony');

$pgpoolConfigParam[$key]['regexp'] = selectreg($pgpoolConfigParam[$key]['select']);

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('master_slave_mode' => 'on');

$key = 'sr_check_period';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 0;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'streaming_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('master_slave_mode' => 'on', 'master_slave_sub_mode' => 'stream');

}

$key = 'sr_check_user';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $listreg;

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'streaming_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('master_slave_mode' => 'on', 'master_slave_sub_mode' => 'stream');

}

$key = 'sr_check_password';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $listreg;

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'streaming_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('master_slave_mode' => 'on', 'master_slave_sub_mode' => 'stream');

}

$key = 'sr_check_database';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $listreg;

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'streaming_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('master_slave_mode' => 'on', 'master_slave_sub_mode' => 'stream');

}

$key = 'delay_threshold';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 0;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

if (hasBackendClusteringMode()) {

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'streaming_replication');

} else {

$pgpoolConfigParam[$key]['parent'] = array('master_slave_mode' => 'on', 'master_slave_sub_mode' => 'stream');

}

$key = 'follow_master_command';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('master_slave_mode' => 'on');

$key = 'follow_primary_command';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['parent'] = array('backend_clustering_mode' => 'streaming_replication');

$key = 'parallel_mode';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$key = 'enable_query_cache';

$pgpoolConfigParam[$key]['type'] = 'B';

$pgpoolConfigParam[$key]['default'] = 'off';

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'pgpool2_hostname';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'localhost';

$pgpoolConfigParam[$key]['regexp'] = $hostreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'system_db_hostname';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'system_db_hostname';

$pgpoolConfigParam[$key]['regexp'] = $hostreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'system_db_port';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] = 5432;

$pgpoolConfigParam[$key]['min'] = 1024;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'system_db_dbname';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'pgpool';

$pgpoolConfigParam[$key]['regexp'] = $strreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'system_db_schema';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'pgpool_catalog';

$pgpoolConfigParam[$key]['regexp'] = $strreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'system_db_user';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'pgpool';

$pgpoolConfigParam[$key]['regexp'] = $userreg;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'system_db_password';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['restart'] = TRUE;

$pgpoolConfigParam[$key]['parent'] = array('parallel_mode' => 'on');

$key = 'health_check_period';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] =0;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['healthcheck'] = TRUE;

$key = 'health_check_timeout';

$pgpoolConfigParam[$key]['type'] = 'N';

$pgpoolConfigParam[$key]['default'] =20;

$pgpoolConfigParam[$key]['min'] = 0;

$pgpoolConfigParam[$key]['max'] = NUM_MAX;

$pgpoolConfigParam[$key]['healthcheck'] = TRUE;

$key = 'health_check_user';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = 'noboby';

$pgpoolConfigParam[$key]['regexp'] = $userreg;

$pgpoolConfigParam[$key]['healthcheck'] = TRUE;

$key = 'health_check_password';

$pgpoolConfigParam[$key]['type'] = 'C';

$pgpoolConfigParam[$key]['default'] = '';

$pgpoolConfigParam[$key]['regexp'] = $anyelse;

$pgpoolConfigParam[$key]['healthcheck'] = TRUE;