PostgreSQL Backup Best Practices
Regular backups are essential for disaster recovery.
pg_dump for Backups
# Full backup
pg_dump -U postgres dbname > backup.sql
# Compressed backup
pg_dump -U postgres dbname | gzip > backup.sql.gz
# Custom format (recommended)
pg_dump -Fc -U postgres dbname > backup.dumpAutomated Backup Script
#!/bin/bash
DATE=$(date +%Y%m%d_%H%M%S)
pg_dump -Fc mydb > /backups/db_$DATE.dump
find /backups -mtime +7 -delete
Discussion 0
No comments yet. Be the first to start the discussion!
Leave a Comment