[pgpool-hackers: 927] Re: pgpool.conf.sample* update

Tatsuo Ishii ishii at postgresql.org
Thu Jun 11 07:56:02 JST 2015


Thanks for the patch. Looks good. It would be nice if you could
provide patches for other configuration files *.sample-stream,
*.sample-replication, and *.sample-master-slave.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi, 
> 
> Here is a diff for ./src/sample/pgpool.conf.sample to keep the
> sample configuration files matched with the up-2-date docs at
> http://www.pgpool.net/docs/latest/pgpool-en.html.  The same changes
> can go in *.sample-stream, *.sample-replication, and *.sample-master-slave.
> 
> long answer:
> I fumbled around for a while with the 'special characters' to
> follow_master_command, trying to use the Special value of 'hostname
> of the old master node', but it wasn't clear to me which value to
> use going by the special value names supplied in the configuration
> examples.  I was only looking at the supplied example pgpool.conf.sample.
> I found the codes clearly defined in src/main/pgpool_main.c, and
> then I found http://www.pgpool.net/docs/latest/pgpool-en.html has
> the special characters definitions clearly listed too.
> 
> --- pgpool.conf.sample	2015-02-05 05:33:03.000000000 -0500
> +++ pgpool.conf.sample.new	2015-06-10 15:21:47.000000000 -0400
> @@ -342,17 +342,17 @@
> 
>  follow_master_command = ''
>                                     # Executes this command after master failover
> -                                   # Special values:
> -                                   #   %d = node id
> -                                   #   %h = host name
> -                                   #   %p = port number
> -                                   #   %D = database cluster path
> +                                   #   Special Character = Description
> +                                   #   %d = backend id of detached node
> +                                   #   %h = hostname of detached node
> +                                   #   %p = port number of detached node
> +                                   #   %D = database cluster directory of detached node
> +                                   #   %M = old master node id
>                                     #   %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
> +                                   #   %R = new master database cluster directory
>                                     #   %% = '%' character
> 
>  #------------------------------------------------------------------------------
> @@ -386,31 +386,31 @@
> 
>  failover_command = ''
>                                     # Executes this command at failover
> -                                   # Special values:
> -                                   #   %d = node id
> -                                   #   %h = host name
> -                                   #   %p = port number
> -                                   #   %D = database cluster path
> +                                   #   Special Character = Description
> +                                   #   %d = backend id of detached node
> +                                   #   %h = hostname of detached node
> +                                   #   %p = port number of detached node
> +                                   #   %D = database cluster directory of detached node
> +                                   #   %M = old master node id
>                                     #   %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
> +                                   #   %R = new master database cluster directory
>                                     #   %% = '%' character
>  failback_command = ''
>                                     # Executes this command at failback.
> -                                   # Special values:
> -                                   #   %d = node id
> -                                   #   %h = host name
> -                                   #   %p = port number
> -                                   #   %D = database cluster path
> +                                   #   Special Character = Description
> +                                   #   %d = backend id of detached node
> +                                   #   %h = hostname of detached node
> +                                   #   %p = port number of detached node
> +                                   #   %D = database cluster directory of detached node
> +                                   #   %M = old master node id
>                                     #   %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
> +                                   #   %R = new master database cluster directory
>                                     #   %% = '%' character
> 
> 
> Best,
> -dkw
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers


More information about the pgpool-hackers mailing list