Saludos perdon por desconectarme pero se me cargo un poco la chamba tienes el cortafuegos desactivado?
De cuando levantas pgpool (pgpool -c -n -d) y te conectas por psql que te marca en si el pgpool? El 19 de agosto de 2011 15:27, Jose David Verbel Tous <jver...@solati.com.co > escribió: > Saludos, > > La ruta si existe y el propietario es el usuarios postgres con todos los > permisos. > > > 2011/8/19 Miguel Angel Hernandez Moreno <miguel.hdz....@gmail.com> > >> 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 >> >> > > > -- > > *Jose David Verbel Tous* > > Ingeniero de Desarrollo**** > > Sol@ti Ltda**** > > *jver...@solati.com.co <cor...@solati.com.co>* > > * *+57 4* *2687551**** > > * *+57 1* *6373721**** > > Carrera 43 A # 1 sur 220 Of 708, Medellín**** > > Autopista Norte # 114 - 78 Of 501, Bogotá**** > > http://www.solati.com.co > > -- ISC Miguel Angel Hernandez Moreno
