[pgpool-general: 1359] Re: failover command

[Yugo Nagata]

On Thu, 24 Jan 2013 19:28:20 -0600
ning chan <ninchan8328 at gmail.com> wrote:

> Can someone help me on this topic?
> 
> 
> On Wed, Jan 23, 2013 at 1:20 PM, ning chan <ninchan8328 at gmail.com> wrote:
> 
> > Hi,
> > In the pgpool.conf, there is a failover command that the listed command
> > can be called when a server failover.
> >
> > I have confusion about the parameters:
> >
> >  # Executes this command at failover
> >                                    # Special values:
> >                                    #   %d = node id
> >                                    #   %h = host name
> >                                    #   %p = port number
> >                                    #   %D = database cluster path
> >                                    #   %m = new master node id
> >                                    #   %H = hostname of the new master node
> >                                    #   %M = old master node id
> >                                    #   %P = old primary node id
> >                                    #   %r = new master port number
> >                                    #   %R = new master database cluster
> > path
> >
> > What is the difference between old primary node id and old master node id?
> >
> > Basically, what is the different between primary and master?
> > Are they defined from postgresql perspective or from pgpool perspective?

Primary node is the primary node of PostgreSQL in streaming replication mode.
Master node is the first living DB node appears in pgpool.conf.

> >
> > Thanks~
> > Ning
> >


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