1#!/usr/bin/env bash 2set -euo pipefail 3 4for db in $(psql -Atc 'select datname from pg_database;' postgres); do 5 echo "Updating database ${db}" 6 psql -e -c "reindex (verbose) database ${db};" -c "alter database ${db} refresh collation version;" ${db} & 7done 8 9wait
soopy.moe