Re: Problemas con pgpool

Respondo entre lineas.

On 19 August 2011 11:52, Miguel Angel Hernandez Moreno <
miguel(dot)hdz(dot)mrn(at)gmail(dot)com> wrote:

>
> Dudas
>
> backend_hostname0 = 'nodo1'
> nodo1= tu ip o localhost, o servidor principal
>
>

Nodo 1 es el localhost donde esta instalado el pgpool en mi /etc/hosts
tengo 127.0.0.1 nodo1

> 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
>

Esto lo hago desde el nodo2 o cualquier otra maquina y este es el log.

pgpool: 2011-08-19 11:55:18 LOG: pid 11308: statement: RESET ALL
pgpool: 2011-08-19 11:55:18 LOG: pid 11308: statement: SET SESSION
AUTHORIZATION DEFAULT
pgpool: 2011-08-19 12:00:49 LOG: pid 11311: statement: SELECT * from
pg_catalog.pg_database ;

> Como estas levantando pgpool,
>

/etc/init.d/pgpool start

> para un poco mas de informes leventa el proceso asi y dime que te arroja
> cuando aplicas el
> ejecrcicio pasado
> pgpool -c -n -d
>
>
2011-08-19 12:05:57 DEBUG: pid 11441: key: listen_addresses
2011-08-19 12:05:57 DEBUG: pid 11441: value: '*' kind: 4
2011-08-19 12:05:57 DEBUG: pid 11441: key: port
2011-08-19 12:05:57 DEBUG: pid 11441: value: 9999 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: pcp_port
2011-08-19 12:05:57 DEBUG: pid 11441: value: 9898 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: socket_dir
2011-08-19 12:05:57 DEBUG: pid 11441: value: '/var/run/postgresql/' kind: 4
2011-08-19 12:05:57 DEBUG: pid 11441: key: pcp_socket_dir
2011-08-19 12:05:57 DEBUG: pid 11441: value: '/var/run/postgresql/' kind: 4
2011-08-19 12:05:57 DEBUG: pid 11441: key: backend_socket_dir
2011-08-19 12:05:57 DEBUG: pid 11441: value: '/var/run/postgresql/' kind: 4
2011-08-19 12:05:57 DEBUG: pid 11441: key: pcp_timeout
2011-08-19 12:05:57 DEBUG: pid 11441: value: 10 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: num_init_children
2011-08-19 12:05:57 DEBUG: pid 11441: value: 32 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: max_pool
2011-08-19 12:05:57 DEBUG: pid 11441: value: 4 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: child_life_time
2011-08-19 12:05:57 DEBUG: pid 11441: value: 300 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: connection_life_time
2011-08-19 12:05:57 DEBUG: pid 11441: value: 0 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: child_max_connections
2011-08-19 12:05:57 DEBUG: pid 11441: value: 0 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: client_idle_limit
2011-08-19 12:05:57 DEBUG: pid 11441: value: 0 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: authentication_timeout
2011-08-19 12:05:57 DEBUG: pid 11441: value: 60 kind: 2
2011-08-19 12:05:57 DEBUG: pid 11441: key: logdir
2011-08-19 12:05:57 DEBUG: pid 11441: value: '/var/run/postgresql/' kind: 4
2011-08-19 12:05:57 DEBUG: pid 11441: key: pid_file_name
2011-08-19 12:05:57 DEBUG: pid 11441: value:
'/var/run/postgresql/pgpool.pid' kind: 4
2011-08-19 12:05:57 DEBUG: pid 11441: key: replication_mode
2011-08-19 12:05:57 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:57 DEBUG: pid 11441: key: load_balance_mode
2011-08-19 12:05:57 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:57 DEBUG: pid 11441: key: replication_stop_on_mismatch
2011-08-19 12:05:57 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:57 DEBUG: pid 11441: replication_stop_on_mismatch: 1
2011-08-19 12:05:57 DEBUG: pid 11441: key: replicate_select
2011-08-19 12:05:57 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: replicate_select: 0
2011-08-19 12:05:58 DEBUG: pid 11441: key: reset_query_list
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'ABORT; RESET ALL; SET SESSION
AUTHORIZATION DEFAULT' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: extract_string_tokens: token: ABORT
2011-08-19 12:05:58 DEBUG: pid 11441: extract_string_tokens: token: RESET
ALL
2011-08-19 12:05:58 DEBUG: pid 11441: extract_string_tokens: token: SET
SESSION AUTHORIZATION DEFAULT
2011-08-19 12:05:58 DEBUG: pid 11441: key: print_timestamp
2011-08-19 12:05:58 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: master_slave_mode
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: connection_cache
2011-08-19 12:05:58 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: health_check_timeout
2011-08-19 12:05:58 DEBUG: pid 11441: value: 20 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: health_check_period
2011-08-19 12:05:58 DEBUG: pid 11441: value: 60 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: health_check_user
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'postgres' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: failover_command
2011-08-19 12:05:58 DEBUG: pid 11441: value: '' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: failback_command
2011-08-19 12:05:58 DEBUG: pid 11441: value: '' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: fail_over_on_backend_error
2011-08-19 12:05:58 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: insert_lock
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: ignore_leading_white_space
2011-08-19 12:05:58 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: log_statement
2011-08-19 12:05:58 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: log_per_node_statement
2011-08-19 12:05:58 DEBUG: pid 11441: value: true kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: log_connections
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: log_hostname
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: parallel_mode
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: enable_query_cache
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: pgpool_hostname
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'nodo1' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: system_db_hostname
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'nodo1' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: system_db_port
2011-08-19 12:05:58 DEBUG: pid 11441: value: 5432 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: system_db_dbname
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'pgpool' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: system_db_schema
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'pgpool_catalog' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: system_db_user
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'pgpool' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: system_db_password
2011-08-19 12:05:58 DEBUG: pid 11441: value: '' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_hostname0
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'nodo1' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_port0
2011-08-19 12:05:58 DEBUG: pid 11441: value: 5432 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_weight0
2011-08-19 12:05:58 DEBUG: pid 11441: value: 1 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_data_directory0
2011-08-19 12:05:58 DEBUG: pid 11441: value: '/var/lib/postgresql/8.4/main'
kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_hostname1
2011-08-19 12:05:58 DEBUG: pid 11441: value: '192.168.4.162' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_port1
2011-08-19 12:05:58 DEBUG: pid 11441: value: 5432 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_weight1
2011-08-19 12:05:58 DEBUG: pid 11441: value: 1 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: backend_data_directory1
2011-08-19 12:05:58 DEBUG: pid 11441: value: '/var/lib/postgresql/8.4/main'
kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: enable_pool_hba
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: key: recovery_user
2011-08-19 12:05:58 DEBUG: pid 11441: value: 'postgres' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: recovery_password
2011-08-19 12:05:58 DEBUG: pid 11441: value: '' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: recovery_1st_stage_command
2011-08-19 12:05:58 DEBUG: pid 11441: value: '' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: recovery_2nd_stage_command
2011-08-19 12:05:58 DEBUG: pid 11441: value: '' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: recovery_timeout
2011-08-19 12:05:58 DEBUG: pid 11441: value: 90 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: client_idle_limit_in_recovery
2011-08-19 12:05:58 DEBUG: pid 11441: value: 0 kind: 2
2011-08-19 12:05:58 DEBUG: pid 11441: key: lobj_lock_table
2011-08-19 12:05:58 DEBUG: pid 11441: value: '' kind: 4
2011-08-19 12:05:58 DEBUG: pid 11441: key: ssl
2011-08-19 12:05:58 DEBUG: pid 11441: value: false kind: 1
2011-08-19 12:05:58 DEBUG: pid 11441: weight: 1073741823

> 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
>
>
Ok.

> repite el ejercico y comenta que resultados te da
>
>

Sigue presentando el mismo log

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

>
>
>
> 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
>
>

--

*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