[Pgpool-general] pgpool + warm standby presentation

[Emanuel Calvo Franco]

2010/9/27 Tatsuo Ishii <ishii at sraoss.co.jp>:
> 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