> Hello, > > I started to use pgpool a few days ago and, while testing it, i am > having some issues to bring nodes back. > > I have 4 nodes running, so i decided to stop one of them. I saw on > logs that its status changed to 3. Ok, perfect. > > Them, i started the failed node again, but its status was still 3.
This is an expected behavior. pgpool does not re-connect recovered node. If pgpool does this, pgpool will repeat connect/disconnect node forever if it's connected through a flakey network. > I decided to stop and start pgpool again, now all nodes have status 3: > > 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 0 th DB node > status: 3 > 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 1 th DB node > status: 3 > 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 2 th DB node > status: 3 > 2009-12-11 11:29:28 DEBUG: pid 1107: health_check: 3 th DB node > status: 3 This is not what I'm expecting. Can you double check you can connect to the DB nodes by: psql -U postgres -h your_db_host_name -p its_port_number template1: For example, psql -U postgres -h im-pp3 -p 4003 template1 Also can you show me the all the log after restarting pgool? -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
