[pgpool-general: 1754] Re: load balancing, streaming mode and manual promotion

Jeff Frost jeff at pgexperts.com
Thu May 16 09:54:27 JST 2013

On May 15, 2013, at 5:45 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:

>> It's not obvious to me how I should configure the following:
>> Would like to setup streaming replication with load balancing without
>> automatic failover/promotion of a replica when the master goes down.
>> Ideally pgpool would continue to send queries to the replica(s) when the
>> master is down, but require a human to promote it if the master cannot be
>> recovered.
>> Naturally, any write queries will fail, but that's ok.
> No, you cannot prevent both failover and promotion. You just stop
> automatic promotion. Just make "failover_command" and
> "follow_master_command" to be empty (or you could does nothing
> promotion in failover_command). This does prevent automatic promotion
> but does *not* prevent automatic failover, though.
> Also you might want to make recovery_timeout shorter. While failover,
> pgpool tries to find the primary node for recovery_timeout
> seconds. Since the default is 90 seconds, you might to want to change
> it to shorten the black out period caused by failover.

Ah, thank you.  That explains the behavior I'm seeing.

More information about the pgpool-general mailing list