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

[Tatsuo Ishii]

Please tell us the exact pgpool-II version you are using.

Sometimes status = 0 means there are mistakes in pgpool.conf. Please
show us actual (and whole) pgpool.conf.

Also I noticed that you forget to set:

master_slave_sub_mode = 'stream'

(or maybe caused by erronous pgpoo.conf)

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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