[pgpool-general: 3261] Fwd: [pgpool-II] Master Slave mode / Load Balance Mode / Watchdog On result many primary servers

Scott Li scott.li at gwghk.com
Thu Nov 6 16:52:43 JST 2014


Hi,

      I installed [pgpool-II  Master Slave mode / Load Balance Mode /
Watchdog On
but three postgresql servers are all primary server, shows as below:

IP AddressPortStatusWeightnode 0192.168.35.1505432Up. Connected. Running as
primary serverpostgres: Up0.333   | node 1192.168.35.1515432Up. Connected.
Running as primary serverpostgres: Up0.333   | node 2192.168.35.1525432Up.
Connected. Running as primary serverpostgres: Up0.333   |


[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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141106/0fa0447b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 84227 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141106/0fa0447b/attachment-0001.png>


More information about the pgpool-general mailing list