From 566a48e8c5a1ed8efbcef143322ac1bea54882f9 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Wed, 5 Aug 2020 10:47:06 +0900 Subject: [PATCH] Fix pgpool_setup problem with -r option and PostgreSQL 12. pgpool_setup -r uses pg_rewind if it's possible. After rewinding, pgpool_setup failed to create standby.signal file, which is required in PostgreSQL 12 or later, on the recovered target node. As a result, the recovered node booted up as a primary server, rather than a standby server. Discussion: https://www.pgpool.net/mantisbt/view.php?id=624 --- src/test/pgpool_setup | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/test/pgpool_setup b/src/test/pgpool_setup index d66ee783a..1c16ec444 100755 --- a/src/test/pgpool_setup +++ b/src/test/pgpool_setup @@ -331,6 +331,7 @@ PORT=$4 log=$DATADIR_BASE/log/recovery.log touch standby.signal +touch $DEST_CLUSTER/standby.signal $psql -p $PORT -c "SELECT pg_start_backup('Streaming Replication', true)" postgres @@ -351,7 +352,7 @@ rm -fr $DEST_CLUSTER/pg_wal mkdir $DEST_CLUSTER/pg_wal chmod 700 $DEST_CLUSTER/pg_wal -rm $DEST_CLUSTER/recovery.done standby.signal +rm $DEST_CLUSTER/recovery.done rm standby.signal EOF -- 2.39.5