| 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: | Whole Thread | Raw Message | 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 |