From: | "Josh Harrison" <joshques(at)gmail(dot)com> |
---|---|
To: | "General postgres mailing list" <pgsql-general(at)postgresql(dot)org> |
Subject: | pgpool and slony |
Date: | 2007-12-19 17:46:15 |
Message-ID: | 8d89ea1d0712190946k18af96ebqe1c91ae3128b76f5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
This is a newbie pgpool question. I have 2 servers (master-slave) and Slony
is doing the replication. I had installed pgpool for load balance where i
had disabled the replication_mode=false and load_balance_mode=true in
pgpool.conf
pcp_node_info gives this output.
-sh-3.00$pcp_node_info 10 localhost 9898 josh postgres 1
172.31.0.67 5432 2 16383.500000
-sh-3.00$ pcp_node_info 10 localhost 9898 josh postgres 0
172.31.0.68 5432 2 16383.500000
So does this mean that pgpool is working properly with slony-1. Also how do
I test to see if the load balancing with pgpool is working properly. What
kind of query will help me confirm that it is load balanced ?
Also will pgpool automate failover? How can I test that?
sorry if my question is silly
thanks
josh
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2007-12-19 17:49:50 | Re: Initdb problem - catch 22? |
Previous Message | Marco Aurélio V. da Silva | 2007-12-19 17:43:26 | Problem with collector statistic |