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

Re: Problemas con pgpool

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

In response to

Responses

pgsql-es-ayuda by date

Next:From: Jose David Verbel TousDate: 2011-08-19 17:12:10
Subject: Re: Problemas con pgpool
Previous:From: Miguel Angel Hernandez MorenoDate: 2011-08-19 16:52:18
Subject: Re: Problemas con pgpool

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