Original working file
export.sh
Code and working example pages keep their original identifiers and sample text. The lesson and file guidance explain them in your language.
#!/usr/bin/env bash
set -euo pipefail
umask 077
read -r -s -p 'SOURCE practice database connection URL: ' SOURCE_DATABASE_URL
printf '\n'
mkdir -p backups
pg_dump --dbname="$SOURCE_DATABASE_URL" --format=custom --table=public.backup_practice_notes --no-owner --no-privileges --file=backups/practice-notes.dump
pg_restore --list backups/practice-notes.dump > backups/contents.txt
shasum -a 256 backups/practice-notes.dump > backups/checksum.txt
printf 'Export created. Restore verification is still required.\n'