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 16:25:38 |
Message-ID: | CAPgddU+u-TPgKUiaKBFt3HkWGJ9Prk9onwJLN=N7x1oik8idAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
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*
From | Date | Subject | |
---|---|---|---|
Next Message | Hellmuth Vargas | 2011-08-19 16:31:32 | Re: separar datos de un campo |
Previous Message | Miguel Angel Hernandez Moreno | 2011-08-19 16:14:47 | separar datos de un campo |