Can the RDS (Oracle/Aurora Posgtgres) manual snapshots be copied to S3 bucket and restored when needed to rebuild an Instance?

As a best practice, you should always have a snapshot for your databases. For longer retention period, you can store your snapshots in S3 and when needed you can restore database from snapshots stored in S3. With RDS, you can export all types of DB snapshots—including manual snapshots, automated system snapshots, and snapshots created by the AWS Backup service. By default, all data in the snapshot is exported. However, you can choose to export specific sets of databases, schemas, or tables.

You can refer below AWS articles for more information

Exporting DB snapshot to S3

• https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html

Restore RDS DB instance snapshot (choose Exports In Amazon S3)

• https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html
• https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Tutorials.RestoringFromSnapshot.html

Thanks, Rajat for sharing details.

I understood that the RDS snapshot can be moved to S3 bucket.

My only concern is can we move back the RDS snapshot to rebuild from it. What I read from AWS old blogs 2022/2021 it seems snapshots are copied to S3 will be in parquet format and restoring is not possible from that snapshot from S3. Please correct me if wrong.

Could someone also share the any document from AWS on how to restore RDS snapshot from S3 ?

Thanks.