github.com/cloudberrydb/gpbackup@v1.0.3-0.20240118031043-5410fd45eed6/ci/scripts/gprestore_and_dump.bash (about)

     1  #!/usr/bin/env bash
     2  
     3  set -ex
     4  source env.sh
     5  
     6  # gprestore regression database and use pg_dump to then dump the result
     7  pushd /tmp
     8      db_index=17 # 17 is the regression database
     9      find ./backup_artifact/${db_index} -name "*_metadata.sql" | sed -nr 's#.*gpseg-[0-9]/backups/.*/([0-9]{14})/.*#\1#p' > /tmp/${db_index}_timestamp
    10      read timestamp < /tmp/${db_index}_timestamp
    11      echo "${db_index} timestamp: ${timestamp}"
    12  
    13      echo "##### Restore backup artifact for ${db_index} DB #####"
    14      set +e
    15        gprestore --create-db --timestamp ${timestamp} --backup-dir /tmp/backup_artifact/${db_index} --with-globals --on-error-continue
    16      set -e
    17  
    18      echo "##### pg_dump #####"
    19      set +e
    20        pg_dump regression -f /tmp/post_regression_dump.sql --schema-only
    21      set -e
    22      xz -z /tmp/post_regression_dump.sql
    23  popd