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

Wolf Schwurack wolf at uen.org
Fri Aug 2 23:30:01 JST 2013


I got fix I needed to comment out destination_port1

#heartbeat_destination_port1 =

Wolf


-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Wolf Schwurack
Sent: Friday, August 02, 2013 8:14 AM
To: Yugo Nagata
Cc: 'pgpool-general at pgpool.net'
Subject: [pgpool-general: 1988] Re: pgpool.conf - heartbeat

I made the change and restarted pgpool now getting this error

wd_hb_send: host name is empty

Wolf


-----Original Message-----
From: Yugo Nagata [mailto:nagata at sraoss.co.jp] 
Sent: Friday, August 02, 2013 7:57 AM
To: Wolf Schwurack
Cc: 'pgpool-general at pgpool.net'
Subject: Re: [pgpool-general: 1986] pgpool.conf - heartbeat

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>
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list