[pgpool-general: 1987] Re: pgpool.conf - heartbeat

[Yugo Nagata]

On Fri, 2 Aug 2013 13:36:02 +0000
Wolf Schwurack <wolf at uen.org> wrote:

> I have a question on heartbeat. I have two pgpool servers - hostA and hostB.
> In pgpool.conf for hostA what should I set parameter heartbeat_destination0 = ???
> 
> This is what I have the parameters set, is this correct?
> 
> hostA (primary) - pgpool.conf
> 
> 
> 
> heartbeat_destination0 = 'hostA'
> 
> heartbeat_destination_port0 = 9694
> 
> heartbeat_destination1 = 'hostB'
> 
> heartbeat_destination_port1 = 9694
> 
> other_pgpool_hostname0 = 'hostB'
> 
> other_pgpool_port0 = 9999


This would works, but heartbeat for hostA isn't necessary.
The following is enough; 

heartbeat_destination0 = 'hostB'

heartbeat_destination_port0 = 9694
 
other_pgpool_hostname0 = 'hostB'

other_pgpool_port0 = 9999

> 
> 
> 
> hostB (standby) -  pgpool.conf
> 
> 
> 
> heartbeat_destination0 = 'hostB'
> 
> heartbeat_destination_port0 = 9694
> 
> heartbeat_destination1 = 'hostA'
> 
> heartbeat_destination_port1 = 9694
> 
> other_pgpool_hostname0 = 'hostA'
> 
> other_pgpool_port0 = 9999

Ditto.

heartbeat_destination0 = 'hostA'

heartbeat_destination_port0 = 9694

other_pgpool_hostname0 = 'hostA'

other_pgpool_port0 = 9999

> 
> 
> 
> 
>       0___      Wolfgang Schwurack
>      c/  /'_    DBA/SA
>     (*)  \(*)   University of Utah/UEN
>                 Tel: (801) 587-9444
>                 email: wolf at uen.org
> 


-- 
Yugo Nagata <nagata at sraoss.co.jp>