read_replicate/replicate_set_connection.sh

Rama main · réplica de lectura del repositorio original.

#!/usr/bin/env bash
set -euo pipefail

# Point the existing subscription at the current source connection string
# (common.sh), for example to pick up options='-c statement_timeout=0' so an
# initial table copy longer than the role's statement_timeout can finish.
# ALTER SUBSCRIPTION ... CONNECTION restarts the apply and copy workers.

SCRIPT_DIR="$(cd "$(dirname "$0")" && pwd)"
# shellcheck source=read_replicate/common.sh
source "${SCRIPT_DIR}/common.sh"

load_replica_target
load_source
discover_subscription "capgo_google_$(replica_region_name)"

# ALTER SUBSCRIPTION only parses the string; it does not connect. Log in with
# the same credentials first so a stale password in .env never replaces a
# working one.
echo "==> Checking the source login..."
psql-17 "$SOURCE_DB_URL" -v ON_ERROR_STOP=1 -tAc 'SELECT 1' >/dev/null

SAFE_CONNECTION_STRING="$(sql_literal_escape "$SOURCE_CONNECTION_STRING")"
echo "==> Updating connection of ${REPLICA_SUBSCRIPTION_NAME}..."
# Through stdin: the password never appears in process arguments.
psql-17 "$REPLICA_TARGET_DB_URL" -v ON_ERROR_STOP=1 <<SQL
ALTER SUBSCRIPTION ${REPLICA_SUBSCRIPTION_NAME} CONNECTION '${SAFE_CONNECTION_STRING}';
SQL
psql-17 "$REPLICA_TARGET_DB_URL" -P pager=off -c "
  SELECT c.relname, r.srsubstate
  FROM pg_subscription_rel r JOIN pg_class c ON c.oid = r.srrelid
  WHERE r.srsubstate <> 'r';"
echo "==> Done."