pgpool2.git / summary / log / commit / refs

commit    7f3e97158208b45f15f46ff4c10b8f346bf26cf7
Author:   Bo Peng <pengbo@sraoss.co.jp>
Date:     Fri Sep 25 08:12:35 2020 +0000

    Logging sample scripts to pgpool stdout


 src/sample/scripts/failover.sh.sample         |  1 -
 src/sample/scripts/follow_primary.sh.sample   |  1 -
 src/sample/scripts/pgpool_remote_start.sample |  1 -
 src/sample/scripts/recovery_1st_stage.sample  |  1 -
 src/sample/scripts/recovery_2nd_stage.sample  | 10 ++++++----
 5 files changed, 6 insertions(+), 8 deletions(-)

diff --git a/src/sample/scripts/failover.sh.sample b/src/sample/scripts/failover.sh.sample
index 9e0ec0c66..c2d9d0ebe 100755
--- a/src/sample/scripts/failover.sh.sample
+++ b/src/sample/scripts/failover.sh.sample
@@ -2,7 +2,6 @@
 # This script is run by failover_command.
 
 set -o xtrace
-exec > >(logger -i -t pgpool) 2>&1
 
 # Special values:
 #   %d = failed node id
diff --git a/src/sample/scripts/follow_primary.sh.sample b/src/sample/scripts/follow_primary.sh.sample
index 1ff0c0e69..38fd58a3a 100755
--- a/src/sample/scripts/follow_primary.sh.sample
+++ b/src/sample/scripts/follow_primary.sh.sample
@@ -3,7 +3,6 @@
 # First try pg_rewind. If pg_rewind failed, use pg_basebackup.
 
 set -o xtrace
-exec > >(logger -i -t pgpool) 2>&1
 
 # Special values:
 #   %d = failed node id
diff --git a/src/sample/scripts/pgpool_remote_start.sample b/src/sample/scripts/pgpool_remote_start.sample
index ea00d1860..edc5bc320 100755
--- a/src/sample/scripts/pgpool_remote_start.sample
+++ b/src/sample/scripts/pgpool_remote_start.sample
@@ -2,7 +2,6 @@
 # This script is run after recovery_1st_stage to start Standby node.
 
 set -o xtrace
-exec > >(logger -i -t pgpool) 2>&1
 
 DEST_NODE_HOST="$1"
 DEST_NODE_PGDATA="$2"
diff --git a/src/sample/scripts/recovery_1st_stage.sample b/src/sample/scripts/recovery_1st_stage.sample
index 0693936f8..8b874279f 100755
--- a/src/sample/scripts/recovery_1st_stage.sample
+++ b/src/sample/scripts/recovery_1st_stage.sample
@@ -2,7 +2,6 @@
 # This script is executed by "recovery_1st_stage" to recovery a Standby node.
 
 set -o xtrace
-exec > >(logger -i -t pgpool) 2>&1
 
 PRIMARY_NODE_PGDATA="$1"
 DEST_NODE_HOST="$2"
diff --git a/src/sample/scripts/recovery_2nd_stage.sample b/src/sample/scripts/recovery_2nd_stage.sample
index b110fc64e..69e3cc1da 100755
--- a/src/sample/scripts/recovery_2nd_stage.sample
+++ b/src/sample/scripts/recovery_2nd_stage.sample
@@ -1,15 +1,17 @@
-#! /bin/sh
+#!/bin/bash
 # Online recovery 2nd stage script
-#
+
+set -o xtrace
+
 DATADIR=$1		# main dabatase cluster
 DEST=$2			# hostname of the DB node to be recovered
 DESTDIR=$3		# database cluster of the DB node to be recovered
 PORT=$4		    # PostgreSQL port number
 
-PGHOME=/usr/pgsql-11
+PGHOME=/usr/pgsql-13
 ARCHIVEDIR=/var/lib/pgsql/archivedir  # archive log directory
 
-# Force to flush current value of sequences to xlog 
+# Force to flush current value of sequences to xlog
 ${PGHOME}/bin/psql -p $PORT -t -c 'SELECT datname FROM pg_database WHERE NOT datistemplate AND datallowconn' template1|
 while read i
 do


[parent: a01fe35acbbe]