Skip to content

Instantly share code, notes, and snippets.

@bibarsov

bibarsov/Postgres Backup And Restore.txt

Created April 13, 2020 22:31
Show Gist options
  • Save bibarsov/5a7dc76bbe9ea0db8dc635bdc4443c47 to your computer and use it in GitHub Desktop.
Save bibarsov/5a7dc76bbe9ea0db8dc635bdc4443c47 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Postgres Backup And Restore.txt
# Source
pg_dump -U postgres database | gzip -9 > db.sql.gz
# Target
gunzip db.sql.gz
PGPASSWORD=example psql -U postgres -d database -f db.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment