March 2020
Intermediate to advanced
608 pages
17h 17m
English
The backup script will create backup files under /home/myproject/db_backups/ and will save the log at /home/myproject/logs/backup_postgresql_db.log, similar to this:
=== Creating DB Backup ===Fri Jan 17 02:40:55 CET 2020- Dump database- Create a *.gz archive- Create a symlink latest.backup.gz------------------------------------------The operation took 0 minutes and 1 seconds.
If the operation is successful, the script will return exit code 0; otherwise, the exit code will be the number of errors while executing the script. And the log file will show the error messages.
In the db_backups directory, there will be one compressed SQL backup file with the day of the week, such as 0-Sunday.backup.gz, 1-Monday.backup.gz, and so on, ...