2010/9/27 Tatsuo Ishii <[email protected]>: > You should use "raw mode", which means both replication_mode and > master_slave_mode are turned off. Tatsuo Ishii SRA OSS, Inc. Japan
I'm using raw mode: failover_command = 'touch /opt/WAL_ARCHIVE/pgsql.trigger' listen_addresses = '*' port = 9999 pcp_port = 9898 socket_dir = '/var/run/pgpool' pcp_socket_dir = '/var/run/pgpool' backend_socket_dir = '/var/run/pgpool' pcp_timeout = 10 num_init_children = 50 max_pool = 4 child_life_time = 300 connection_life_time = 0 child_max_connections = 0 client_idle_limit = 0 authentication_timeout = 60 logdir = '/var/run/postgresql' #RAW replication_mode = false master_slave_mode = false load_balance_mode = false replication_stop_on_mismatch = false replicate_select = false reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' print_timestamp = true connection_cache = true health_check_timeout = 20 health_check_period = 30 health_check_user = 'pgpool' failback_command = '' insert_lock = false ignore_leading_white_space = true log_statement = false log_connections = false log_hostname = false parallel_mode = false enable_query_cache = false pgpool2_hostname = 'bbdd2' system_db_hostname = 'bbdd1' system_db_port = 5432 system_db_dbname = 'pgpool' system_db_schema = 'pgpool_catalog' system_db_user = 'postgres' system_db_password = 'postavalon' backend_hostname0 = 'bbdd1' backend_weight0 = 1 backend_port0 = 5432 backend_hostname1 = 'bbdd2' #backend_weight1 = 1 backend_port1 = 5432 debug_level = 100 -- Emanuel Calvo Franco Independient DBA www.emanuelcalvofranco.com.ar _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
