Dump a copy of all databases in CockroachDB

run.sh

#!/bin/bash

set -e

# ---------
# Variables
# ---------

dbHost=$COCKROACH_HOST
if [[ -z $dbHost ]]; then
    dbHost=localhost
fi

dbPort=$COCKROACH_PORT
if [[ -z $dbPort ]]; then
    dbPort=26257
fi

dbUser=$COCKROACH_USER
if [[ -z $dbUser ]]; then
    dbUser=root
fi

timestamp=$(date +%Y-%M-%d_%T)

# --------
# Commands
# --------

# List of databases
databasesCmd="psql
  -h ${dbHost}
  -p ${dbPort}
  -U ${dbUser}
  -d system
  -c \"SELECT datname FROM pg_database WHERE datistemplate = false AND datname != 'system'\" -A -t"

eval $databasesCmd | while read db; do
    echo Backing up $db
    file=$db-$timestamp.sql.gz

    # Dump SQL to file
    cockroach dump --insecure $db | gzip > $file

    # Cleanup
    rm $file
done