[Pgpool-general] Error in Master/Slave Replication

[Ole Wendland]

Hi guys,
I try to setup a Master/Slave replication via streaming. If I activate 
replication without Master/Slave everything works fine, but in the 
Master/Slave mode it is somehow messed up. I always get this one error 
and I have no idea where to look, at the master postgres side, master 
pgpool side or somewhere at the slave. Has anybody seen something like this?

"2010-11-04 16:11:59 ERROR: pid 3339: check_replication_time_lag: SELECT 
pg_last_xlog_receive_location() returns no data"

Greetings Ole


#
# pgpool-II configuration file sample
# $Header: 
/cvsroot/pgpool/pgpool-web/contrib_docs/simple_sr_setting/pgpool.conf,v 
1.1 2010/11/04 04:39:57 t-ishii Exp $

listen_addresses = '*'
port = 9999
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 32
max_pool = 4
child_life_time = 0
connection_life_time = 0
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
logdir = '/var/log/pgpool'
pid_file_name = '/var/run/pgpool/pgpool.pid'
replication_mode = false
load_balance_mode = true
replication_stop_on_mismatch = false
failover_if_affected_tuples_mismatch = true
replicate_select = false
reset_query_list = 'ABORT;DISCARD ALL'
# white_function_list = ''
# black_function_list = 'nextval,setval'
white_function_list = ''
#black_function_list = ''
black_function_list = 'nextval,setval,foo'
print_timestamp = true
master_slave_mode = true
master_slave_sub_mode = 'stream'
delay_threshold = 100
log_standby_delay = 'if_over_threshold'
#log_standby_delay = 'always'
connection_cache = true
health_check_timeout = 10
health_check_period = 10
health_check_user = 'smv_ts_user'
failover_command = '/usr/local/etc/failover.sh %d "%h" %p %D %m %M "%H" %P'
failback_command = '/bin/rm -f /tmp/trigger_file1'
fail_over_on_backend_error = false
insert_lock = true
ignore_leading_white_space = false
log_statement = false
log_per_node_statement = true
log_connections = false
log_hostname = false
parallel_mode = false
enable_query_cache = false
#set pgpool2 hostname
pgpool2_hostname = ''
# system DB info
system_db_hostname = 'localhost'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = ''

# - HBA -
enable_pool_hba = true
#pool_passwd = 'pool_passwd'
recovery_user = 'smv_ts_user'
recovery_password = 'smv_ts_user'
recovery_1st_stage_command = 'basebackup.sh'
recovery_2nd_stage_command = ''
recovery_timeout = 60
client_idle_limit_in_recovery = 0
lobj_lock_table = 'pgpool_lobj_lock'

ssl = true
# path to the SSL private key file
ssl_key = '/root/server.key'
# path to the SSL public certificate file
ssl_cert = '/root/server.crt'
# Debug message verbosity level. 0: no message, 1 <= : more verbose
debug_level = 1

replication_timeout = 5000
log_statement = false
ssl_ca_cert = ''
ssl_ca_cert_dir = ''
backend_hostname0 = '192.168.1.1'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/pgsql/9.0/data/'
backend_hostname1 = '192.168.1.2'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/pgsql/9.0/data/'
backend_hostname2 = '192.168.1.3'
backend_port2 = 5432
backend_weight2 = 1
backend_data_directory2 = '/var/lib/pgsql/9.0/data/'