1 Answer
- Newest
- Most votes
- Most comments
0
Hi,
Thanks for posting to AWS re:Post. I wanted to share my two cents on the matter here.
In this case you can use DMS - JSONB is supported as a source in PostGreSQL engines.
[] Using a PostgreSQL database as an AWS DMS source - Source data types for PostgreSQL - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source-PostgreSQL-DataTypes
Then, you can refer->
[] Using Amazon S3 as a target for AWS Database Migration Service - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html
Hope this helps.
Relevant content
- asked 6 months ago
- asked 2 years ago
- Accepted Answerasked 3 months ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
I still don't follow how to query the IR in postgres after moving to s3.