如何将导出的RDS快照从S3还原到RDS群集
我有一个AWS RDS Aurora PostgreSQL群集（与PostgreSQL 13.4兼容）。
i 成功地跟随将我的PostgreSQL RDS Aurora群集快照备份到S3，似乎所有数据都备份到S3。
现在，我正在尝试将导出的快照从S3恢复到PostgreSQL RDS群集，但我找不到解释方法。
知道该怎么做吗？也许我需要首先将导出的数据从S3恢复到快照，然后将其连接到RDS或其他任何方式？
I have an AWS RDS Aurora PostgreSQL cluster (compatible with PostgreSQL 13.4).
I successfully followed this tutorial to back up my PostgreSQL RDS aurora cluster snapshot to S3, and it seems that all the data is backed up to s3.
Now I'm trying to restore the exported snapshot from S3 to PostgreSQL RDS cluster, and I couldn't find explanation how to do it.
Any idea how to do it? maybe I need to first restore the exported data from S3 to snapshot, and then connect it to to RDS, or any other way?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
rds snapshot to s3 export to s3 export for S3 Export for for for hte 是其他预期的备份您的数据。它旨在将您的数据转换为Parquet，以用于Redshift或Athena等分析工具。某些数据类型转换发生在此导出过程中。
当前没有可用的方法将这些镶木文件导入RDS中。如果需要，您必须自己编写一些代码来读取镶木quet文件并将数据插入运行的RDS实例中。
如果除了RDS快照之外，您还只想对RDS实例进行辅助备份，则可以查看跨区域或跨境 rds快照的副本，或查看使用 aws备份服务。
The RDS Snapshot to S3 export feature is not intended for additional backups of your data. It is intended to convert your data to Parquet for use in analytics tools like Redshift or Athena. Some data type conversion happens during this export process.
There is currently no method available to import these Parquet files back into RDS. You would have to write some code yourself to read the Parquet files and insert the data back into a running RDS instance if you needed that.
If you are just wanting a secondary backup of your RDS instance in addition to the RDS snapshots, you could either look into cross-region or cross-account copies of your RDS snapshots, or look into using the AWS Backup service.