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

[Job Cespedes]

Hi,

Maybe it's bacause some Hot Standby/Streaming Replication config is missing
for postgres backend nodes. Is there a recovery.conf file present in the
$pgdata directory of hot_standby nodes? ¿Is the status of postgres services
in hot_standby_nodes "online,recovery"? You could check this link
<https://wiki.postgresql.org/wiki/Streaming_Replication> it both answers
are no.

2014-11-06 1:52 GMT-06:00 Scott Li <scott.li at gwghk.com>:

> 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 2
> 192.168.35.1525432Up. Connected. Running as primary serverpostgres: Up
> 0.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.
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>


-- 
Job Céspedes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141106/7bfa154f/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/7bfa154f/attachment-0001.png>