[pgpool-hackers: 930] Re: pgpool.conf.sample* update
Darryl Wisneski
darryl.wisneski at finalsite.com
Fri Jun 12 04:58:33 JST 2015
On Thu, Jun 11, 2015 at 07:56:02AM +0900, Tatsuo Ishii wrote:
> 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.
Four diffs are included.
diff --git a/src/sample/pgpool.conf.sample b/src/sample/pgpool.conf.sample
index 0eaf98a..9a431ed 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..ade0ba4 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..51fc59a 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..97bdacb 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
Best Regards,
-dkw
More information about the pgpool-hackers
mailing list