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

0

I would like to understand if it is recommended to move the manually created RDs snapshot (Oracle/Aurora Postgresql) to S3 bucket (general/infrequent tier) for 1year retention?

If in case the snapshot is needed for rebuilding the instance, what is the process of restoring the snapshots from S3 bucket and deploying the RDs instance from it.

Appreciate if someone could suggest on possible solutions. Thanks,

Bob
demandé il y a 6 mois281 vues
2 réponses
0

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

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

AWS
répondu il y a 6 mois
0

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.

Bob
répondu il y a 6 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions