[pgpool-hackers: 926] pgpool.conf.sample* update

Darryl Wisneski darryl.wisneski at finalsite.com
Thu Jun 11 04:29:54 JST 2015


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


More information about the pgpool-hackers mailing list