[pgpool-general: 4655] Re: PostgreSQL + Pgpool with 1 master and 2 slaves

[JotaComm]

2016-04-23 2:05 GMT-03:00 Dennis Gearon <gearond at gmail.com>:

> Sorry about top posting. Gmail got away from me before I realized that I
> was writing a mail list.
>
​Hello everybody,

I would like to reproduce this scenery:

The pgpool sends written queries to the master and read queries to the
secondary. Between the master server and the standby server there is a
streaming replication.

My pgpool.conf

backend_hostname0 = 'master1'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/data/pgdata'

backend_hostname1 = 'slave1'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/data/pgdata'

backend_hostname2 = 'slave2'
backend_port2 = 5432
backend_weight2 = 1
backend_data_directory2 = '/data/pgdata'

load_balance_mode = on

When I execute: SHOW pool_nodes; I receive:

 SHOW pool_nodes;
 node_id |  hostname  | port | status | lb_weight |  role  | select_cnt
---------+------------+------+--------+-----------+--------+------------
 0       | master1 | 5432 | 2      | 0.333333  | master | 1
 1       | slave1 | 5432 | 0      | 0.333333  | slave  | 0
 2       | slave2 | 5432 | 0      | 0.333333  | slave  | 0
(3 rows)

Status = 0 - this state is only used during the initialization. PCP will
never display it.

Could you help me?

Thanks a lot.

Best regards


-- 
JotaComm
http://jotacomm.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160425/7c90c15e/attachment.html>