Postgres Cheatsheet Dump all PostgreSQL Databases pg_dumpall | gzip -c > /path/to/backup/$(date +'%Y-%m-%d-%H-%M')-db.dump.gz Reimport all PostgreSQL Databases psql -f <pg_dump_file> postgres