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

Darryl Wisneski darryl.wisneski at finalsite.com
Fri Jun 12 05:16:56 JST 2015


One more time changing '=' to ':'. 

diff --git a/src/sample/pgpool.conf.sample b/src/sample/pgpool.conf.sample
index 0eaf98a..cca4d38 100644
--- a/src/sample/pgpool.conf.sample
+++ b/src/sample/pgpool.conf.sample
@@ -338,23 +338,6 @@ delay_threshold = 0
                                    # Unit is in bytes
                                    # Disabled (0) by default

-# - Special commands -
-
-follow_master_command = ''
-                                   # Executes this command after master 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
-                                   #   %% = '%' character
-
 #------------------------------------------------------------------------------
 # HEALTH CHECK
 #------------------------------------------------------------------------------
@@ -386,32 +369,48 @@ connect_timeout = 10000

 failover_command = ''
                                    # 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
-                                   #   %% = '%' character
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
 failback_command = ''
                                    # Executes this command at failback.
-                                   # 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
-                                   #   %% = '%' character
+                                   # Special character: description
+                                   # %d: backend id of attached node
+                                   # %h: hostname of attached node
+                                   # %p: port number of attached node
+                                   # %D: database cluster directory of attached node
+                                   # %M: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
+follow_master_command = ''
+                                   # Executes this command after master failover
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character

 fail_over_on_backend_error = on
                                    # Initiates failover when reading/writing to the
diff --git a/src/sample/pgpool.conf.sample-master-slave b/src/sample/pgpool.conf.sample-master-slave
index 9ec470a..c527fbe 100644
--- a/src/sample/pgpool.conf.sample-master-slave
+++ b/src/sample/pgpool.conf.sample-master-slave
@@ -337,23 +337,6 @@ delay_threshold = 0
                                    # Unit is in bytes
                                    # Disabled (0) by default

-# - Special commands -
-
-follow_master_command = ''
-                                   # Executes this command after master 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
-                                   #   %% = '%' character
-
 #------------------------------------------------------------------------------
 # HEALTH CHECK
 #------------------------------------------------------------------------------
@@ -385,33 +368,48 @@ connect_timeout = 10000

 failover_command = ''
                                    # 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
-
-                                   #   %% = '%' character
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
 failback_command = ''
-                                   # Executes this command at failback.
-                                   # 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
-                                   #   %% = '%' character
+                                   # Executes this command at failback
+                                   # Special character: description
+                                   # %d: backend id of attached node
+                                   # %h: hostname of attached node
+                                   # %p: port number of attached node
+                                   # %D: database cluster directory of attached node
+                                   # %M: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
+follow_master_command = ''
+                                   # Executes this command after master failover
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character

 fail_over_on_backend_error = on
                                    # Initiates failover when reading/writing to the
diff --git a/src/sample/pgpool.conf.sample-replication b/src/sample/pgpool.conf.sample-replication
index a687ad7..9a39e43 100644
--- a/src/sample/pgpool.conf.sample-replication
+++ b/src/sample/pgpool.conf.sample-replication
@@ -337,23 +337,6 @@ delay_threshold = 0
                                    # Unit is in bytes
                                    # Disabled (0) by default

-# - Special commands -
-
-follow_master_command = ''
-                                   # Executes this command after master 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
-                                   #   %% = '%' character
-
 #------------------------------------------------------------------------------
 # HEALTH CHECK
 #------------------------------------------------------------------------------
@@ -385,32 +368,48 @@ connect_timeout = 10000

 failover_command = ''
                                    # 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
-                                   #   %% = '%' character
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
 failback_command = ''
                                    # Executes this command at failback.
-                                   # 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
-                                   #   %% = '%' character
+                                   # Special character: description
+                                   # %d: backend id of attached node
+                                   # %h: hostname of attached node
+                                   # %p: port number of attached node
+                                   # %D: database cluster directory of attached node
+                                   # %M: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
+follow_master_command = ''
+                                   # Executes this command after master failover
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character

 fail_over_on_backend_error = on
                                    # Initiates failover when reading/writing to the
diff --git a/src/sample/pgpool.conf.sample-stream b/src/sample/pgpool.conf.sample-stream
index b3304c4..f60cd44 100644
--- a/src/sample/pgpool.conf.sample-stream
+++ b/src/sample/pgpool.conf.sample-stream
@@ -338,23 +338,6 @@ delay_threshold = 10000000
                                    # Unit is in bytes
                                    # Disabled (0) by default

-# - Special commands -
-
-follow_master_command = ''
-                                   # Executes this command after master 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
-                                   #   %% = '%' character
-
 #------------------------------------------------------------------------------
 # HEALTH CHECK
 #------------------------------------------------------------------------------
@@ -386,32 +369,48 @@ connect_timeout = 10000

 failover_command = ''
                                    # 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
-                                   #   %% = '%' character
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
 failback_command = ''
                                    # Executes this command at failback.
-                                   # 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
-                                   #   %% = '%' character
+                                   # Special character: description
+                                   # %d: backend id of attached node
+                                   # %h: hostname of attached node
+                                   # %p: port number of attached node
+                                   # %D: database cluster directory of attached node
+                                   # %M: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character
+
+follow_master_command = ''
+                                   # Executes this command after master failover
+                                   # 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: node id of old master node
+                                   # %P: node id of old primary node
+                                   # %m: node id of new master node
+                                   # %H: hostname of new master node
+                                   # %r: port number of new master node
+                                   # %R: database cluster directory of new master node
+                                   # %%: '%' character

 fail_over_on_backend_error = on
                                    # Initiates failover when reading/writing to the


More information about the pgpool-hackers mailing list