Re: Problemas con pgpool

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 <jverbel(at)solati(dot)com(dot)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(dot)hdz(dot)mrn(at)gmail(dot)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(dot)hdz(dot)mrn(at)gmail(dot)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 <jverbel(at)solati(dot)com(dot)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 <jverbel(at)solati(dot)com(dot)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(at)ti Ltda****
>
> *jverbel(at)solati(dot)com(dot)co <correo(at)solati(dot)com(dot)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