oofnikj

oofnikj / pg_manage.sh

Last active March 13, 2025 01:05

PostgreSQL dump / restore to Google Cloud Storage

	#!/bin/bash

	PGUSER=${PGUSER:-"postgres"}
	CATALOG_BUCKET="normalized-catalog"

	_get_dbs() {
	psql -U $PGUSER -c "COPY (
	SELECT datname FROM pg_database
	WHERE datname NOT IN (
	'postgres',