[pgpool-hackers: 643] Re: [pgpool-II] Master Slave mode / Load Balance Mode / Watchdog On result many primary servers

Tatsuo Ishii ishii at postgresql.org
Thu Nov 6 23:43:13 JST 2014


My wild guess is the installer succeeded in copying data to standby
node but failed to start it as a stanby node. You can examine pgpool's
log and PostgreSQL log to look for the cause.

Another possibility is pgoolAdmin fails to recognize PostgreSQL
status. What does "show pool_nodes" or "select * from
pg_stat_replication" show?

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

> Hi,
> 
>       I installed [pgpool-II  Master Slave mode / Load Balance Mode /
> Watchdog On
> but three postgresql servers are all primary server, shows as below:
> 
> [image: 内嵌图片 1]
> 
> installer2-pg93-3.3.4.tar.gz
> <http://www.pgpool.net/download.php?f=installer2-pg93-3.3.4.tar.gz>
> version: pgpool3.3.4
> 
> pgpool config:
> listen_addresses = '*'
> archive_mode = on
> wal_level = hot_standby
> max_wal_senders = 2
> hot_standby = on
> logging_collector = on
> log_filename = '%A.log'
> log_line_prefix = '%t [%p-%l] '
> log_truncate_on_rotation = on
> pgpool.pg_ctl = '/usr/pgsql-9.3/bin/pg_ctl'
> archive_command = 'cp %p /var/lib/pgsql/arc/%f </dev/null'
> port = 5432
> 
> postgres config:
> listen '*'
> port 5432
> wal_level = hot_standby
> hot_standby = on
> 
> and the install is directed by install.sh under installer2-pg93-3.3.4,
> anybody can help?
> 
> 
> 
> Thanks & Regards
> 
> Scott Li
> 
> -- 
> 
> 
> Confidentiality Warning: This e-mail contains information intended only for 
> the use of the individual or entity named above. If the reader of this 
> e-mail is not the intended recipient or the employee or agent responsible 
> for delivering it to the intended recipient, any dissemination, publication 
> or copying of this e-mail is strictly prohibited. The sender does not 
> accept any responsibility for any loss, disruption or damage to your data 
> or computer system that may occur while using data contained in, or 
> transmitted with, this e-mail. If you have received this e-mail in error, 
> please immediately notify us by return e-mail. Thank you.
> 


More information about the pgpool-hackers mailing list