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: [EMAIL PROTECTED] 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
