TRAE-Skills

Here's a Python script to automate daily database backups for a PostgreSQL database:

```python
import os
import subprocess
from datetime import datetime

def backup_database():
    # Define backup directory
    backup_dir = '/path/to/backups'
    os.makedirs(backup_dir, exist_ok=True)
    
    # Generate timestamp for backup file
    timestamp = datetime.now().strftime('%Y%m%d_%H%M%S')
    backup_file = os.path.join(backup_dir, f'backup_{timestamp}.sql')
    
    # Execute pg_dump command
    command = f'pg_dump -U username -h localhost -F c -b -v -f {backup_file} database_name'
    try:
        subprocess.run(command, shell=True, check=True)
        print(f'Backup completed successfully: {backup_file}')
    except subprocess.CalledProcessError as e:
        print(f'Backup failed: {e}')

if __name__ == '__main__':
    backup_database()
```

This script creates a compressed backup of the specified PostgreSQL database, includes verbose output for logging, and handles errors gracefully. The backup files are named with timestamps for easy identification.