Skip to content

Instantly share code, notes, and snippets.

@ZeroCoolHacker

ZeroCoolHacker/Postgres Backup from remote server to localhost

Created February 24, 2022 10:04
Show Gist options
  • Save ZeroCoolHacker/90a2912d6a66dbff6361db8792fcc398 to your computer and use it in GitHub Desktop.
Save ZeroCoolHacker/90a2912d6a66dbff6361db8792fcc398 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Postgres Backup from remote server to localhost
ssh user@machine "pg_dump -U user -h localhost -C --column-inserts" \
> backup_file_on_your_local_machine.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment