nk20-scripts/shell/backup_db

#!/bin/bash
# Create temporary backups directory
mkdir -p /tmp/note-backups
date=$(date +%Y-%m-%d)
# Backup database and save it as tar archive
sudo -u postgres pg_dump -F t note_db > "/tmp/note-backups/$date.sql"
# Compress backup as gzip
gzip "/tmp/note-backups/$date.sql"
scp "/tmp/note-backups/$date.sql.gz" "club-bde@zamok.crans.org:backup/$date.sql.gz"
:heavy_plus_sign: Backup database script 2020-08-06 07:26:16 +00:00			`#!/bin/bash`
Backups are sent to Zamok 2020-09-08 11:16:03 +00:00			`# Create temporary backups directory`
Update backup script Remove useless tee, use "mkdir -p" and use .sql.gz. 2023-08-31 10:21:48 +00:00			`mkdir -p /tmp/note-backups`
:heavy_plus_sign: Backup database script 2020-08-06 07:26:16 +00:00			`date=$(date +%Y-%m-%d)`
			`# Backup database and save it as tar archive`
Update backup script Remove useless tee, use "mkdir -p" and use .sql.gz. 2023-08-31 10:21:48 +00:00			`sudo -u postgres pg_dump -F t note_db > "/tmp/note-backups/$date.sql"`
:heavy_plus_sign: Backup database script 2020-08-06 07:26:16 +00:00			`# Compress backup as gzip`
Update backup script Remove useless tee, use "mkdir -p" and use .sql.gz. 2023-08-31 10:21:48 +00:00			`gzip "/tmp/note-backups/$date.sql"`
			`scp "/tmp/note-backups/$date.sql.gz" "club-bde@zamok.crans.org:backup/$date.sql.gz"`