From: | Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | recuperar nodo en estado 3 |
Date: | 2010-03-12 01:31:04 |
Message-ID: | e720c2d1003111731k64f9e006t5d4fe0b74e2176f0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda pgsql-general |
tengo un problema ya habia replicado los datos en las BD
2010-03-11 19:23:58 DEBUG: pid 8252: starting health checking
2010-03-11 19:23:58 DEBUG: pid 8252: health_check: 0 th DB node status: 1
2010-03-11 19:23:58 DEBUG: pid 8252: health_check: 1 th DB node status: 3
2010-03-11 19:24:28 DEBUG: pid 8252: starting health checking
2010-03-11 19:24:28 DEBUG: pid 8252: health_check: 0 th DB node status: 1
2010-03-11 19:24:28 DEBUG: pid 8252: health_check: 1 th DB node status: 3
y me marca eso
lo que hice fue incorporar un nodo en el pg.conf con los mismos datos
que el nodo caido para que me quedara asi
backend_hostname0 = 'pgsql1'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/pgsql/data'
backend_hostname1 = 'pgsql2'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/pgsql/data'
backend_hostname2 = 'pgsql2'
backend_port2 = 5432
backend_weight2 = 1
backend_data_directory2 = '/var/lib/pgsql/data'
y ahora que me conecto me queda asi
2010-03-11 19:27:56 DEBUG: pid 8384: starting health checking
2010-03-11 19:27:56 DEBUG: pid 8384: health_check: 0 th DB node status: 1
2010-03-11 19:27:56 DEBUG: pid 8384: health_check: 1 th DB node status: 3
2010-03-11 19:27:56 DEBUG: pid 8384: health_check: 2 th DB node status: 1
por que el nodo 1 nunca se recupero a pesar de que son los mismos
gracias!!
From | Date | Subject | |
---|---|---|---|
Next Message | Cesar Martin | 2010-03-12 08:00:35 | Re: PGPOOL replica |
Previous Message | ๏̯͡๏ Guido Barosio | 2010-03-12 00:09:31 | Re: Jesus Maria Zabaleta Franco quiere mantener el contacto en LinkedIn |
From | Date | Subject | |
---|---|---|---|
Next Message | jgirvin | 2010-03-12 01:44:27 | Re: dst question |
Previous Message | Joshua D. Drake | 2010-03-11 22:34:40 | PgEast Hotel discount deadline today! |