Skip to content

Instantly share code, notes, and snippets.

@ayrilmaz

ayrilmaz/pb_dump.sh

Created July 4, 2021 14:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ayrilmaz/ccc7d1c2b593713fb9ab14de56e284f4 to your computer and use it in GitHub Desktop.
Save ayrilmaz/ccc7d1c2b593713fb9ab14de56e284f4 to your computer and use it in GitHub Desktop.
Download ZIP
Crontab Postgres backup command
Raw
pb_dump.sh
0 8 * * * sudo pg_dump --blobs -Fc --no-owner --dbname=postgresql://backuper:backup_user@localhost:5432/db_name | gzip > /root/Yandex.Disk/Postgres/`date '+\%m-\%d-\%Y'`.gzip
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment