se me pasaba en el server nodo1 verifica que exista la direccion y que ostgres tenga derecho a escritura /var/run/postgresql/
por que ese es el error que te marca 2011/8/19 Miguel Angel Hernandez Moreno <miguel.hdz....@gmail.com> > > Dudas > > backend_hostname0 = 'nodo1' > nodo1= tu ip o localhost, o servidor principal > > psql -h nodo1 -p 9999 -U postgres -d postgres > comentas que estas entrando por psql, Cuando entras a nodo1 asi que te > marca el log de pgpool cuando haces un select > a cualquier tabla > > Como estas levantando pgpool, para un poco mas de informes leventa el > proceso asi y dime que te arroja cuando aplicas el > ejecrcicio pasado > pgpool -c -n -d > > Para pruebas y solo para pruebas (ya de rato configuras, sino alvaro me va > a regañar por dar esta sugerencia) el servidor > backend1 con ip 192.168.4.162 en su pg_hba.conf configura en metodo de > autentificacion como trust para la ip del servidor nodo1 > host all all ip_nodo1 trust > > repite el ejercico y comenta que resultados te da > > > > > > > > 2011/8/19 Jose David Verbel Tous <jver...@solati.com.co> > >> 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* >> > > > > -- > ISC Miguel Angel Hernandez Moreno > > -- ISC Miguel Angel Hernandez Moreno
