pgpool and slony
От | Josh Harrison |
---|---|
Тема | pgpool and slony |
Дата | |
Msg-id | 8d89ea1d0712190946k18af96ebqe1c91ae3128b76f5@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pgpool and slony
Re: pgpool and slony |
Список | 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
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
В списке pgsql-general по дате отправления: