[Pgpool-general] pgpool-II and online recovery

[Łukasz Jagiełło]

Hi,

After reading:
- http://www.pgcon.org/2008/schedule/attachments/66_pgpool-II-demo.pdf
- http://www.zeroaccess.org/2008/5/5/replication-pgpool
- http://lists.pgfoundry.org/pipermail/pgpool-general/2008-May/001007.html
(hole thread)
- http://pgpool.projects.postgresql.org/#online-recovery

I try create such replication with online recovery. Replication work
nice - at all backends same data. But on-line recovery doesn't start
(I think doesn't start cause don't have any logs with errors/success
any action).

Atm got 4 servers:
- server with pgpool
- 2 replicating postgresql servers
- 1 fresh postgresql server

My pgpool.conf:
#v+
listen_addresses = '*'
port = 5432
pcp_port = 9898
socket_dir = '/var/run'
pcp_socket_dir = '/var/run'
backend_socket_dir = '/var/run'
pcp_timeout = 10
num_init_children = 32
max_pool = 4
child_life_time = 300
connection_life_time = 0
client_idle_limit=600
authentication_timeout=0
child_max_connections = 0
logdir = '/var/log'
replication_mode = true
replication_strict = true
replication_timeout = 5000
load_balance_mode = true
replication_stop_on_mismatch = true
replicate_select = false
reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_timestamp = true
master_slave_mode = false
connection_cache = true
health_check_timeout = 20
health_check_period = 60
health_check_user = 'hchecker'
failover_command = ''
failback_command = ''
insert_lock = false
ignore_leading_white_space = true
recovery_user='pgrecov'
recovery_password = ''
recovery_1st_stage_command = 'base-backup.sh'
recovery_2nd_stage_command = 'pgpool-recovery'
log_statement = true
log_connections = true
log_hostname = true
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = 'db.morpheus'
enable_pool_hba = false

backend_hostname0 = '10.0.0.255'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/data'

backend_hostname1 = '10.0.0.145'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/data'

backend_hostname2 = '10.0.0.70'
backend_port2 = 5432
backend_weight2 = 1
backend_data_directory2 = '/data'
#v-

All postgres got pgpool-recovery.sql in template1 and C language
function. At all postgres servers got scripts like
(http://lists.pgfoundry.org/pipermail/pgpool-general/2008-May/001007.html)
and (http://pgpool.projects.postgresql.org/#online-recovery) for
recovery_1st_stage_command and recovery_2st_stage_command.

Any idea how to debug what is wrong ?

Regards
-- 
Łukasz Jagiełło
G-Forces Web Management Polska

T: +44 (0) 845 055 9040
F: +44 (0) 845 055 9038
E: lukasz.jagiello at gforces.pl
W: www.gforces.co.uk

This e-mail is confidential and intended solely for the use of the
individual to whom it is addressed. If you are not the intended
recipient, please notify the sender immediately. Do not disclose the
contents of this e-mail to any other person, use it for any purpose,
print, copy, store, or distribute it. This e-mail should then be
destroyed. Any views expressed in this message are those of the
individual sender except where the sender specifically states them to
be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5
Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
Company No. 3863609. VAT Registration No. 7250 384 50