[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