summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBo Peng2025-02-26 12:59:18 +0000
committerBo Peng2025-02-26 13:07:36 +0000
commit9f3e8b7a35cdcb073044b0cb56b0c9ba8b31c6e0 (patch)
tree88397e6c3958d7f8a7323b17d46082ab40940b92 /src
parent900e693552626ee1762ccb5140eed5cff706ace9 (diff)
Remove pg_basebackup from the sample follow primary script.
If pg_rewind fails, the safest way for users is to recover manually.
Diffstat (limited to 'src')
-rwxr-xr-xsrc/sample/scripts/follow_primary.sh.sample48
1 files changed, 0 insertions, 48 deletions
diff --git a/src/sample/scripts/follow_primary.sh.sample b/src/sample/scripts/follow_primary.sh.sample
index 8a1d7911c..fb33cdc44 100755
--- a/src/sample/scripts/follow_primary.sh.sample
+++ b/src/sample/scripts/follow_primary.sh.sample
@@ -109,54 +109,6 @@ EOT
"
-# If pg_rewind failed, try pg_basebackup
-if [ $? -ne 0 ]; then
- echo follow_primary.sh: end: pg_rewind failed. Try pg_basebackup.
-
- ssh -T ${SSH_OPTIONS} ${POSTGRESQL_STARTUP_USER}@${NODE_HOST} "
-
- set -o errexit
-
- [ -d \"${NODE_PGDATA}\" ] && rm -rf ${NODE_PGDATA}
- ${PGHOME}/bin/pg_basebackup -h ${NEW_PRIMARY_NODE_HOST} -U $REPLUSER -p ${NEW_PRIMARY_NODE_PORT} -D ${NODE_PGDATA} -X stream
-
- cat > ${RECOVERYCONF} << EOT
-primary_conninfo = 'host=${NEW_PRIMARY_NODE_HOST} port=${NEW_PRIMARY_NODE_PORT} user=${REPLUSER} application_name=${NODE_HOST} passfile=''/var/lib/pgsql/.pgpass'''
-recovery_target_timeline = 'latest'
-primary_slot_name = '${REPL_SLOT_NAME}'
-EOT
-
- if [ ${PGVERSION} -ge 12 ]; then
- sed -i -e \"\\\$ainclude_if_exists = '$(echo ${RECOVERYCONF} | sed -e 's/\//\\\//g')'\" \
- -e \"/^include_if_exists = '$(echo ${RECOVERYCONF} | sed -e 's/\//\\\//g')'/d\" ${NODE_PGDATA}/postgresql.conf
- touch ${NODE_PGDATA}/standby.signal
- else
- echo \"standby_mode = 'on'\" >> ${RECOVERYCONF}
- fi
- sed -i \
- -e \"s/#*port = .*/port = ${NODE_PORT}/\" \
- ${NODE_PGDATA}/postgresql.conf
- "
-
- if [ $? -ne 0 ]; then
-
- # drop replication slot
- ${PGHOME}/bin/psql -h ${NEW_PRIMARY_NODE_HOST} -p ${NEW_PRIMARY_NODE_PORT} postgres \
- -c "SELECT pg_drop_replication_slot('${REPL_SLOT_NAME}');" >/dev/null 2>&1
-
- if [ $? -ne 0 ]; then
- echo ERROR: follow_primary.sh: drop replication slot \"${REPL_SLOT_NAME}\" failed. You may need to drop replication slot manually.
- fi
-
- echo follow_primary.sh: end: pg_basebackup failed
- exit 1
- fi
-
- # start Standby node on ${NODE_HOST}
- ssh -T ${SSH_OPTIONS} ${POSTGRESQL_STARTUP_USER}@${NODE_HOST} $PGHOME/bin/pg_ctl -l /dev/null -w -D ${NODE_PGDATA} start
-
-fi
-
# If start Standby successfully, attach this node
if [ $? -eq 0 ]; then