bash script for aurora psql db backup snapshots and export to S3 bucket


To generate a bash script to automate the process of creating snapshots of aroura psql database backup and export the same to s3 bucket with aws iam credentials cron job for every 3 hours and hold snapshots for 30 days

1 Answer

You can use EventBridge to schedule a lambda, then use boto3 to take the snapshot directly to S3, like this example to star/stop the instance, just change the stop_db_cluster for create_db_snapshot, like this example:

rds_client.create_db_snapshot(DBSnapshotIdentifier=snapshot_id, DBInstanceIdentifier=instance_id)

Then create a S3 lifecycle policy to expire the files.

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions