Saludos, El entorno que estoy configurando es Ubuntu 10.04, pgpool 3.41-2 de los repositorios de Ubuntu, PostgreSQL 8.4.8
listen_addresses = '*' port = 9999 pcp_port = 9898 socket_dir = '/var/run/postgresql/' pcp_socket_dir = '/var/run/postgresql/' backend_socket_dir = '/var/run/postgresql/' pcp_timeout = 10 num_init_children = 32 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/' pid_file_name = '/var/run/postgresql/pgpool.pid' replication_mode = true 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 = 'postgres' failover_command = '' failback_command = '' fail_over_on_backend_error = true insert_lock = false ignore_leading_white_space = true log_statement = true log_per_node_statement = true log_connections = false log_hostname = false # if non 0, run in parallel query mode parallel_mode = false # if non 0, use query cache enable_query_cache = false #set pgpool2 hostname pgpool_hostname = 'nodo1' # system DB info system_db_hostname = 'nodo1' system_db_port = 5432 system_db_dbname = 'pgpool' system_db_schema = 'pgpool_catalog' system_db_user = 'pgpool' system_db_password = '' # backend_hostname, backend_port, backend_weight backend_hostname0 = 'nodo1' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/var/lib/postgresql/8.4/main' backend_hostname1 = '192.168.4.162' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/var/lib/postgresql/8.4/main' enable_pool_hba = false recovery_user = 'postgres' recovery_password = '' recovery_1st_stage_command = '' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 lobj_lock_table = '' ssl = false > 2011/8/19 Jose David Verbel Tous <jver...@solati.com.co> > >> Saludos, >> >> >> Estoy en proceso de configurar pgpool para replicacion y aunque el >> servicio levanta y me puedo conectar usando: psql -hnodo1 -p 9999 -U >> postgres -d postgres, el log me muestra esto y no me esta replicando. >> >> LOG: pid 8801: pgpool successfully started >> LOG: pid 8801: starting health checking >> ERROR: pid 8801: connect_unix_domain_socket: connect() failed: No such >> file or directory >> ERROR: pid 8801: health check failed. secondary at port 0 is down >> LOG: pid 8801: starting degeneration. shutdown secondary host (0) >> LOG: pid 8801: degeneration done. shutdown secondary host (0) >> >> >> Alguna idea de que puede estar mal ? >> >> >> -- >> >> *Jose David* >> > > > > -- > ISC Miguel Angel Hernandez Moreno > > -- *Jose David Verbel Tous*
