Skip to content

Instantly share code, notes, and snippets.

@souhaiebtar

souhaiebtar/backup_and_restore_postgres_database.sh

Created March 5, 2025 13:35
Show Gist options
  • Save souhaiebtar/f30ef473bc17d60d511d8f6998633187 to your computer and use it in GitHub Desktop.
Save souhaiebtar/f30ef473bc17d60d511d8f6998633187 to your computer and use it in GitHub Desktop.
Download ZIP
[Backup and restore a postgres dump] Backup and restore a mysql #postgres #database #db
Raw
backup_and_restore_postgres_database.sh
pg_dump -U postgres -d qanda_db -F c -b -v -f output_file.dump
pg_restore -U postgres -v -d test123 .\output_file.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment