pg_dump -U username -h localhost -p 5432 -F c -d database_name > backup_file_name.backup pg_dumpall -U username -h localhost -p 5432 -f backup_file_name.backup pg_restore -U username -h localhost -p 5432 -d database_name backup_file_name.backup bash #!/bin/bash backup_dir="/path/to/backup/directory" backup_file_name="backup_$(date +%Y%m%d).backup" pg_dump -U username -h localhost -p 5432 -F c -d database_name > "$backup_dir/$backup_file_name" find "$backup_dir" -mtime +7 -name 'backup_*' -exec rm {} \; crontab -e 0 3 * * * /path/to/backup_script.sh