Backup Automatisé S3

import boto3

import subprocess

from datetime import datetime

def backup_database():

    timestamp = datetime.now().strftime('%Y%m%d_%H%M%S')

    backup_file = f'backup_{timestamp}.sql'

    # Create database dump

    subprocess.run([

        'pg_dump',

        '-U', 'postgres',

        '-d', 'production_db',

        '-f', backup_file

    ])

    # Upload to S3

    s3 = boto3.client('s3')

    s3.upload_file(backup_file, 'my-backups-bucket', backup_file)

    print(f'Backup completed: {backup_file}')

if __name__ == '__main__':

    backup_database()