Dumping an entire postgres database

pg_dump command

#!/usr/bin/env bash

datetimestamp() {
  local datebin="date";
  $datebin --resolution > /dev/null 2>&1 || datebin="gdate";
  $datebin --resolution > /dev/null 2>&1 || datebin="date";
  local format=${DATETIMESTAMPFORMAT:-'+%Y%m%d%H%M%S'};
  case "$1" in
    --date=* | -d=*)
      $datebin --date="${1#*=}" "$format"
    ;;
    --date | -d)
      $datebin --date="$2" "$format"
    ;;
    --help | -h)
      echo "Usage: datetimestamp [--date|-d[=| ]'date']";
      echo " --date|-d [date] date to use, defaults to now, see man date for format details";
      echo " --help|-h     show this help";
      return 0
    ;;
    -*)
      echo "Unknown option: $1" 1>&2;
      datetimestamp -h;
      return 2
    ;;
    *)
      $datebin "$format"
    ;;
  esac
}

pg_dump "$DATABASE_URL" -F c -Z 8 -b -v > ~/database_name-$(datetimestamp).sql
# -F c = format internally-compressed (custom structured binary output format for postgres that also includes additional features)
# -Z 8 = set zlib compression level (1-9)
# -b = use custom binary format that also compresses via zlib
# -v = be verbose