Skip site navigation (1) Skip section navigation (2)

Re: Problemas con pgpool

From: Jose David Verbel Tous <jverbel(at)solati(dot)com(dot)co>
To: Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com>
Cc: pgsql-es-ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: Problemas con pgpool
Date: 2011-08-19 20:27:25
Message-ID: CAPgddUKqfFj=jNMb4ZyDGJwT9EPxmYBXJRcDGSyof5Oi_+gSLw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
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

In response to

Responses

pgsql-es-ayuda by date

Next:From: Edwin QuijadaDate: 2011-08-20 14:47:52
Subject: RE: Actualizar fila y controlar concurrencia
Previous:From: Hugo CésarDate: 2011-08-19 19:44:26
Subject: Re: Duda acerca Tsearch con acentos

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group